Oracle 11G OCP 1Z0-053 707

（707）Because of a logical corruption in the EMPLOYES tables,you want to perform Tablespace Point-in-Time Recovery（TSPITR）to recover the table.

Before you started the TSPITR process,you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint

with DEPARTMENTS that exists in another tablespace,MASTERTBS.

Which two actions will permit the TSPITR to work?(Choose two.)

A. Taking the MASTERTBS tablespace offline

B. Dropping the relationship between the tables

C. Adding the MASTERTBS tablespace to the recovery set

D. Putting the MASTERTBS tablespace in read-only mode

答案：（B，C）

解析：

B，删除主外键约束关系

C，如果有主外键约束，则要把包含父子关系（外键约束）的表空间必须都包含在恢复集中

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

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