1）CDB1 is a container database running in

ARCHIVELOG mode.

2）Multiple uncommitted transactions are running in CDB1 .

3） Redo log groups 1 and 2 are INACTIVE.

4）Redo log group 3 is the CURRENT group.

All members of redo log group 3 are lost before it is archived.

Examine these possible steps:

1） SHUTDOWN ABORT

2） STARTUP NOMOUNT

3） STARTUP MOUNT

4） ALTER DATABASE MOUNT

5） RESTORE DATABASE

6） RECOVER DATABASE NOREDO

7） RECOVER DATABASE UNTIL AVAILABLE REDO

8） RESTORE ARCHIVELOG ALL

9） ALTER DATABASE OPEN

10） ALTER DATABASE OPEN RESETLOGS

Choose the minimum required steps in

The correct order to recover the database.

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.

Examine these steps:

1.Install the SALES_APP application, including the common tables, in the application root.

2.Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.（CDB ROOT不需要）

3.Create an application seed.

4.Install the SALES_APP application in the application seed.（APP SEED不能安装APP）

5.Create the SALES_APP1 and SALES_APP2 application PDBs.

6.Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

7.Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

8.Sync the application seed with the application root.

Which are the minimum required steps in the correct sequence?

Examine this configuration:

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

sqlplus sys/oracle@localhost:1521/cdb1 as sysdba 

SQL> CREATE ROLE role1 CONTAINER=CURRENT;

Which is true?

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:

$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba

SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA;

System altered.

SQL> ALTER SESSION SET CONTAINER=app_root;

Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE ‘1.0’ TO ‘2.0’;

Pluggable database altered.

SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL);

Table altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO ‘2.0’;

Pluggable database altered.

SQL> ALTER SESSION SET CONTAINER=app_pdb1;

Session altered.

SQL> DESC emp;

Name       Null?       Type

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

ENO                   NUMBER

ENAME                 VARCHAR2(20)

SQL> SELECT * FROM emp;

ENO     ENAME

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

100     Alan

200     Ben

SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC;

What will be the outcome and why?

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:

$$

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?

（含图）

An online RMAN backup of the CDB was taken an Hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.

How do you achieve this?

Examine

This configuration:

1、CDB1 is a container database.

2、There are several pluggable databases (PDBs) in CDB1.

3、Each PDB has several tables with referential integrity constraints.

4、FLASHBACK DATABASE is ON.

5、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?