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(cl NUMBER);

Table created.

SQL> ALTER SESSION SET CONTAINER=app_root;

Session altered.

SQL> CREATE TABLE app_root_tab(cl NUMBER);

Table created.

SQL> ALTER SESSION SET CONTAINER=app_pdb1;

Session altered.

SQL> CREATE TABLE app_pdb1_tab(cl 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?

1. CDB1 is an Oracle Database 12c Release 2 container database (CDB).

2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.

After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:

$$ export ORACLE_SID=cdb1

$$ sqlplus / as sysdba

SQL> startup upgrade;

SQL> SHOW pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

------- ---------- ---------- ----------

2 PDB$$SEED MIGRATE YES

3 PDB1 MOUNTED YES

4 PDB2 MOUNTED YES

SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE;

Pluggable database altered.

SQL> exit

$$ ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2'

What is the outcome?

$$ sqlplus system/oracle

SQL> col name for a10

SQL> select name, open_mode from v$$pdbs;

NAME OPEN MODE

---------- ----------

PDB$$SEED READ ONLY

PDB1 READ WRITE

PDB2 MOUNTED

SQL> exit

Next you execute:

$$ expdp system/oracle full=y

What is the outcome?