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

Exam 1z0-062 All Questions

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

Exam 1z0-062 topic 1 question 266 discussion

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

Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)

  • A. inactive online redo log file group
  • B. a data file belonging to the default temporary tablespace
  • C. a data file belonging to the SYSAUX tablespace
  • D. server parameter file (SPFILE)
  • E. active online redo log file group
  • F. all the control flies
Show Suggested Answer Hide Answer
Suggested Answer: AEF 🗳️
by rdnkrkmz at Feb. 1, 2019, 7:58 p.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
khan
Highly Voted 6 years, 2 months ago
Answer: CEF
upvoted 11 times
...
NorthKorean
Highly Voted 5 years, 2 months ago
CEF confirmed
upvoted 5 times
...
Ray520
Most Recent 2 years, 10 months ago
Can't be F as controlfile autobackup is on, so we can do media recovery in case of control file backup, won't be incomplete recovery.
upvoted 1 times
...
Simon22
4 years, 9 months ago
correct AEF
upvoted 1 times
...
dancymonkey
4 years, 9 months ago
Why A is not correct? Why C???? https://docs.oracle.com/database/121/BRADV/osadvsce.htm#BRADV90048 The log is no longer needed for instance recovery. It may be in use for media recovery, and may or may not be archived
upvoted 4 times
hggz
4 years, 9 months ago
I agree with dancymonkey. We need inactive Redo logs for media recovery when we restore datafile from backup.
upvoted 3 times
...
fridaytar
4 years, 3 months ago
i think it uses "may" word
upvoted 1 times
...
...
Havok
5 years, 4 months ago
A is not correct. Inactive Redo logs mean they have already been written, and are no longer needed for recovery unless it is media recovery.
upvoted 3 times
...
rdnkrkmz
6 years, 4 months ago
A is not correct, instead C is correct.
upvoted 4 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