1Z0-083 practice question 22 of 35

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT isan application root in CDB1. 3. APP_PDB1 is an…

Full set: 286 questions

Choose the best answer. 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: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL>

SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE

TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root;

Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER

SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1

NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE

app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO

SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback

operation has completed?

Answer options
A:

A. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB

B:

B. CDB1_TAB and APP_PDB1_TAB

C:

C. CDB1_TAB and APP_ROOT_TAB

D:

D. CDB1_TAB only

Correct answer
E:

E. none of the tables, because all three tables will be dropped

Correct Answer:
D. D. CDB1_TAB only
Explanation

The command FLASHBACK PLUGGABLE DATABASE approot TO SCN 2074756 reverts the application root approot to the state it was in at the specified SCN. A critical rule is that when an application root is flashed back, all of its associated application PDBs are also flashed back to the same point in time. In this scenario, both APPROOTTAB and APPPDB1TAB were created after SCN 2074756. Therefore, the flashback operation will remove both of these tables. The table CDB1TAB, created in CDB$ROOT, is outside the scope of this PDB-level flashback and remains unaffected.

Why Incorrect

A. APPROOTTAB and APPPDB1TAB will be dropped by the flashback operation because they were created after the target SCN.
B. APPPDB1TAB will be dropped because its container, apppdb1, is flashed back along with the application root approot.
C. APPROOTTAB will be dropped by the flashback operation as it was created in approot after the target SCN.
E. CDB1TAB will not be dropped because the flashback operation was performed on the PDB approot, not on the CDB$ROOT container.

References

Oracle Database Backup and Recovery User's Guide 19c, "Performing Flashback and Database Point-in-Time Recovery", Section 17.4.1 "About Flashback Pluggable Database". It states, "When you perform a flashback operation on an application root, all of its application PDBs are also flashed back."

Oracle Database SQL Language Reference 19c, "FLASHBACK PLUGGABLE DATABASE". The documentation confirms the command reverts the data files of the specified PDB to a past point in time.

Scroll to Top