1z0-043單項選擇題每日一練(2019.01.11)

In which scenario will you issue the following command？（）     
SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING       
BACKUP CONTROLFILE；

On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. 
Which statement is correct？（） 

In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. 
What is the best table structure that you can use to gain optimal performance？（）

You issue the following code：  
 EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP       
（’SCOTT’ ’GRP1’， TRUE）；  
What will be the result of executing the above code？（）