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
解析:
Initially, your recovery set includes the datafiles for the tablespaces you intend to recover. However, if objects in the tablespaces you need have relationships (such as constraints) to objects in other tablespaces, then you will have to account for this relationship before you can perform TSPITR. You have the following choices when faced with such a relationship:
1. Add the tablespace including the related objects to your recovery set
2. Remove the relationship
3. Suspend the relationship for the duration of TSPITR
感觉答案错掉了,应当是BC
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtspit.htm#BRADV89793
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
解析:
Initially, your recovery set includes the datafiles for the tablespaces you intend to recover. However, if objects in the tablespaces you need have relationships (such as constraints) to objects in other tablespaces, then you will have to account for this relationship before you can perform TSPITR. You have the following choices when faced with such a relationship:
1. Add the tablespace including the related objects to your recovery set
2. Remove the relationship
3. Suspend the relationship for the duration of TSPITR
感觉答案错掉了,应当是BC
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtspit.htm#BRADV89793