The transactions that use the disk group will halt.
The mirroring of allocation units occurs within the CONTROLLER2 failure group.
The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
第1题:
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?()
第2题:
Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()
第3题:
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.
第4题:
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
第5题:
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?()
第6题:
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?()
第7题:
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?()
第8题:
A. As ASM instance mounts an ASM control file
B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
第9题:
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?()
第10题:
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?()