A.DBA_TABLESPACES B.DBA_TABLES C.DBA_SEGMENTS D.DBA_FRE……

单项选择题Bydefault,checkpointshappenatleastasoftenas（）.

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