CMS专题
单选题You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the
题目
ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
ALTER DISKGROUP dg1 UNDROP;
ALTER DISKGROUP dg1 UNDROP DISKS;
You cannot cancel the pending disk drops.
相似问题和答案
第1题：
You are managing an ASM instance. You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK disk3;ALTER DISKGROUP dg1 DROP DISK disk5;You want to cancel the disk drops that are pending for the DG1 disk group.Which statement should you issue?（）
A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
B. ALTER DISKGROUP dg1 UNDROP;
C. ALTER DISKGROUP dg1 UNDROP DISKS;
D. You cannot cancel the pending disk drops.
第2题：
You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch. What do you do？（）
- A、 Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.
- B、 Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to its original value.
- C、 You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.
- D、 If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can correct the problem and perform recovery.
- E、 Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
正确答案:E
第3题：
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :SQL> shutdown immediate;What is the result of executing this command?（）
A. The ASM instance is shut down, but the other instances are still running.
B. It results in an error because other database instances are connected to it.
C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
第4题：
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（）
- A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
- B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
- C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
- D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
正确答案:C
第5题：
You are migrating your production database from non-ASM to ASM storage. You used the RMAN utility to migrate the database from non-ASM to ASM storage. Which type of backup command script will you use for migrating the database from non-ASM to ASM storage？（）
- A、 BACKUP AS BACKUPSET
- B、 BACKUP AS COPY
- C、 BACKUP AS COMPRESSED BACKUPSET
- D、 BACKUP INCREMENTAL LEVEL n CUMULATIVE
正确答案:B
第6题：
You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）
- A、ASM_POWER_LIMIT
- B、ASM_DISKSTRING
- C、ASM_DISKGROUPS
- D、INSTANCE_TYPE
正确答案:A
第7题：
You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario？（）
- A、 The disk is immediately dropped from the disk group.
- B、 The ASM tracks the extents that are modified during the outa
- C、 The ASM migrates the extents from the unavailable disk to the remaining disks.
- D、 The disk automatically goes offline.
正确答案:B,D
第8题：
You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）
A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. INSTANCE_TYPE
第9题：
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?（）
- A、The command succeeds but it retrieves only the disk names.
- B、The command produces an error because the ASM instance is down.
- C、The command succeeds but it shows only the status of the ASM instance.
- D、The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
正确答案:D
第10题：
You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file： INSTANCE_TYPE = ASM ASM_POWER_LIMIT = 11 LARGE_POOL_SIZE = 4M ASM_DISKGROUPS = DG1， DG2 DB_UNIQUE_NAME = +ASM You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）
- A、 only the INSTANCE_TYPE initialization parameter is set to an invalid value
- B、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
- C、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
- D、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values
正确答案:D