[不定项选择题]Choose three. Which three are true about block media recovery?
A. To use it, Flashback Database must be enabled.
B. A block being recovered is not accessible.
C. It cannot repair logical corruption.
D. It can be performed on noncorrupt blocks.
E. The target database for which one or more blocks are to be recovered must be
In the OPEN state.
F. The data file containing the block being recovered remains online.

[不定项选择题]choose three Which three are true about RMAN duplexed backup sets or image copies?
A.

A backup set may be duplexed with both copies written to disk.

B.

An image copy on disk can be copied to disk.

C.

A backup set may be duplexed with both copies written to sbt.

D.

A backup set may be duplexed so that one copy is written to sbt and the other

To disk.

E. An image copy on disk can be copied to sbt.
F. An image copy on sbt can be copied to disk.

[不定项选择题]choose three Which three are true about Transparent Data Encryption

(TDE)?

A. It uses a single master key for a database.
B. It replaces secure application roles.
C. It encrypts only data on the client.
D. It stores the current and all past master keys in the keystore.
E. Master encryption keys are managed by Oracle Database Vault.
F. It can encrypt data at the column level.

[不定项选择题]Choose three. Which three are true about an application container?
A. It must have an application root PDB.
B. Two application containers can share an application seed PDB.
C. It can contain multiple applications.
D. It can contain a single application.
E. It must have an application seed PDB.
F. An application PDB can belong to multiple application containers.

[不定项选择题]Choose three. Which three are true about using an RMAN Recovery

Catalog with a pluggable database (PDB) target connection in Oracle

Database 19c and later releases?

A.

The base catalog owner must give the Virtual Private Catalog access to

Metadata for one or more PDBs.

B.

The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

C.

The base catalog must be used by RMAN when performing point-in-time

Recovery for the PDB registered in the Virtual Private Catalog.

D.

The base catalog must be enabled for Virtual Private Catalog use.

E. The target PDB must be registered in a Virtual Private Catalog.
F. The target PDB must be registered in a base catalog.

[不定项选择题]Choose three. Which three are true about Oracle Restart?
A.

) It is used in both clustered and non-clustered environments.

B.

) You can add and remove components from an Oracle Restart configuration

With Server Control (SRVCTL) commands.

C.

) It runs from the Oracle Grid Infrastructure home.

D.

) If you shut down a database instance with SQL*Plus, Oracle Restart interprets

This as a database failure and attempts to restart the instance.

E.) The Server Control (SRVCTL) utility can be used to start and stop Oracle
Restart.
F.) It can manage Oracle Database instances, Oracle Net Listeners, and Oracle
Automatic Storage Management instances.

[不定项选择题]Choose three. Which three are true about Automatic Workload Repository

(AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle

Multitenant environment?

A. AWR snapshots can be created in CDB$ROOT.
B. ADDM can run in a nonroot container.
C. AWR reports can be generated while connected to any container.
D. All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
E. AWR snapshots can be created in a PDB.
F. No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

[不定项选择题]Choose three.

Which three are true about creating container databases (CDBs) and

Pluggable databases (PDBs) in Oracle 19c and later releases?

A.

A snapshot copy PDB can be a full copy of a source PDB.

B.

A snapshot copy PDB does not depend on an existing storage snapshot of the

Source PDB.

C.

A PDB snapshot depends on an existing storage snapshot of the source PDB.

D.

A PDB snapshot can be a full copy of a source PDB.

E. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in
Silent mode with no configuration required before starting the duplication.
F. A CDB can be duplicated using Recovery Manager (RMAN) with no
Configuration required before starting the duplication.
G. A PDB snapshot can be a sparse copy of a source PDB.

[不定项选择题]Choose three. Which three are true about recovery operations done
Without using Recovery Manager (RMAN)?
A. A lost PFILE can be re-created from alert.log using SQL*PLUS.
B. A lost index tablespace can be re-created without performing any recovery.
C. A lost password file can be manually re-created with the orapwd utility.
D. A lost password file can be re-created with SQL*PLUS.
E. A lost SPFILE can be recovered from memory using SQL*PLUS.
F. A lost TEMPFILE must always be re-created manually.

[不定项选择题]Choose three. Which three are true about Data Pump in an Oracle

Multitenant environment?

A. It can be used to transport data from a non-CDB to a PDB.
B. It can be used to clone a CDB.
C. It can be used to transport data between PDBs.
D. It can be used to transport data from a PDB to a non-CDB.
E. It can be used to create a new PDB.

[不定项选择题]Choose three. Which three are true about cloning databases into an

Existing CDB with RMAN?

A. A non-CDB can be cloned into a PDB.
B. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT
When cloning a PDB.
C. Only one PDB can be cloned at a time.
D. Two or more PDBs can be cloned with the same command.
E. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the
Non-CDB being cloned when cloning a non-CDB.
F. The target and auxiliary instance passwords must be the same.

[不定项选择题]Choose three. Which three are true about Recovery Manager (RMAN)

Active database duplication?

A. Pre-existing backups of the database to be duplicated are required for the
"push" method of duplication.
B. Pre-existing backups of the database to be duplicated are required for the
"pull" method of duplication.
C. Pre-existing backups of the database to be duplicated are always used if they
Exist.
D. Image copies can be used to duplicate the active database.
E. The active database must be duplicated while in OPEN state.
F. No connection to the recovery catalog is required for active database
Duplication.
G. Backup sets can be used to duplicate the active database.

[不定项选择题]Choose three. Which three are true about the Oracle Optimizer?
A.

It considers the filters in WHERE clauses when generating execution plans for SQL statements.

B.

It obeys all hints.

C.

It considers object statistics when generating execution plans for SQL statements.

D.

It updates stale object statistics in the Data Dictionary.

E. It can only use SQL Plan Directives tied to the SQL statement for which a plan
Is being generated.
F.

It can re-optimize execution plans after previous executions detect suboptimal plans.

[不定项选择题]Choose three.

Which three are true about actions that can or cannot be performed by users

With the SYSBACKUP privilege?

A.

They can view data from any data dictionary view or dynamic performance

View.

B.

They can drop any tablespace.

C.

They can view data from any user-defined tables.

D.

They can create any table.

E.

They cannot create restore points.

F.

They cannot drop tablespaces.