Page 1 of 1

As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choo

Posted: Sun Jun 11, 2023 3:49 pm
by answerhappygod
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 DISMOUNTED2 DGROUP2 MOUNTED3 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.