Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

The correct answer is D. the PDB as the PDB Admin user. Use command with the appropriate privileges on the recyclebin object - Flashback table <table_name> to before drop; https://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV81511

Backup and Recovery Concepts

Question

Options

Athe CDB as the ROOT user
Bthe CDB as the CDBADMIN user
Cthe PDB as the ROOT user
Dthe PDB as the PDB Admin user

How the community answered

(24 responses)

A
17% (4)
B
4% (1)
C
8% (2)
D
71% (17)

Explanation

Use command with the appropriate privileges on the recyclebin object - Flashback table <table_name> to before drop; https://docs.oracle.com/database/121/BRADV/rcmflash.htm#BRADV81511

Topics

#PDB recovery#table recovery#PDB admin#CDB vs PDB

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice