In your production database, users report that they are unable to generate reports on an
important table because it does not contain any dat
A.
While investigating the reason, you realize that another user executed the TRUNCATE
TABLE command, which accidentally caused the data to be lost. Now you want to recover
the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?
Complete Recovery with online redo log
A.
While investigating the reason, you realize that another user executed the TRUNCATE
TABLE command, which accidentally caused the data to be lost. Now you want to recover
the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?
Complete Recovery with online redo log
B.
Complete Recovery with archived redo log
C.
Tablespace Point-in-Time Recovery (TSPITR)
D.
Incomplete Recovery with system change number (SCN)
In your production database, users report that theyare unable to generate reports on an important table
because it does not contain any data. While investigating the reason, you realize that another user executed
the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the
lost data of the table without affecting objects inother schemas.
Which method must you use to recover the lost data?
A. Complete Recovery with online redo log
B. Complete Recovery with archived redo log
C. Tablespace Point-in-Time Recovery (TSPITR)
D. Incomplete Recovery with system change number (SCN)
Answer: C
If spellblind’s version of the question is accurate, then answer C is not guaranteed to be correct because what if another schema also used this tablespace? There is no rule stopping 2 schemas/users creating objects in the same tablespace.