You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

单项选择题Todeterminethespaceallocatedfortemporarysegments,theDBAcanaccesswhichofthefollowingviews?（）

A.DBA_TABLESPACES 
B.DBA_TABLES 
C.DBA_SEGMENTS 
D.DBA_FREE_SPACE

单项选择题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