Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these…

The correct answer is B. CDB1_TAB and APP_PDB1_TAB. To perform a flashback operation for an application container, you must perform flashback operations for the application root and all the individual application PDBs that are part of the application container. Performing a flashback operation on the application root reverts…

Manage Multitenant Container Databases

Question

Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: Which table or set of tables will exist after the Flashback operation has completed?

Exhibit

Options

ACDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
BCDB1_TAB and APP_PDB1_TAB
Cnone of the tables, because all three tables will be dropped
DCDB1_TAB only
ECDB1_TAB and APP_ROOT_TAB

How the community answered

(36 responses)

A
6% (2)
B
83% (30)
C
3% (1)
E
8% (3)

Explanation

To perform a flashback operation for an application container, you must perform flashback operations for the application root and all the individual application PDBs that are part of the application container. Performing a flashback operation on the application root reverts only the application root to the specified point in time. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing- flashback-dbpitr.html#GUID-66B1A12D-1C92-43B5-A204-AA8A6D177ABD

Topics

#Flashback Database#application root#application PDB#multitenant recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice