单项选择题

A.Redo log switches. B.UPDATE statements are issued aga……

By default, checkpoints happen at least as often as（）.

A.Redo log switches.
B.UPDATE statements are issued against the database.
C.The SYSTEM tablespace is accessed.
D.SMON coalesces free space in a tablespase.

<上一题目录下一题>

热门试题

单项选择题Whichofthefollowingchoicesidentifiesadatabasecomponentthatwillbeusedfor multiplexingcontrolfiles?（）

A.V$CONTROLFILE
B.V$DATABASE
C.init.ora
D.DBA FILES

单项选择题Flushingdirtybuffersoutofthebuffercacheisinfluencedtothegreatestextentbywhichofthefollowingprocess?（）

A.ARCH
B.SMON
C.LGWR
D.SERVER

单项选择题WhichcomponentoftheSGAstoresparsedSQLstatementsisusedforprocesssharing?（）

A.Buffer cache
B.Redo log buffer
C.Private SQL area
D.Library cache
E.Row cache

单项选择题TheuseristryingtoexecuteaSELECTstatement.Whichofthefollowingbackgroundprocesseswillobtaindatafromadiskfortheuser?（）

A.DISPATCHER
B.USER
C.SERVER
D.LGWR
E. DBW0