When a file is created in DGROUP1 with the template, it would have threeway mirroring.
When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
When a file is created in DGROUP1 with the template, it would have twoway mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have threeway mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have twoway mirroring but no file striping.
第1题:
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?()
第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?()
第3题:
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?()
第4题:
When a file is created in DGROUP1 with the template, it would have three-way mirroring.
When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file striping.
第5题:
Failed disks are taken offline immediately but are not dropped.
Disk data is never lost.
By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.
The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.
Hot spare disks are automatically configured and added to the disk group.
第6题:
The disk is immediately dropped from the disk group.
The ASM tracks the extents that are modified during the outa
The ASM migrates the extents from the unavailable disk to the remaining disks.
The disk automatically goes offline.
第7题:
This command would result in an error because the disk group is not empty.
The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
The command would result in the contents being moved to the parent disk group and dropping of the disk group.
The command would result in the disk group being marked as INVALID because it cannot be dropped.
The command would drop the disk group, ignoring the EXCLUDING CONTENTS option.
第8题:
The DGROUP1 disk group was unmounted by another DBA.
A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
One of the redundant disks (DGROUP1) has been lost in a disk group.
This query has no meaning in an ASM instance.
A disk associated with a disk group was discovered after the ASM instance initially opened.
第9题:
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
第10题:
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
第11题:
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.
第12题:
ASMB
ARBn
RBAL in the ASM instance
RBAL in the database instance
第13题:
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()
第14题:
You are the Database Administrator for WonderWeb, which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications, you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group, Automatic Storage Management (ASM) rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity, resulting in the movement of data extents in the disk groups?()
第15题:
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()
第16题:
The command fails unless you specify the FORCE option.
The command fails unless you specify the REUSE option.
The command must be reissued with a more specific discovery string.
The other disks, already part of the disk group,are ignored.
第17题:
When a file is created in DGROUP1 with the template, it would have three-way mirroring.
When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file Striping.
第18题:
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
第19题:
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
第20题:
It starts the ASM fast mirror resync.
All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
It drops all disk paths from the dga disk group.
All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
第21题:
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
第22题:
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
第23题:
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