Q12. Examine in 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/oracle_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?
- A. CDB1_TAB only
- B. CDB1_TAB and APP_PDB1_TAB
- C. none of the tables, because all three tables will be dropped
- D. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
- E. CDB1_TAB and APP_ROOT_TAB
Answer: B