Oracle Exam 1Z0-062 Topic 9 Question 15 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 15
Topic #: 9

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.)

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

Show Suggested Answer

Suggested Answer: B, C

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtspit.htm#BRADV99978

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

by Jose at May 09, 2022, 11:00 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-062 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!