A BAD TRANSACTION WAS COMMITTED IN YOUR DATABASE AT ABOUT 14

10. It is now 15:00, on Tuesday. A bad transaction was committed in your

database at about 14:30. Investigation shows that the tables and indexes

affected were in just two tablespaces: the rest of the database is fine. The two

tablespaces and several others were backed up last night, but some tablespaces

are backed up only on the weekend. Your database is in archivelog mode, with

log switches about every 10 minutes. Which of the following statements is

correct? (Choose the best answer.)

A. You can do an incomplete restore and recovery to 14:29, of just the two

tablespaces. The loss of data will be about 30 minutes of work in those

tablespaces.

B. You must restore the whole database from the weekend backup and

recover to 14:29. You will lose about 30 minutes of work.

C. You must restore the whole database and do an incomplete recovery

canceling the application of the archive log that was active at 14:30. You

will lose about 10 minutes of work.

D. You can restore some tablespaces from last night, the others from the

weekend, and recover to 14:29. You will lose about 30 minutes of work.