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?
A.CDB1_TAB APP_ROOT_TAB and APP_PDB1_TAB B.CDB1_TAB and APP_PDB1_TAB C.CDB1_TAB and APP_ROOT_TAB D.CDB1_TAB only E.none of the tables because all three tables will be dropped正确答案B
