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
第1题:
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:ASMCMD> lsdsk -I -d DATAWhich statement is true regarding the outcome of this command?()
A. The command succeeds but it retrieves only the disk names.
B. The command produces an error because the ASM instance is down.
C. The command succeeds but it shows only the status of the ASM instance.
D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
第2题:
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.
第3题:
A. when ASM disk goes offline
B. when one or more ASM files are dropped
C. when some disks in a disk group are offline
D. when some disks in a failure group for a disk group are rebalancing
第4题:
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? ()
第5题:
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?()
第6题:
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.
第7题:
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?()
第8题:
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 group
B. all disks that are currently in OFFLINE mode
C. all disks that are not currently in OFFLINE mode
D. all disks in the disk group only if all of them are ONLINE
第9题:
You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective?()
第10题:
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?()