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？（）
A. This command would result in an error because the disk group is not empty.
B. The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
C. The command would result in the contents being moved to the parent disk group and dropping of the disk group.
D. The command would result in the disk group being marked as INVALID because it cannot be dropped.
E. The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.
单项选择题
You issued the following block of code： SQL>BEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（ ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）； END； SQL>/ Which option is NOT a result of executing the above code？（）
A. The switch privilege is granted to the PROG_ROLE role.
B. The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group.
C. The users cannot grant the switch privilege to other users.
D. The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.
单项选择题
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？（）
A.enable index monitoring and query the DBA_OBJECTS view
B.enable index monitoring and query the DBA_INDEXES view
C.enable index monitoring and query the V$OBJECT_USAGE view
D.enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
单项选择题
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 nonASM instance to an ASM instance？（）
A.Oracle Migration Assistant
B.Recovery Manager （RMAN）
C.Oracle Data Pump Export and Import
D.conventional Oracle Export and Import
E.operating system utilities to copy the files to the ASM instance
单项选择题
You issued the following RMAN command： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； What is NOT an impact of using the above command？（）
A. When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
B. When a structural change is made to the database， then a backup of the current control file is performed.
C. When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
D. When a structural change is made to the database， then a backup of the alert log file will be performed.