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

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

[不定项选择题]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 CDB has two regular PDBs as well as one application container

With two application PDBs and an application seed.No changes have been

Made to the standard PDB$SEED.How many default temporary tablespaces

Can be assigned in the CDB?

A.

six

B.

seven

C.

five

D.

eight

E. three

[不定项选择题]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 Which two statements are true about encrypted backups

Performed by using RMAN?

A. Transparent encryption of backups uses an encryption wallet.
B. Image copy backups can be created by using password encryption.
C. A password encryption of backups uses the password while creating and
Restoring backups.
D. Encrypted backups can only be written to disk.
E. A database uses the same encryption key for every encrypted backup.

[不定项选择题]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 two. Which two are prerequisites for using FLASHBACK TABLE?
A. A table's constraints must be disabled before issuing the flashback.
B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object
Privilege must be granted to the user performing the flashback.
C. Row Movement must be enabled on the table being flashed back.
D. A table's indexes must be set to unusable before issuing the flashback.
E. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object
Privilege must be granted to the table owner.

[不定项选择题]choose two Which two are true about RMAN image copies?
A.

) They can only be written to disk.

B.

) They can be encrypted using Transparent Data Encryption (TDE).

C.

) They can be used as a level 0 incremental backup.

D.

) They can be used as a level 1 incremental backup.

E.) They are the only backup option available for databases in NOARCHIVELOG
Mode.

[不定项选择题]Choose two. Which two are true about monitoring waits for sessions

And services?

A. V$SERVICE_EVENT displays wait counts for every wait event for each service
Even including counts of zero for waits that never occurred.
B. V$SESSION_WAIT and V$SESSION both contain details of the event on which
A non-waiting session last waited.
C. V$SESSION_WAIT and V$SESSION both contain details of the event on which
A waiting session is currently waiting.
D. V$SESSION_EVENT displays all waits events for those events that have
Occurred at least once for sessions that have now terminated.
E. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for
Terminated sessions.

[不定项选择题]Choose two.

Which two are true about unplugging an application container from a

Container database and plugging it into a different container database?

A.

Plugging the application root into a different CDB plugs in all its application

PDBs.

B.

The application root of an application container should be plugged into the

Other CDB before its application PDBs are plugged in.

C.

Application PDBs in the application container must be unplugged before the

Application root is unplugged.

D.

Unplugging the application root from a CDB unplugs all its application PDBs.

E. It requires only local UNDO mode in the database where the application
Container will be unplugged.
F. It requires local UNDO mode in both container databases.

[不定项选择题]Choose two. Which two are true about Lockdown profiles in a container

Database (CDB) and its pluggable databases (PDBs)?

A. A Lockdown profile created from a base Lockdown profile is always
Automatically modified if the profile on which it is based is modified.
B. A PDB Lockdown profile can be created in an application root.
C. A Lockdown profile created from a base Lockdown profile is never
Automatically modified if the profile on which it is based is modified.
D. A PDB Lockdown profile can be created in a regular PDB.
E. A PDB Lockdown profile can be created in CDB$ROOT .

[不定项选择题]Choose two.

Which two statements are true when row-archival management is enabled?

A.

The ORA_ARCHIVE_STATE column may only be queried by users with the DBA

Role set.

B.

The ORA_ARCHIVE_STATE column is only displayed if it is referenced in the

Column select list of a query

C.

The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows.

D.

The ORA_ARCHIVE_STATE column may only be updated by users with the

DBA role set.

E. The ORA_ARCHIVE_STATE column is updated in an overnight maintenance job
Based on activity tracking.

[不定项选择题]Choose two. Which two are true about RMAN persistent configuration

Settings, administration, and their effects?

A. A DBA must specify either a redundancy retention policy or a recovery window
Retention policy.
B. A target database's persistent RMAN configuration settings are always
Synchronized automatically with the RMAN catalog.
C. Backups older than the recovery window retention policy are always deleted
Automatically if the backup location has insufficient space.
D. Backups written to the fast recovery area (FRA) that are obsolete based on the
Redundancy retention policy can be deleted automatically to free space.
E. A target database's persistent RMAN configuration settings are always stored
In the target's control file

[不定项选择题]Choose two. Which two are true about various Oracle security and

Auditing capabilities?

A.

Application-common Transparent Security Data Protection (TSDP) policies can

Be created only if all the PDBs in the application container are closed.

B.

Application-common TSDP policies are always container specific.

C.

Application-common OLS policies can be created only if all the PDBs in the

Application container are closed.

D.

Unified auditing can be automatically synchronized to all application PDBs in

An application container.

E. Fine-grained auditing (FGA) policies in an application root are automatically
Synchronized to all application PDBs contained in the application container when
They are updated.

[不定项选择题]Choose two. Which two are true about server-generated alerts?
A.

Stateless alerts can be cleared manually.

B.

Stateless alerts are automatically cleared after one day.

C.

Stateful alerts are purged automatically from the alert history after one day.

D.

Stateless alerts can be purged manually from the alert history.

E.

Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.

[不定项选择题]Choose two. Which two are true about backup set compression using
RMAN default compression?
A. Compressed backups cannot have a section size defined.
B. Compressed backups can be written only to media.
C. Binary compression adds CPU overhead to backup operations.
D. Unused blocks below the high water mark are backed up.
E. Compression can be done only for locally managed tablespaces.