Oracle OCP 1Z0 053 Q707

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:BC

B: 刪除表之間的外來鍵聯絡
C. 將表空間MASTERTBS也加入恢復集

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2073314/，如需轉載，請註明出處，否則將追究法律責任。