OCP-1Z0-053-V13.02-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

Answer: AD

答案解析：

个人觉得这道题应该选BC。

If constraints for the tables in tablespace tbs1 are contained in tablespace tbs2, then you cannot recover tbs1 without also recovering tbs2.

OCP-1Z0-053-V13.02-707题