nerdexam
Oracle

1Z0-060 · Question #67

Which three statements are true about using flashback database in a multitenant container database (CDB)?

The correct answer is B. To enable flashback database, the CDB must be mounted. D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB. E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point. Enabling flashback database on a CDB requires the database to be mounted, the retention target parameter to be configured, and target specification is limited to SCN or point in time in certain CDB contexts.

New Features for Availability

Question

Which three statements are true about using flashback database in a multitenant container database (CDB)?

Options

  • AThe root container can be flashed back without flashing back the pluggable databases (PDBs).
  • BTo enable flashback database, the CDB must be mounted.
  • CIndividual PDBs can be flashed back without flashing back the entire CDB.
  • DThe DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
  • EA CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

How the community answered

(38 responses)
  • A
    16% (6)
  • B
    79% (30)
  • C
    5% (2)

Why each option

Enabling flashback database on a CDB requires the database to be mounted, the retention target parameter to be configured, and target specification is limited to SCN or point in time in certain CDB contexts.

AThe root container can be flashed back without flashing back the pluggable databases (PDBs).

Flashing back a CDB affects all containers - the root and all associated PDBs are returned to the target point together, because the CDB shares a single set of redo and flashback logs across all containers.

BTo enable flashback database, the CDB must be mounted.Correct

The ALTER DATABASE FLASHBACK ON command used to enable flashback on a CDB must be issued while the database is in MOUNT state, because the operation modifies control file settings and requires exclusive access before the database is opened.

CIndividual PDBs can be flashed back without flashing back the entire CDB.

Flashing back an individual PDB independently requires local undo mode to be enabled on the CDB and the use of a PDB-level restore point - it is not a universally available capability in all CDB configurations.

DThe DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.Correct

The DB_FLASHBACK_RETENTION_TARGET parameter must be set to a non-zero value to define how many minutes of flashback logs the system should retain, and this is a required prerequisite for enabling CDB-level flashback database.

EA CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.Correct

In CDB flashback operations, the supported target specifications are a timestamp or an SCN - restore point-based flashback in a CDB environment has behavioral restrictions that distinguish it from non-CDB flashback usage.

Concept tested: Flashback database enablement and behavior in Oracle CDB

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/using-flashback-database-restore-points.html

Topics

#flashback database#CDB flashback#PDB flashback#restore point

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice