Oracle
1Z0-034 · Question #47
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…
The correct answer is B. Dropping the relationship between the tables C. Adding the MASTERTBS tablespace to the recovery set. See the full explanation below for the reasoning.
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
(26 responses)- A12% (3)
- B85% (22)
- D4% (1)
Community Discussion
No community discussion yet for this question.