This preview shows page 1. Sign up to view the full content.
Unformatted text preview: tion Exam Guide, Jason S. Couchman, p. 668-669
Chapter 14: Database Failure and Recovery
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
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
- Fall '09