1Z0-062 · Question #117
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. Flashback Transaction requires two specific prerequisites: supplemental logging and the DBMS_FLASHBACK execute privilege, enabling Oracle to reconstruct and reverse individual transactions using undo data.
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
(28 responses)- A4% (1)
- C93% (26)
- F4% (1)
Why each option
Flashback Transaction requires two specific prerequisites: supplemental logging and the DBMS_FLASHBACK execute privilege, enabling Oracle to reconstruct and reverse individual transactions using undo data.
Flashback Database enables point-in-time recovery of the entire database using flashback logs, but it is not a prerequisite for flashback transaction, which uses undo data instead.
Undo retention guarantee ensures undo data is not overwritten prematurely, but it is a best-practice consideration rather than a hard prerequisite for performing a flashback transaction.
The EXECUTE privilege on the DBMS_FLASHBACK package is required because flashback transaction operations are performed via this package's procedures, and without this privilege the user cannot invoke the necessary flashback functionality.
Supplemental logging must be enabled because flashback transaction relies on additional column data written to the redo log - specifically, supplemental logging records the before-images of changed columns needed to construct the compensating SQL that reverses a transaction.
The recycle bin is used by Flashback Drop to recover dropped tables, not by flashback transaction, which operates on undo segments to reverse DML changes.
Block change tracking records which database blocks changed to speed up incremental RMAN backups and has no relationship to flashback transaction functionality.
Concept tested: Flashback Transaction prerequisites - supplemental logging and DBMS_FLASHBACK
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/using-oracle-flashback-technology.html
Topics
Community Discussion
No community discussion yet for this question.