Oracle Database 11g: Administration II — Question 1
When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instances disk groups?
Answer options
- A. TRANSACTIONAL
- B. IMMEDIATE
- C. ABORT
- D. NORMAL
Correct answer: A
Explanation
The correct answer is A, TRANSACTIONAL, because this command ensures that all active transactions are completed before shutting down. The other options, such as IMMEDIATE and ABORT, do not provide the same level of graceful transaction handling, leading to potential data loss or inconsistency.