What is the implication of the results of the query?

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

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *