多项选择题
You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）
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 -
多项选择题
WhichtwostatementsregardingtheFLASHBACK_TRANSACTION_QUERYviewarecorrect?（）
A.You can find information about only active transactions from the view
B.You can find information about read only transactions from the view
C.You require the SELECT ANY TRANSACTION system privilege to access the view
D.You can find information about both active and committed transactions from the view
E.You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view
