单项选择题
Why would you use the following FLASHBACK TABLE command？（）
FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；
A. to undo the changes made to the EMP table since the specified time
B. to restore the EMP table that was wrongly dropped from the database
C. to view the transactions that have modified the EMP table since the specified time
D. to view the changes made to the EMP table for one or more rows since the specified time
相关考题
-
多项选择题
Intheparameterfileofyourproductiondatabase，theFAST_START_MTTR_TARGETparameterissetto300tooptimizeinstancerecovery.Whileobservingtheperformanceofthedatabaseduringinstancerecovery，youfindthattheredologfilesarenotsizedproperlytosupportthisactivity.Whichtwosourcescouldyouusetodeterminetheoptimalsizeoftheredologfiles？（）
A. the V$LOG view
B. the V$DBFILE view
C. the V$LOGFILE view
D. the V$INSTANCE_RECOVERY view
E. Oracle Enterprise Manager Database Control -
多项选择题
Younoticedthattheindextablespaceinyourdatabaserequiresarecovery.However，insteadofperformingamediarecovery，youdecidedtore-createtheindexesinanewtablespace.Whichtwooptionswouldyouusetoreducethetimeittakestore-createtheindexes？（）
A. ONLINE
B. REVERSE
C. PARALLEL
D. COMPRESS
E. NOLOGGING
F. COMPUTE STATISTICS -
单项选择题
You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface： SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’， COMMENT => ’New Group’）； This command errorsout displaying the following message： ERROR at line 1： ORA-01031： insufficient privileges ORA-06512： at "SYS.DBMS_RMIN"， line 115 ORA-06512： at SYS.DBMS_RESOURCE_MANAGER"， line 108 ORA-06512： at line 1 What action would you take to overcome this error？（）
A. grant SYSDBA to the user
B. grant SYSOPER to the user
C. grant the RESOURCE role to the user
D. use the GRANT command to grant the ADMINISTER_RESOURCE_MANAGER privilege to the use
E. grant the ADMINISTER_RESOURCE_MANAGER privilege to the user by using the DBMS_RESOURCE_MANAGER_PRIVS package
