Datasheet
52
Chapter 1
Using Oracle ASM
20. As the DBA, you run the following query on your ASM instance. What is the implication of
the results of the query? (Choose two.)
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 state.
C. 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.
95134c01.indd 52 1/28/09 9:43:48 AM