Oracle Database Administration 2019 Certified Professional — Question 18

Examine these descriptions of ASM instance shutdown behavior:
1) The ASM instance shuts down immediately without an orderly dismount of disk groups.
2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
Which two lists are correct matches for these descriptions? (Choose two.)

Answer options

• A. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
• B. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
• C. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
• D. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
• E. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Correct answer: C, E

Explanation

The correct matches are C and E because description 3 corresponds to NORMAL as it waits for sessions to disconnect, description 2 is TRANSACTIONAL as it allows active SQL statements to complete before dismounting without waiting for session disconnections, and description 1 is ABORT since it shuts down immediately without an orderly dismount. The other options incorrectly assign these behaviors to the wrong shutdown types.