when ASM disk goes offline
when one or more ASM files are dropped
when some disks in a disk group are offline
when some disks in a failure group for a disk group are rebalancing
第1题:
What is the net effect of the following command?() alter diskgroup dgroup1 drop disk abc;
第2题:
You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours: ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H; Which statement is true in this scenario?()
第3题:
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()
第4题:
You want to perform the following operations for the DATA ASM disk group: -Verify the consistency of the disk. -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks. Which command accomplishes these tasks()?
第5题:
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?()
第6题:
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()
第7题:
when ASM disk goes offline
when one or more ASM files are dropped
when some disks in a disk group are offline
when some disks in a failure group for a disk group are rebalancing
第8题:
Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
第9题:
It cancels all pending disk drops within the disk group.
It restores disks that are being dropped as the result of a DROP DISKGROUP operation
It mounts disks in the disk group for which the drop-disk operation has already been co pleted
It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
It adds previously dropped disks back into the disk group
第10题:
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.
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.
The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete,the disk will be dropped.
This command will fail because you cannot drop a specific disk in an ASM disk group.
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.
第11题:
when one or more file directory paths are accidentally deleted from an ASM disk group
when one of the disks in a disk group is accidentaly unplugged
when the data file on an ASM disk group gets corrupted
when one or more disks in an ASM disk group are lost
第12题:
all disks in the disk group
all disks that are currently in OFFLINE mode
all disks that are not currently in OFFLINE mode
all disks in the disk group only if all of them are ONLINE
第13题:
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?()
第14题:
Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group?()
第15题:
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?()
第16题:
In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?()
第17题:
Examine the CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2; In which situation would you use this method of disk group creation?()
第18题:
You issued the following command to mount the DATA disk group in restricted mode: ALTER DISKGROUP data MOUNT RESTRICT; What is the implication of this command?()
第19题:
when ASM disk goes offline
when one or more ASM files are dropped
when some disks in a disk group are offline
when some disks in a failure group for a disk group are rebalancing
第20题:
When two-way disk mirroring is required for the allocation units
When three-way disk mirroring is required for the allocation units
When using hardware mirroring or RAID
When disk mirroring is required for the Automatic Storage Management (ASM) disks
第21题:
It cancels all pending disk drops within the disk group
It restores disks that are being dropped as the result of a DROP DISKGROUP operation
It mounts disks in the disk group for which the drop-disk operation has already been completed
It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
It adds previously dropped disks back into the disk group
第22题:
The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
The drop disk operation is complete and you can run the undrop disks command if needed.
The drop disk operation is complete and you cannot run the undrop disk command.
The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.
None of the above is true.
第23题:
ALTER DISKGROUP data CHECK
ALTER DISKGROUP data CHECK DISK
ALTER DISKGROUP data CHECK FILE
ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
第24题:
The client RDBMS instance can access the file as a read-only file.
A new disk cannot be added to a disk group.
A disk in a disk group can be taken offline.
The client RDBMS instance cannot access the files in the disk group.