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 251 discussion

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

Backup requirements for a database:
* Level 0 backup on Sunday
* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
* Differential incremental level 1 backup on Tuesday, Thursday, and Friday
Which three statements are true about the strategy? (Choose three.)

  • A. Level 0 backup on Sunday contains all the blocks that have been formatted.
  • B. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.
  • C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.
  • D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.
  • E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.
Show Suggested Answer Hide Answer
Suggested Answer: BDE 🗳️
by khan at March 30, 2019, 4:39 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
khan
Highly Voted 6 years, 2 months ago
Answer: ACD https://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV89499
upvoted 19 times
...
EL79
Highly Voted 5 years, 9 months ago
Answer: ACD
upvoted 9 times
...
Ray520
Most Recent 3 years ago
Selected Answer: ACD
A level 0 incremental backup, which is the base for subsequent incremental backups, copies all blocks containing data, backing the datafile up into a backup set just as a full backup would. A level 1 incremental backup can be either of the following types: A differential backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0 A cumulative backup, which backs up all blocks changed after the most recent incremental backup at level 0
upvoted 2 times
...
NorwayOracle
3 years, 2 months ago
Selected Answer: CDE
A differential backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0. A cumulative backup, which backs up all blocks changed after the most recent incremental backup at level 0.
upvoted 1 times
Ray520
2 years, 10 months ago
Theoretically you're right but if you see the question, level 0 is happening on Sunday followed by Level 1 cumulative on Monday. The subsequent level 1 differential backups will have data changed since last cumulative level 1 backup, hence option E is incorrect for this scenario. All differential backups in this backup schedule will have changes since last level 1 backup only. If there was level 1 differential backup taken on Monday, then option E would be correct as it is followed by the level 0 backup on Sunday. So option ACD is right here.
upvoted 1 times
...
...
Clozoerie
3 years, 10 months ago
Answer: ACD
upvoted 3 times
...
Simon22
4 years, 9 months ago
Answer: ACD
upvoted 4 times
...
sherifelia
5 years, 6 months ago
Answer: ACD
upvoted 9 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