171、

171.After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance:Select group_number, count(*) from v$asm_operation;What is the implication if the query against V$ASM_OPERATION returns zero rows?A. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.B. The drop disk operation is complete and you can run the undrop disks command if needed.C. The drop disk operation is complete and you cannot run the undrop disk command.D. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.E. None of the above is true.

 

172、

172.What is the net effect of the following command?alter diskgroup dgroup1 drop disk abc;A. The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command, the data on that disk will be lost.B. The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.C. The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped.D. This command will fail because you cannot drop a specific disk in an ASM disk group.E. The disk drop command will be suspended for a predetermined amount of time, waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command, ASM will proceed to rebalance the disk group and then drop the disk.

 

173、

173.Which of the following is not a configurable attribute for an individual disk group?A. AU_SIZEB. COMPATIBLE.RDBMSC. COMPATIBLE.ASMD. DISK_REPAIR_TIMEE. DG_DROP_TIME

 

174、

174.What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode?A. MMONB. LGWRC. ARCHD. ARWRE. COPY

 

175、

175.You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, as shown here:Put the tablespaces in backup mode.Back up the datafiles for all tablespaces.Take the tablespaces out of backup mode.Back up all archived redo logs.Your colleague asks for you to comment on his plan. Which response would be correct?A. The plan will work as is.B. The plan needs to be modified to allow for an archive-log switch after step 3.C. The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.D. The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.E. The plan cannot work as presented.