网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE);Which statement is true?()

  • A、 When a file is created in DGROUP1 with the template, it would have three-way mirroring.
  • B、 When a file is created in DGROUP1, the MY_TEMP template becomes the default template.
  • C、 When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.
  • D、 When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.
  • E、 When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file striping.

参考答案

更多 “You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES (MIRROR FINE);Which statement is true?()A、 When a file is created in DGROUP1 with the template, it would have three-way mirroring.B、 When a file is created in DGROUP1, the MY_TEMP template becomes the default template.C、 When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.D、 When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.E、 When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file striping.” 相关考题
考题 Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?() A. When two-way disk mirroring is required for the allocation unitsB. When three-way disk mirroring is required for the allocation unitsC. When using hardware mirroring or RAIDD. When disk mirroring is required for the Automatic Storage Management (ASM) disks

考题 Examine the following command:ALTER DISKGROUP data MOUNT FORCE;In which scenario can you use the above command to mount the disk group? () A. when ASM disk goes offlineB. when one or more ASM files are droppedC. when some disks in a disk group are offlineD. when some disks in a failure group for a disk group are rebalancing

考题 You want to perform the following operations for the DATA ASM disk group:Which command accomplishes these tasks?() A. ALTER DISKGROUP data CHECK;B. ALTER DISKGROUP data CHECK DISK;C. ALTER DISKGROUP data CHECK FILE;D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 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.

考题 Examine the CREATE DISKGROUP command used to create a disk group:SQL CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK ‘ORCL: FRA3‘ NAME misc1, ‘ORCL: FRA4‘ NAME misc2;In which situation would you use this method of disk group creation?()A. When two-way disk mirroring is required for the allocation unitsB. When three-way disk mirroring is required for the allocation unitsC. When using hardware mirroring or RAIDD. When disk mirroring is required for the Automatic Storage Management (ASM) disks

考题 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.

考题 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.

考题 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?()A、 It starts the ASM fast mirror resync.B、 All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.C、 It drops all disk paths from the dga disk group.D、 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.

考题 Consider the following configuration:   /devices/diskP1 is a member of disk group grp1.        /devices/diskP2 is a member of disk group grp1.        /devices/diskP3 is a member of disk group grp1.        /devices/diskP4 is a candidate disk.        /devices/diskQ1 is a member of disk group grp2.        /devices/diskQ2 is a member of disk group grp2.        /devices/diskQ3 is a member of disk group grp2.        /devices/diskQ4 is a candidate disk.   Which command will add the disk /devices/diskP4 to the disk group, grp1?()  A、 ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP1’,  ADD DISK ’/devices/diskP4’;B、 ALTER DISKGROUP grp1  ADD DISK ’/devices/disk*4’;C、 ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP*’;D、 ALTER DISKGROUP grp1  ADD DISK ’/devices/diskQ*’,  ADD DISK ’/devices/diskP*’;

考题 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.

考题 As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query?() SQL select group_number, name, state from v$ASM_DISKGROUP;  GROUP_NUMBER NAME STATE  0 DGROUP1 DISMOUNTED  2 DGROUP2 MOUNTED  3 DGROUP3 MOUNTED  A、 The DGROUP1 disk group was unmounted by another DBA.B、 A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED stateC、 One of the redundant disks (DGROUP1) has been lost in a disk group.D、 This query has no meaning in an ASM instance.E、 A disk associated with a disk group was discovered after the ASM instance initially opened.

考题 Examine the following command:   ALTER DISKGROUP data MOUNT FORCE;   In which scenario can you use the above command to mount the disk group?()  A、 when ASM disk goes offlineB、 when one or more ASM files are droppedC、 when some disks in a disk group are offlineD、 when some disks in a failure group for a disk group are rebalancing

考题 Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()A、It cancels all pending disk drops within the disk group.B、It restores disks that are being dropped as the result of a DROP DISKGROUP operationC、It mounts disks in the disk group for which the drop-disk operation has already been co pletedD、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE、It adds previously dropped disks back into the disk group

考题 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?()A、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.B、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.C、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.D、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.E、Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.F、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.

