为自己加油

Choose the best answer.

Examine this configuration:

1CDB1 is a container database.

2 APP_ROOT is an application root in CDB1.

3APP_PDB1 is an application PDB in APP_ROOT.

4FLASHBACK 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