ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-078 All Questions

View all questions & answers for the 1z0-078 exam
Go to Exam

Exam 1z0-078 topic 1 question 50 discussion

Actual exam question from Oracle's 1z0-078
Question #: 50
Topic #: 1
[All 1z0-078 Questions]

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.)

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
by krwi1 at March 20, 2024, 7:01 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
217972f
4 months, 4 weeks ago
Selected Answer: CE
IMMEDIATE = 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
upvoted 1 times
...
Test_1
6 months, 3 weeks ago
Selected Answer: CE
CE correct answer.
upvoted 1 times
...
lcoleandro
6 months, 3 weeks ago
Selected Answer: BE
Based 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
upvoted 1 times
...
krwi1
10 months, 2 weeks ago
Selected Answer: CE
...not sure but I think D is wrong - ASM get an abort signal - "shuts down immediately withoul an orderly dismount of diskgroups".
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago