网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）
A
Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
B
Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
C
The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
D
ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
E
Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
参考答案
参考解析
解析：
暂无解析
更多 “单选题A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）A Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.B Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.C The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.D ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.E Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.” 相关考题
考题
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
考题
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:What happens when the whole CONTROLLER1 Failure group is damaged?()
A. The transactions that use the disk group will halt.B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
考题
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.
考题
You work as a database administrator at Certkiller .com. 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 using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command： ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）A、The rebalancing of the disk group would be stopped.B、The rebalancing of the disk group would be completed as fast as possible.C、The command would result in an error because the value of POWER cannot be 0.D、The rebalancing of the disk group would be completed without affecting the disk group DG3.E、The command would result in an error because the disk groups cannot be manually rebalanced.
考题
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
考题
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; What happens when the whole CONTROLLER1 Failure group is damaged?（）A、The transactions that use the disk group will halt.B、The mirroring of allocation units occurs within the CONTROLLER2 failure group.C、The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.D、The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
考题
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.
考题
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.
考题
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.
考题
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）. Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）A、 Because the FRA disk group will not support dynamic rebalancingB、 Because the FRA disk group is not configured to support mirroringC、 Because disks in the FRA disk group are not formatted at this stageD、 Because the FRA disk group will support only a single size of allocation unit
考题
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）A、Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.B、Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.C、The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.D、ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.E、Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
考题
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.
考题
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
考题
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 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
考题
单选题You work as a database administrator at Certkiller .com. 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 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.
考题
单选题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
考题
单选题A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; What happens when the whole CONTROLLER1 Failure group is damaged?（）A
The transactions that use the disk group will halt.B
The mirroring of allocation units occurs within the CONTROLLER2 failure group.C
The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.D
The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
考题
单选题View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）. Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）A
Because the FRA disk group will not support dynamic rebalancingB
Because the FRA disk group is not configured to support mirroringC
Because disks in the FRA disk group are not formatted at this stageD
Because the FRA disk group will support only a single size of allocation unit
考题
单选题A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）A
Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.B
Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.C
The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.D
ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.E
Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
考题
单选题You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command： ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）A
The rebalancing of the disk group would be stopped.B
The rebalancing of the disk group would be completed as fast as possible.C
The command would result in an error because the value of POWER cannot be 0.D
The rebalancing of the disk group would be completed without affecting the disk group DG3.E
The command would result in an error because the disk groups cannot be manually rebalanced.
考题
单选题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.
考题
单选题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.
热门标签
最新试卷
