Couchman p 668 669 chapter 14 database failure and

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: tion Exam Guide, Jason S. Couchman, p. 668-669 Chapter 14: Database Failure and Recovery QUESTION 94: Which two benefits do the command? ALTER DATABASE MOUNT CLONE DATABASE Offer for the tablespace point-in-time recovery? (Choose two) A. It allows the export to recover statistics on the tables. B. It prevents accidental corruption of the primary database. C. It allows the SYSTEM tablespace to become a transportable tablespace. D. It allows the POINT_IN_TIME_RECOVERY option on the export to function. E. It allows you to remove a data file that has been added to the wrong tablespace. Answer: D, E Explanation: This command allows the POINT_IN_TIME_RECOVERY option on the export to function and to remove a data file that has been added to the wrong tablespace. Oracle didn't advertise that in Oracle7 you could perform incomplete tablespace recovery, but you could. You can in Oracle8 and Oracle8i, as well. Say, for example, some data change was made a week ago in a table on one tablespace, and now...
View Full Document

Ask a homework question - tutors are online