考题 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()?A、 ALTER DISKGROUP data CHECKB、 ALTER DISKGROUP data CHECK DISKC、 ALTER DISKGROUP data CHECK FILED、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1

考题 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?()A、 When two-way disk mirroring is required for the allocation unitsB、 When three-way disk mirroring is required for the allocation unitsC、 When using hardware mirroring or RAIDD、 When disk mirroring is required for the Automatic Storage Management (ASM) disks

考题 Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()A、It cancels all pending disk drops within the disk groupB、It restores disks that are being dropped as the result of a DROP DISKGROUP operationC、It mounts disks in the disk group for which the drop-disk operation has already been completedD、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE、It adds previously dropped disks back into the disk group

考题 单选题Consider the following configuration:  /devices/D1is a member of disk group dgroupA.  /devices/D2is a member of disk group dgroupA.  /devices/D3is a member of disk group dgroupA.  You plan to add a new disk, /devices/D4,to the disk group dgroupA.  You execute the following command:  SQL ALTER DISKGROUP dgroupA ADD DISK ’/devices/D*’;  Which task would be accomplished by the command?()A  The command adds the new disk, D4, to the disk group.B  The command would result in an error because the is no disk by the name ’/devices/D*’C  The command will be ignored because disks starting with D are already members of the disk group.D  The command would result in an error because no wildcard characters can be used in the disk name.E  The command first detaches all the member disks starting with D, and the reattaches them including the new disk.

考题 单选题Consider the following configuration:   /devices/diskP1 is a member of disk group grp1.        /devices/diskP2 is a member of disk group grp1.        /devices/diskP3 is a member of disk group grp1.        /devices/diskP4 is a candidate disk.        /devices/diskQ1 is a member of disk group grp2.        /devices/diskQ2 is a member of disk group grp2.        /devices/diskQ3 is a member of disk group grp2.        /devices/diskQ4 is a candidate disk.   Which command will add the disk /devices/diskP4 to the disk group, grp1?()A  ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP1’,  ADD DISK ’/devices/diskP4’;B  ALTER DISKGROUP grp1  ADD DISK ’/devices/disk*4’;C  ALTER DISKGROUP grp1  ADD DISK ’/devices/diskP*’;D  ALTER DISKGROUP grp1  ADD DISK ’/devices/diskQ*’,  ADD DISK ’/devices/diskP*’;

考题 单选题Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? ()A when ASM disk goes offlineB when one or more ASM files are droppedC when some disks in a disk group are offlineD when some disks in a failure group for a disk group are rebalancing

考题 单选题You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group:  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES (MIRROR FINE);  Which statement is true?()A When a file is created in DGROUP1 with the template, it would have three-way mirroring.B When a file is created in DGROUP1, the MY_TEMP template becomes the default template.C When a file is created in DGROUP1 with the template, it would have two-way mirroring and file striping.D When a file is created in DGROUP1 with the template, it would have three-way mirroring and file striping.E When a file is created in DGROUP1 with the template, it would have two-way mirroring but no file Striping.

考题 单选题You have a disk group, DGROUP1, with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group:  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES (MIRROR FINE);  Which statement is true?()A When a file is created in DGROUP1 with the template, it would have three­way mirroring. B When a file is created in DGROUP1, the MY_TEMP template becomes the default template.C When a file is created in DGROUP1 with the template, it would have two­way mirroring and file striping.D When a file is created in DGROUP1 with the template, it would have three­way mirroring and file striping.E When a file is created in DGROUP1 with the template, it would have two­way mirroring but no file striping.

考题 单选题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?()A  It starts the ASM fast mirror resync.B  All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.C  It drops all disk paths from the dga disk group.D  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.

考题 单选题Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()A It cancels all pending disk drops within the disk group.B It restores disks that are being dropped as the result of a DROP DISKGROUP operationC It mounts disks in the disk group for which the drop-disk operation has already been co pletedD It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE It adds previously dropped disks back into the disk group

考题 单选题Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?()A It cancels all pending disk drops within the disk groupB It restores disks that are being dropped as the result of a DROP DISKGROUP operationC It mounts disks in the disk group for which the drop-disk operation has already been completedD It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE It adds previously dropped disks back into the disk group

考题 单选题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.

考题 单选题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.