1Z0-062 · Question #171
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_P
The correct answer is B. Dropping the relationship between the tables C. Adding the MASTERTBS tablespace to the recovery set. If constraints for the tables in tablespace tbs1 are contained in tablespace tbs2, then you cannot recover tbs1 without also recovering tbs2.
Question
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.)
Options
- ATaking the MASTERTBS tablespace offline
- BDropping the relationship between the tables
- CAdding the MASTERTBS tablespace to the recovery set
- DPutting the MASTERTBS tablespace in read-only mode
How the community answered
(17 responses)- A29% (5)
- B59% (10)
- D12% (2)
Explanation
If constraints for the tables in tablespace tbs1 are contained in tablespace tbs2, then you cannot recover tbs1 without also recovering tbs2.
Topics
Community Discussion
No community discussion yet for this question.