单项选择题
An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）
A.TEST_TBS is a small file tablespace
B.TEST_TBS is a bigfile tablespace (BFT)
C.TEST_TBS is the default temporary tablespace
D.TEST_TBS is a dictionary-managed tablespace
E.Threshold values for the TEST_TBS tablespace are not explicitly specified
相关考题
-
单项选择题
Youexplicitlyspecifiedthetablespaceusagethresholdvalueswhilecreatingatablespace.Youneedtoreverttothedatabase-widedefaulttablespaceusagethresholdvaluesforthe tablespace.WhichPL/SQLpackagewouldyouuse?（）
A.DBMS_STATS
B.DBMS_ALERT
C.DBMS_SPACE
D.DBMS_MONITOR
E.DBMS_SERVER_ALERT
F.DBMS_SPACE_ADMIN -
多项选择题
Youneedtoensurethatthedatabaseusersshouldbeabletousethevariousflashbackqueryfeaturesinordertogobackintimebyfourhours.Whatwouldyoudotoachievethis?（）
A.set SQL_TRACE=True
B.set UNDO_RETENTION=14400
C.set FAST_START_MTTR_TARGET=240
D.set LOG_CHECKPOINT_INTERVAL=240
E.set DB_FLASHBACK_RETENTION_TARGET=14400
F.set the RETENTION GUARANTEE clause for the undo tablespace -
多项选择题
WhichtwostatementsregardingthePolicyFrameworkinEnterpriseManager(EM)arecorrect?（）
A.Policy violations are prioritized as High, Medium, or Informational by category
B.Policies can be disabled completely, or flagged as ignored, for the specified target
C.Policies can be flagged as ignored, but never completely disabled, for the specified target
D.Policy violations must be corrected, otherwise the database will shut down until corrective action occurs
