[不定项选择题]Choose three.

Your container database, CDB1, is in local undo mode.

You successfully execute this command while connected to CDB1:

CREATE PLUGGABLE DATABASE pdb1

ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT)

CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ;

Which three are true about PDB1?

A. It has the same common users defined as does CDB1.
B. It has only local roles.
C. It has the same number of roles as CDB1.
D. Service PDB1 is created for remote logins to PDB1.
E. It is in mount state after creation.
F. It has no local users.

[不定项选择题]Choose three.

A container database, CDB1, contains a pluggable database PDB1.

Another container database is called CDB2.

You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time.

Which three are required?

A.

CDB1 must be in archivelog mode.

B.

CDB2 must be in shared UNDO mode only.

C.

CDB1 and CDB2 must be in shared UNDO mode.

D.

CDB2 must be in archivelog mode.

E.

CDB1 and CDB2 must both be in local UNDO mode.

F. CDB1 must be in shared UNDO mode only.

[不定项选择题]Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. 

You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.

Which two are always true? (Choose two.)

A.

CDB1 and CDB2 must be in shared undo mode.

B.

A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.

C.

All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

D.

Cloning HR_ROOT automatically clones HR_PDB1.

E.

The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.

[不定项选择题]A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1.
PDB1 was unplugged from CDB1 earlier in the week.
Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING ‘/u01/app/oracle/oradata/pdb1.xml’
SOURCE_FILE_NAME_CONVERT =
(‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);
Which two are true? (Choose two.)
A. PDB1 data files already exist in the correct location.
B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before
Executing the command.
C. PDB_FILE_NAME_CONVERT must be set before executing the command.
D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of
Data files for PDB1.
E. PDB1 must be dropped from CDB1.

[不定项选择题]A container database (CDB) contains two pluggable databases PDB1

And PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in

The CDB. Data file 24 of PDB2 was deleted and you need to restore and

Recover it.

The only RMAN backup that exists was created with the BACKUP

DATABASE command while connected to CDB$ROOT. Which three are true?

(Choose three.)

A. Data file 24 can be recovered only while connected to PDB2.
B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
C. Data file 24 can be restored only while connected to CDB$ROOT.
D. Data file 24 can be restored only while connected to PDB2.
E. Data file 24 can be recovered while connected to PDB2.
F. Data file 24 can be recovered while connected to CDB$ROOT.

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

1) CDB1 and CDB2 are two container databases.

2) PDB1 is a pluggable database in CDB1.

3) PDB1_C1_SRV is a service for PDB1.

4) CDB1_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? (Choose two.)

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

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

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 DATABSE

6) RECOVER DATABASE NOREDO

7) RECOVER DATABASE UNTIL AVAILABLE

8) RESTORE ARCHIVELOG ALL

9) ALTER DATABSE OPEN

10)ALTER DATABASE OPEB RESETLOGS

Choose the minimum required steps in the correct order to recover the

Database.

A.

1, 3, 5, 8, 6, 10

B.

1, 3, 5, 6, 10

C.

1, 3, 5, 7, 10

D.

1, 2, 5, 7, 4, 10

E. 1, 3, 5, 6, 9

[不定项选择题]choose one
You enable Flashback Data Archive for a table for which you
Want to track and save all transactions for four years. After some time, the
Requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;
What is the outcome?
A. All historical data older than two years, if any, is purged from the flashback
Archive FDA1.
B. An error is returned because the retention period cannot be reduced.
C. All the flashback data archives are purged and the subsequently created
Flashback archives are maintained for two years.
D. All historical data older than two years, if any, is archived to flashback logs and
The flashback archive is set to new retention time.

[不定项选择题]choose two You take your database backups by using the RMAN

Media management interface (MMI).

Which two are true about the use of

The RMAN MMI?

A.

You can use it to create proxy copies for database files.

B.

You can use it to create proxy copies for entire file systems.

C.

You can use it to create image copies for entire file systems.

D.

You can use it to create image copies for database files.

E. You can use it to create backup sets for database files.

[不定项选择题]choose three Which three RMAN persistent settings can be set

Explicitly?

A. SPFILE backup duplexing
B. control file auto backup formats
C. archive log deletion policy
D. image copy duplexing
E. redo log backup duplexing
F. archive log backup duplexing

[不定项选择题]choose three

Which three are true about unified auditing in full mode?

A.

The unified audit trail is written to a read-only table.

B.

The unified audit trail is written to a read-only external file.

C.

Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D.

Audit records are created for SYS.

E. Audit records are created for non-sys users.

[不定项选择题]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 three. Which three capabilities require the use of the RMAN

Recovery catalog?

A. using RMAN stored scripts
B. creating encrypted backups
C. creating customized reports about a single database's backups
D. using the REPORT SCHEMA command to list a database's data files and
Tablespaces at times in the past
E. using the KEEP FOREVER clause with the BACKUP command
F. using the REPORT SCHEMA command to list a database's current data files and
Tablespaces

[不定项选择题]Choose three. Which three activities are possible for PDBs?
A. converting an application seed to an application PDB
B. converting a regular PDB to an application PDB
C. converting an application PDB to an application root
D. copying an application container into another application container in the
Same CDB
E. copying an application container into another application container in a
Different CDB
F. converting an application PDB to an application seed
G. converting an application PDB to a regular PDB

[不定项选择题]Choose two. Your database is in ARCHIVELOG mode and you plan to

Use Flashback Database. Which two features or parameters manage space

Availability in the fast recovery area?

A. the backup retention policy
B. the backup optimization policy
C. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
D. the archived log deletion policy
E. the DB_RECOVERY_FILE_DEST parameter setting
F. using guaranteed UNDO retention

[不定项选择题]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 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 three
You want to duplicate one of your databases when
Connected to the target database and to the recovery catalog.
Which three are true about this type of database duplication?
A.) The duplication process can create backup sets or image copies.
B.) The target database must be open.
C.) The duplication process can use existing backup sets or image copies.
D.) The target database must be in mount state.
E.) The duplication process pushes backup sets to the auxiliary instance.
F.) The duplication process pushes image copies to the auxiliary instance.

[不定项选择题]Choose two. Which two restrictions apply when the RMAN BACKUP AS

COPY command is used to create a backup?

A.

Backups can be taken only if a fast recovery area is configured.

B.

Backups can be written only to disk.

C.

Backups can be taken only for data files.

D.

Binary compression cannot be applied to the backup.

E. Backups can be written only if checksums are stored for each block.
F. Backups can be written only to media.

[不定项选择题]choose three. Identify three reasons for using a recovery catalog with

Recovery Manager (RMAN).

A.

to allow database duplication without a connection to the target instance.

B.

to store backup metadata that would cause the controlfile to become too large.

C.

to store backups that would cause the controlfile to become too large.

D.

to report on the database schema at an earlier point in time.

E.

to allow database duplication without a connection to the auxiliary instance.