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

题目内容 (请给出正确答案)
多选题
In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?()
A

when one or more file directory paths are accidentally deleted from an ASM disk group

B

when one of the disks in a disk group is accidentaly unplugged

C

when the data file on an ASM disk group gets corrupted

D

when one or more disks in an ASM disk group are lost


参考答案

参考解析
解析: 暂无解析
更多 “多选题In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?()Awhen one or more file directory paths are accidentally deleted from an ASM disk groupBwhen one of the disks in a disk group is accidentaly unpluggedCwhen the data file on an ASM disk group gets corruptedDwhen one or more disks in an ASM disk group are lost” 相关考题
考题 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 are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:ALTER DISKGROUP dg01 SET ATTRIBUTE ‘disk_repair_time‘ = ‘5h‘;To which disks in the disk group will the new value be applicable?()A. all disks in the disk groupB. all disks that are currently in OFFLINE modeC. all disks that are not currently in OFFLINE modeD. all disks in the disk group only if all of them are ONLINE

考题 You administer an online transaction processing (OLTP) system whose database is stored in AutomaticStorage Management (ASM) and whose disk group use normal redundancy.One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.Which two recommendations should you make to speed up the rebalance operation if this type of failurehappens again?()A. Increase the value of the ASM_POWER_LIMIT parameter.B. Set the DISK_REPAIR_TIME disk attribute to a lower value.C. Specify the statement that adds the disk back to the disk group.D. Increase the number of ASMB processes.E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

考题 Which two are the uses of the ASM metadata backup and restore (AMBR) feature?()A、 It can be used to back up all data on ASM disks.B、 It can be used to recover the damaged ASM disk group along with the data.C、 It can be used to gather information about a preexisting ASM disk group with disk paths,disk name,failure groups,attributes templates,and alias directory structure.D、 It can be used to re-create the ASM disk group with its attributes.

考题 You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?()A、all disks in the disk groupB、all disks that are currently in OFFLINE modeC、all disks that are not currently in OFFLINE modeD、all disks in the disk group only if all of them are ONLINE

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

考题 You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?()A、The ASM compatibility attribute controls the format of the disk group metadata.B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

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

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

考题 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 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?()  A、 ASMBB、 ARBnC、 RBAL in the ASM instanceD、 RBAL in the database instance

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

考题 In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?()A、 when one or more file directory paths are accidentally deleted from an ASM disk groupB、 when one of the disks in a disk group is accidentaly unpluggedC、 when the data file on an ASM disk group gets corruptedD、 when one or more disks in an ASM disk group are lost

考题 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 outaC、 The ASM migrates the extents from the unavailable disk to the remaining disks.D、 The disk automatically goes offline.

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

考题 You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group?()A、 The au_size disk group attribute determines the size of allocation units in the disk group. B、 The allocation unit size may vary but the extent size is fixed.C、 The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.D、 Extent management is completely automated.

考题 单选题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 are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group?()AThe au_size disk group attribute determines the size of allocation units in the disk group.BThe allocation unit size may vary but the extent size is fixed.CThe allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.DExtent management is completely automated.

考题 多选题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?()AUse 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.BUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.CUse 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.DUse 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.EUse the MD_RESTORE command to restore both the metadata and data for the failed disk group.FUse 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 administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?()AIncrease the value of the ASM_POWER_LIMIT parameter.BSet the DISK_REPAIR_TIME disk attribute to a lower value.CSpecify the statement that adds the disk back to the disk group.DIncrease the number of ASMB processes.EIncrease the number of DBWR_IO_SLAVES in the ASM instance.

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

考题 多选题Which two are the uses of the ASM metadata backup and restore (AMBR) feature?()AIt can be used to back up all data on ASM disks.BIt can be used to recover the damaged ASM disk group along with the data.CIt can be used to gather information about a preexisting ASM disk group with disk paths,disk name,failure groups,attributes templates,and alias directory structure.DIt can be used to re-create the ASM disk group with its attributes.

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

考题 多选题In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?()Awhen one or more file directory paths are accidentally deleted from an ASM disk groupBwhen one of the disks in a disk group is accidentaly unpluggedCwhen the data file on an ASM disk group gets corruptedDwhen one or more disks in an ASM disk group are lost

考题 单选题Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()A mount the new disk group in the ASM instanceB restart the ASM instance and the production database instanceC register the new disk groups in the production database instanceD restart the ASM instance without restarting the production database instanceE include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

考题 多选题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?()AThe disk is immediately dropped from the disk group.BThe ASM tracks the extents that are modified during the outaCThe ASM migrates the extents from the unavailable disk to the remaining disks.DThe disk automatically goes offline.

考题 多选题You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario?()AThe database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.BRDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.CThe RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.DASM compatibility controls which features for the ASM will be enabled.