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?

Examine this configuration:

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:

（含图）

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?

Examine this output of an export from the current release of an Oracle

Multitenant database:

（含图）

Next you execute:

$ expdp system/oracle full=y

What is the outcome?

Examine this configuration:

1- CDB1 is a container database.

2- DEFAULT_SHARING is METADATA.

3- APP_ROOT is an application root contained in CDB1.

4- APP_PDB1 is an application PDB contained in APP_ROOT.

5- COMPANYAPP is an application contained in APP_ROOT.

6- EMP is a common table created in APP_ROOT and all its application PDBs,

Created when version 1.0 of COMPANYAPP was installed.

You execute these commands:

（含图）

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC;

What will be the outcome and why?

Examine this configuration:

（含图）

In which order will the upgrade occur?

Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?