单项选择题
You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）
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 -
单项选择题
Youhavethreeproductiondatabases,HRDB,FINDB,andORGDB,thatusethesameASMinstance.Attheendoftheday,youexecutethefollowingcommandontheASMinstancetoshutdown:SQL>shutdownimmediate;Whatistheresultofexecutingthiscommand?（）
A.All the instances, including the ASM instance, are shut down in the ABORT mode
B.The ASM instance is shut down, but the other instances are still running
C.The ASM instance is still functional, but the other instances are shut down
D.All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
E.HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode
F.HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode
