[不定项选择题]Choose the best answer. Examine this configuration:

1CDB1 is a container database.

2 DEFAULT_SHARING is METADATA.

3APP_ROOT is an application root contained in CDB1.

4APP_PDB1 is an application PDB contained in APP_ROOT.

5COMPANYAPP is an application contained in APP_ROOT.

6EMP 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/orac1e@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?

A.

SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows.

B.

SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows.

C.

It will return an error because the SYNC operation is not allowed when

Constraints are added to common objects.

D.

It will return an error because EMP is not empty in APP_ROOT.

E. It will return an error because EMP.SAL is empty in APP_ROOT.

[不定项选择题]Choose the best answer. Examine this configuration:

1 CDB1 is a container database.

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

5Each PDB has several tables with referential integrity constraints.

6FLASHBACK DATABASE 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?

A.

restore and recover database

B.

flashback transaction

C.

flashback database

D.

flashback table and transaction

E. flashback table

[不定项选择题]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

[不定项选择题]Choose the best answer. Examine this output of an export from the

Current release of an Oracle multitenant database:

$ 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?

A.

It fails because Data Pump cannot be used while connected to the root

Container.

B.

It creates a full export of the root container and PDB1.

C.

It creates a full export of the root container and all PDBs.

D.

It creates a full export of the root container and all open PDBs.

E. It creates a full export of only the root container.

[不定项选择题]Choose the best answer.Examine this output of an export from the

Current release of an Oracle multitenant database: $ 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?

A.

It fails because Data Pump cannot be used while connected to the root container.

B.

It creates a full export of the root and pdb1.

C.

It creates a full export of the root and all pdbs

.

D.

It creates a full export of the root container and all open pdbs.

E.

It creates a full export of only the root container

[不定项选择题]choose two Examine the command to duplicate a database:

RMAN> DUPLICATE TARGET DATABASE

TO cdb

PLUGGABLE DATABASE pdbl,pdb5;

Which two statements are true about the DUPLICATE command?

A. The root and the seed database in the container database (CDB) are also
Duplicated.
B. A backup of PDB1 and PDB5 must exist before executing the command.
C. The SPFILE is copied along with the data files of the pluggable databases
(PDBs).
D. An auxiliary instance must be started with the initialization parameter
ENABLE_PLUGGABLE_DATABASE set to TRUE.
E. The DUPLICATE command first creates a backup, and then duplicates the PDBs
By using the backup.

[不定项选择题]choose one Examine the RMAN commands:

RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";

RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";

RMAN> DUPLICATE TARGET DATABASE TO dup_db

FROM ACTIVE DATABASE

PASSWORD FILE

SECTION SIZE 400M;

Which statement is true about the DUPLICATE command?

A.

It succeeds and creates multisection backup sets that are used for active

Database duplication.

B.

It fails because there is no connection to a recovery catalog.

C.

It succeeds only if the target database is in MOUNT state.

D.

It fails because no parallel channels are allocated for the auxiliary database.

[不定项选择题]Choose two.

Examine this configuration:

1CDB1 and CDB2 are two container databases.

2 PDB1 is a pluggable database in CDB1.

3 PDB1_C1_SRV is a service for PDB1.

4CDB1_LINK is a database link in CDB2 referring to PDB1.

5 CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database

Default service.

You execute these commands successfully:

$ sqlplus sys/oracle_4U@cdb2 as sysdba

SQL> CREATE PLUGGABLE DATABASE PDB1

FROM PDB1@CDB1_LINK

SERVICE_NAME_CONVERT=('PDB1_C1_SRV', 'PDB1_C2_SRV') ;

Which two are true?

A. PDB1_C2_SRV will be created but not started.
B. PDB1 will be created in CDB2 and automatically opened.
C. PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.
D. PDB1 will be created in CDB2 and left in MOUNT state.
E. PDB1_C2_SRV will be created and started automatically.

[不定项选择题]Choose two. Examine this configuration:

1 CDB1 is a container database.

2 APP1_ROOT is an application container contained in CDB1.

3 APP1_ROOT$SEED is the application seed contained in APP1_ROOT and

Synchronized with APP1_ROOT.

4 APP1_PDB1 and APP1_PDB2 are application PDBs contained in

APP1_ROOT.

5 APP1_USER_APP is an application installed in APP1_ROOT at version 1.0.

6 USER1 is a common user in APP1_ROOT and all its application PDBs,

Created when version 1.0 of APP1_USER_APP was installed.

You execute these commands:

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

SQL> ALTER SESSION SET CONTAINER=app1_root;

Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN

UPGRADE '1.0' TO '2.0';

Pluggable database altered.

SQL> GRANT CREATE SESSION TO USER1;

Grant succeeded.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END

UPGRADE TO '2.0'; Pluggable database altered

SQL> ALTER SESSION SET CONTAINER=app1_pdb1;

Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC;

Pluggable database altered.

Which two are true?

A. USER1 can connect to CDB1.
B. USER1 can connect to APP1_ROOT and APP1_PDB1.
C. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.
D.

USER1 is defined in APP1_PDB2. 

E.

USER1 can connect only to APP1_PDB1

F.

USER1 can connect only to APP1_ROOT.

[不定项选择题]Choose the best answer.

SQL Performance Analyzer (SPA) has reported several regressed SQL

Statements for one of your databases.

Which action could help in the performance management of these regressed

SQL statements?

A.

Create SQL plan directives for each of the regressed statements.

B.

Use The SQL Tuning Advisor for each of the regressed statements.

C.

Create an adaptive execution plan for each of the regressed statements.

D.

Use the SQL Access Advisor for each of the regressed statements.

[不定项选择题]Choose the best answer
You want to create a duplicate database
DUP_DB from your production database PROD on the same host. The PROD
Database uses Automatic Storage Management (ASM) for storage.
Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE
DATABASE;
What is a prerequisite for the successful execution of this command
A. RMAN must be connected to the target database instance and the auxiliary
Instance.
B. A most recent backup set of the PROD database must exist.
C. Flashback must be enabled for the PROD database.
D. The target database must be in MOUNT state.

[不定项选择题]Choose the best answer. Which statement correctly describes the SQL

Profiling performed by the SQL Tuning Advisor?

A.

It is a set of recommendations by the optimizer to change the access methods

Used.

B.

It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

C.

It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.

D.

It is auxiliary information collected by the optimizer for a SQL statement to

Help use better joins orders.

E. It is a set of recommendations by the optimizer to create new indexes.

[不定项选择题]Choose the best answer. Which operating system group is NOT

Needed to perform an Oracle Database installation?

A.

OSASM

B.

OSRACDBA

C.

OSKMDBA

D.

OSDBA

E. OSOPER

[不定项选择题]Choose the best answer. You want to transport the UNIVERSITY

Tablespace from one database to another. The UNIVERSITY tablespace is

Currently open read/write. The source and destination platforms have the

Same endian Examine this list of steps:. 

1. Make the UNIVERSITY tablespace read-only on the source 

2. Export the UNIVERSITY tablespace metadata using EXPDP. 

3. Create a cross-platform backup set from the UNIVERSITY

Source system, using an RMAN command that includes the DATAPUMP clause. 

4. Copy the cross-platform backup sets to the destination system. 

5. Copy the Data Pump dump set from the source to the destination system. 

6. Restore the cross-platform backup set on the destination system using an

RMAN command that includes the DATAPUMP clause. 

7. Import the UNIVERSITY tablespace metadata using IMPDP. 

8. Make the UNIVERSITY Tablespace read/write on the destination system. 

Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY Tablespace?

A.

3,4,6

B.

2,3,4,5,6,7

C.

1,3,4,6,8

D.

1,2,3,4,5,6,7,8

[不定项选择题]Choose the best answer. Which should be tuned first when doing a
Performance tuning exercise for an Oracle Database environment?
A. log writer performance
B. database writer performance
C. general operating system health
D. SQL statements
E. database instance memory management and sizes

[不定项选择题]Choose the best answer.

How do you configure a CDB for local undo mode?

A.

Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO

Tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then

Restart the CDB

Instance.

B.

Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER

DATABASE LOCAL UNDO ON, and then restart the CDB instance.

C.

Open the CDB instance in upgrade mode. In each PDB, execute ALTER

DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the

CDB instance.

D.

Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER

DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and

Then restart the CDB instance.

E. Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE
LOCAL UNDO ON, and then change the CDB to read/write mode.