Exam 1z0-063 topic 1 question 217 discussion

Actual exam question from Oracle's 1z0-063

Question #: 217
Topic #: 1

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at
10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods for recovering the truncated table data?

A. Table Point-in-Time Recovery
B. Database Point-in-Time Recovery
C. Tablespace Point-in-Time Recovery
D. Flashback Database
E. Flashback Transaction Backout

Show Suggested Answer

Suggested Answer: BD 🗳️
Reference -
https://blogs.oracle.com/sql/how-to-recover-data-without-a-backup

by alipilot2006 at April 26, 2019, 8:14 a.m.

Comments

Submit Cancel

loveroba

4 years ago

why not AE,notice 'After that, a few important transactions are performed on the database'...

upvoted 2 times

...

joe_doe

4 years, 3 months ago

D/E False，truncate is an DDL phase,it means they couldn't be flashback,B is correct ,but A&C seems better

upvoted 2 times

...

Kalinos20

4 years, 10 months ago

Answer AC

upvoted 1 times

Sugar

4 years, 5 months ago

i agree A C. a truncated table cannot be recovered by Flashback feature

upvoted 1 times

...

sherifelia

4 years, 10 months ago

Answer AE

upvoted 1 times

...

alipilot2006

5 years, 7 months ago

The answer is "AC"

upvoted 3 times

...

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam

Exam 1z0-063 topic 1 question 217 discussion

Comments

loveroba

joe_doe

Kalinos20

Sugar

sherifelia

alipilot2006

SY0-701