Oracle Exam 1Z0-083 Topic 5 Question 96 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 96
Topic #: 5

[All 1Z0-083 Questions]

Choose the best answer. Examine this configuration:

1. CDB1 is a container database running in ARCHIVELOG mode.

2. Multiple uncommitted transactions are running in CDB1.

3. Redo log groups 1 and 2 are INACTIVE.

4. Redo log group 3 is the CURRENT group.

All members of redo log group 3 are lost before it is archived. Examine these possible steps:

1. SHUTDOWN ABORT

2. STARTUP NOMOUNT

3. STARTUP MOUNT

4. ALTER DATABASE MOUNT

5. RESTORE DATABASE

6. RECOVER DATABASE NOREDO

7. RECOVER DATABASE UNTIL AVAILABLE

8. RESTORE ARCHIVELOG ALL

9. ALTER DATABASE OPEN

10. ALTER DATABASE OPEN RESETLOGS

Choose the minimum required steps in the correct order to recover the database.

A1,3,5, 6, 9

B1,3, 5, 7, 10

C1,2, 5, 7,4, 10

D1,3, 5, 6, 10

E1,3,5, 6, 10

F1,3,5,8, 6, 10

Show Suggested Answer

Suggested Answer: B, D

by Lashonda at Jul 05, 2024, 02:42 AM

Limited Time Offer

25%

29 days ago

I think the correct answer is D) 1,3, 5, 6, 10 because we need to shutdown, mount, restore, recover, and then open the database.

upvoted 0 times

...