Oracle
1Z0-060 · Question #133
Which two are prerequisites for performing a flashback transaction?
The correct answer is C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing D. Supplemental logging must be enabled. Configuring Your Database for Flashback Transaction
New Features for Availability
Question
Which two are prerequisites for performing a flashback transaction?
Options
- AFlashback Database must be enabled.
- BUndo retention guarantee for the database must be configured.
- CEXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing
- DSupplemental logging must be enabled.
- ERecycle bin must be enabled for the database.
- FBlock change tracking must be enabled tor the database.
How the community answered
(65 responses)- A2% (1)
- C89% (58)
- E3% (2)
- F6% (4)
Explanation
Configuring Your Database for Flashback Transaction
Topics
#Flashback Transaction#supplemental logging#DBMS_FLASHBACK#undo retention
Community Discussion
No community discussion yet for this question.