OCP-1Z0-053-200题-65题-642

QUESTION 65

In your production database, users report that theyare unable to generate reports on an important table

because it does not contain any data. While investigating the reason, you realize that another user executed

the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the

lost data of the table without affecting objects inother schemas.

Which method must you use to recover the lost data?

A. Complete Recovery with online redo log

B. Complete Recovery with archived redo log

C. Tablespace Point-in-Time Recovery (TSPITR)

D. Incomplete Recovery with system change number (SCN)

Answer: C

同642题：http://blog.csdn.net/rlhua/article/details/13761239

Explanation/Reference:

Section: Backup, Recovery & Recovery Manager (RMAN)

RMAN TSPITR is most useful for the following situations:

- You want to recover data lost after DDL operations that change the structure of tables.

You cannot use Flashback Table to rewind atable to before the point of a structural change

such as a truncate table operation.