nerdexam
Oracle

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.

Performing Backup and Recovery

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)
  • A
    4% (1)
  • C
    93% (26)
  • F
    4% (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.

AFlashback Database must be enabled.

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.

BUndo retention guarantee for the database must be configured.

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.

CEXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashingCorrect

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.

DSupplemental logging must be enabled.Correct

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.

ERecycle bin must be enabled for the database.

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.

FBlock change tracking must be enabled tor the database.

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

#Flashback Transaction#DBMS_FLASHBACK#Supplemental logging

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice