Database Backups

In the diagram below, each type of backup is taken at the specified time. Due to a missed scenario during the testing phase, a development error in setting wrong query conditions resulted in the loss of all records from a table at a time marked by the red cross.

Select all the ways to restore the database until the point of failure.

(Select all acceptable answers.)

Using the full backup at 12:00, the differential backup at 13:00, and data from the transactional/redo log backup between 13:00 and 13:15.

Using the full backup at 12:00, the differential backup at 13:00, the transactional/redo log backup at 13:30, and data from the transaction/redo log between 13:30 and 13:45.

Using the full backup at 12:00, the differential backups at 13:00 and 14:00, and data from the transactional/redo log backup between 14:00 and 14:15.

Using the full backup at 12:00, the differential backup at 13:00, and transactional/redo log backups at 13:30 and 14:00.

Using the full backup at 00:00, all differential backups until 13:00, the transactional/redo log backup at 13:30, and data from the transactional/redo log between 13:30 and 13:45.

Using the full backup at 12:00, transactional/redo log backups at 12:30, 13:00, and 13:30, and data from the transaction/redo log between 13:30 and 13:45.

Information

Difficulty:

Easy

Duration:

5 min

Type:

mca

Set:

Public

Score Distribution

% of candidates

0-33%

34-67%

68-100%

Score

Would you like to see our other questions?

We have 1000+ premium hand-crafted questions for 160+ job skills and 20+ coding languages. We prefer questions with small samples of actual work over academic problems or brain teasers.

Visit the Question Library

Would you like to see our tests?

The following tests contain Database Administration related questions:

Database Administration

On the blog

Screening Applicants: The Good, the Bad and the Ugly

Since we're all biased and we use incorrect proxies, why not just outsource hiring to experts or recruitment agencies? After all, they've been screening people for many years, so they must know how to do it right?

Not really. I was surprised to discover that many experts...

Read full article