You have three production databases, HRDB, FINDB and ORGDB that use the same ASM
instance. At the end of the day, while all three production database instances are running, you
execute the following command on the ASM instance.
SQL> shutdown immediate;
What is the result of executing this command?
A.
The ASM instance is shut down, but the other instances are still running
B.
It results in an error because other database instances are connected to it
C.
All the instances, including the ASM instance, are shut down in the IMMEDIATE mode
D.
HRDB, FINDB and ORGDB instances are shut down in the ABORT mode and the ASM
instance is shut down in the IMMEDIATE mode
Why not D?
Here is the reason why D is not correct:
Starting up and shutting down an ASM instance has a few caveats, the most
important of which is that you can’t shut down any ASM instance that is managing
disks from any active RDBMS instance (you need to shut down the database first).