Oracle Exam 1Z0-083 Topic 5 Question 78 Discussion

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

Question #: 78
Topic #: 5

Choose two. A database is configured in ARCHIVELOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required?

Aafter losing all members of the CURRENT online redo log group

Bafter losing all copies of the control file

Cafter losing an UNDO tablespace that is in use

Dafter losing all members of an INACTIVE online redo log group

Eafter losing a SYSAUX tablespace data file

Show Suggested Answer

Suggested Answer: B, D, E

by Maile at Aug 10, 2023, 03:39 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Corrina

1 days ago

Ah, I see. B and D make sense. Losing the control file and inactive redo log group would definitely mess things up. E is a bit of a curveball, though. I wonder if the SYSAUX tablespace is really that critical for recovery.

upvoted 0 times

...

Ettie

15 days ago

I believe incomplete recovery is not required after losing an UNDO tablespace that is in use.

upvoted 0 times

...

Kiley

19 days ago

I agree with Eun. Incomplete recovery is also required after losing all copies of the control file.

upvoted 0 times

...

Hillary

20 days ago

Hmm, I think B and D are the correct answers. After all, losing the control file and inactive redo log group would definitely require incomplete recovery. C is a tough one, though. Not sure about that one.

upvoted 0 times

Berry

7 days ago

I think B and D are the correct answers.

upvoted 0 times

...

Eun

26 days ago

I think incomplete recovery is required after losing all members of the CURRENT online redo log group.

upvoted 0 times

...