Oracle 11G OCP 1Z0-053 642

（642）In your production database,users report that they are 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 in other 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)

答案：（C）

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1332035/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1332035/