单项选择题

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