1z0-043章节练习(2019.05.02)

You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code：       
SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP 
（’SCOTT’，       ’GRP1’， FALSE）；  
How will you grant the switch privilege to the user， Scott？（）  

You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；  
How does RMAN find the control file autobackup？（）

You issue the following RMAN command to set a retention policy on a database：       RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；  
What will be the outcome of the above command？（）

You executed the following query： 
SELECT operation， undo_sql， table_name 
FROM flashback_transaction_query; 
Which statement is correct regarding the query output？（）