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.
Bạn đang xem 10. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P68 POT