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

In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： 
DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； 
What would be the result of this command？（）

You issued the following block of code：       
SQL>BEGIN  
DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（       
’PROG_ROLE’， ’DEVELOPERS’ ，F(xiàn)ALSE）；       
END；       
SQL>/  
Which option is NOT a result of executing the above code？（）  

You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. 
Which method would you follow to achieve this？（） 

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. 
Which option would you use to migrate the database files from a non­ASM instance to an ASM instance？（）

You issued the following RMAN command： 
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；    
What is NOT an impact of using the above command？（）