Question 1 of 30
A database administrator discovers that a critical table in the production database has been accidentally truncated during a maintenance operation. The administrator needs to restore the table to its state just before the truncation occurred. Which recovery technique should the administrator employ to achieve this without restoring the entire database from backup?
Use Flashback Table to restore the table to its previous state.
Perform a point-in-time recovery using RMAN to restore the entire database.
Execute a Flashback Query to retrieve the data and manually reinsert it into the table.
Utilize a full database backup to restore the database to the last backup point.

Preparing for Oracle Database 12c Essentials? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free