Which Shutdown Modes Match These ASM Instance Descriptions?
Short answer
CE The lists map 1 = ABORT, 3 = NORMAL, and 2 = IMMEDIATE or TRANSACTIONAL, since ASM does an IMMEDIATE shutdown when TRANSACTIONAL is specified.
Question
Key Takeaways
This item tests whether you can distinguish ABORT, NORMAL, IMMEDIATE and TRANSACTIONAL shutdown behaviour on an ASM instance — the trap is assuming TRANSACTIONAL is a distinct ASM mode rather than an alias for IMMEDIATE.
ASM instance shutdown behaviour separates ABORT (immediate stop with no disk group dismount), NORMAL (orderly dismount after waiting for connected sessions) and the non-waiting variant that maps to IMMEDIATE or TRANSACTIONAL. The correct lists for this Oracle 1Z0-078 item are C and E.
Common mistake: Many candidates pick only B (2 = NORMAL, 3 = IMMEDIATE), inverting the session-waiting behaviour, or pick just one letter because they treat TRANSACTIONAL as a real fourth ASM mode instead of an alias of IMMEDIATE.
Expert Analysis
Why the Answer Is Correct
Description 1 is ABORT: the ASM instance shuts down immediately with no orderly dismount of disk groups. Description 3 is NORMAL: ASM lets active SQL statements finish, performs an orderly dismount of every mounted disk group, then shuts down after waiting for connected sessions to disconnect, returning an error while ASM clients are still attached. Description 2 differs only in that it does not wait for connected sessions — that is the TRANSACTIONAL shutdown, which Oracle's ASM documentation explicitly says the ASM instance does not support: if you specify TRANSACTIONAL, ASM performs an IMMEDIATE shutdown instead. Because IMMEDIATE and TRANSACTIONAL are effectively the same behaviour on an ASM instance, both option C (2 = TRANSACTIONAL) and option E (2 = IMMEDIATE) are valid matches, and each keeps 3 = NORMAL and 1 = ABORT intact.
Why the Other Options Are Wrong
Option B reverses descriptions 2 and 3: it maps the "waits for connected sessions" text to IMMEDIATE even though an immediate shutdown never waits for anyone, and it maps the non-waiting text to NORMAL, which is precisely the mode that does wait for sessions to disconnect. Option A keeps 2 = NORMAL and assigns 3 = TRANSACTIONAL, but TRANSACTIONAL is the session-skipping variant, so it cannot describe the third text. Option D collapses the mapping entirely, pairing description 1 with IMMEDIATE even though "no orderly dismount" is ABORT behaviour, and pairing description 2 with ABORT even though that description explicitly includes an orderly dismount. Only C and E preserve both anchors: ABORT performs no disk group dismount, and NORMAL is the mode that waits for connected sessions.
Community Comment Notes
A learner with the handle 217972f resolved the TRANSACTIONAL ambiguity with the observation that "IMMEDIATE = TRANSACTIONAL as in ASM there aren't transactions" and linked Oracle's ASM instance administration page, which is exactly why C and E both count. Test_1 recorded simply "CE correct answer", while krwi1 reasoned that pairing the first description with an immediate shutdown is right because ABORT is the mode that kills the instance without dismounting disk groups. lcoleandro argued instead for B (2 = NORMAL, 3 = IMMEDIATE), but that mapping inverts the session-waiting behaviour Oracle assigns to NORMAL. The 75-to-25 vote split reflects precisely this B-versus-CE confusion among test takers.
Official Reference
https://docs.oracle.com/en/database/oracle/oracle-database/19/ostmg/admin-asm-instance.html
This link opens the official vendor documentation in a new tab.
Exam Strategy
Anchor the two certainties first: ABORT never performs an orderly dismount, and NORMAL is the ASM mode that waits for connected sessions to disconnect — that alone eliminates A, B and D. Then remember that Oracle states the ASM instance does not support TRANSACTIONAL and performs an IMMEDIATE shutdown instead, so both labels are acceptable for the non-waiting description, giving C and E.
Frequently Asked Questions
Why is 2 = TRANSACTIONAL in option C accepted when ASM does not support TRANSACTIONAL?
Why does the NORMAL shutdown return an error when ASM clients are connected?
Community Votes
75% of anonymous learners picked answer CE. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 4 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 4
-
lcoleandro 👍 1Based on the descriptions, the correct matches are: Description 1 (immediate shutdown without orderly dismount) matches ABORT. Description 2 (complete active SQL, then shutdown without waiting for sessions) matches IMMEDIATE. Description 3 (complete active SQL, then shutdown after waiting for sessions) matches NORMAL. Therefore, the correct matches are: B. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT E. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
-
217972f 👍 1IMMEDIATE = TRANSACTIONAL as in ASM there aren't transactions.. As explained here: https://docs.oracle.com/en/database/oracle/oracle-database/19/ostmg/admin-asm-instance.html#GUID-9C2208C8-B436-4A18-A5D7-0CE854751529
-
krwi1 👍 1...not sure but I think D is wrong - ASM get an abort signal - "shuts down immediately withoul an orderly dismount of diskgroups".
-
Test_1 👍 1CE correct answer.
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.