单项选择题
When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? ()
A.Size of typical transactions
B.Concurrent transactions
C.Size of rows in table most frequently changed
D.Number of anticipated disk sorts
点击查看答案
相关考题
-
单项选择题
Youaretryingtodeterminehowmanydisksortsarehappeningonthedatabaserightnow.Whichofthefollowingdictionarytableswouldyouusetofindthatinformation?()
A.V$SESSION
B.V$SYSSTAT
C.DBA_SEGMENTS
D.V$SORT_USAGE -
单项选择题
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.
