OCP-083

1CDB1 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

Which table or set of tables will exist after the Flashback operation has completed?

1CDB1 is a container database.

2 COMMON_USER_ PREFIX is set to an empty string.

3 PDB1 is a pluggable database in CDB1.

4 APP1_ ROOT is an application container in CDB1.

5 APP1_ PDB1 is an application PDB in APP1_ _ROOT.

You execute these commands:

S sq1plus sys/oracle@localhost:1521/cdb1 as sysdba

SQL> CREATE ROLE role1 CONTAINER=CURRENT ;

Which is true? .

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:

S export ORACLE SID=cdb1

S sqlplus / as sysdba

SQL> STARTUP UPGRADE ;

SQL> SHOW pdbs

CON_ ID CON_NAME OPEN_MODE RESTRICTED

---.---- ---.------- ---.-------- ---.--------

2 PDBSSEED 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/per1 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?

1cdb1 is a container database

2 There are several pluggable databases(PDBS、in CDB1

5 Each PDB has several tables with referential integrity constraints

6 FLASHBACK DAABASE is ON

7 UNDO RETENTION GUARANTEE is enabled

Multiple undesired multitable changes were made in all the PDBS Which method can be

Used to undo the changes using a single command