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

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

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

[不定项选择题]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 (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 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 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 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 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 the best answer.

Examine this configuration:

1CDB1 is a container database.

2COMMON_USER_PREFIX is set to an empty string.

3PDB1 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 sqlplus sys/oracle@localhost:1521/cdb1 as sysdba

SQL> CREATE ROLE role1 CONTAINER=CURRENT;

Which is true?

A.

It will return an error because creation of a local role is not allowed in

CDB$ROOT.

B.

ROLE1 will be created only in CDB$ROOT.

C.

It will return an error because common roles must start with C##.

D.

ROLE1 will be created only in CDB$ROOT and APP1_ROOT.

E. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.

[不定项选择题]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 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 two. Some archived log backups have been accidentally

Deleted from storage. Which two commands should be used to update the

Status of backups in the recovery catalog to display only the missing

Backups?

A. RESYNC CATALOG
B. CROSSCHECK BACKUP OF ARCHIVELOG ALL
C. LIST ARCHIVELOG ALL
D. LIST EXPIRED
E. LIST ARCHIVELOG
F. REPORT OBSOLETE

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