[不定项选择题]Which three are true about using an RMAN Recovery Catalog with a

Pluggable database (PDB) target connection in Oracle Database 19c and

Later releases?(Choose three.)

A.

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

Metadata for one or more PDBs.

B.

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

C.

The target PDB must be registered in a base catalog.

D.

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

Recovery for the PDB registered in the Virtual Private Catalog.

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

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

[不定项选择题]Which three are true about RMAN persistent configuration settings,

Administration, and their effects? (Choose three.)

A. A target database’s persistent RMAN configuration settings are always stored
In the target’s control file
B. Backup older than the recovery window retention policy are always deleted
Automatically if the backup location has insufficient space.
C. Backups written to the fast recovery area (FRA) that are oboslete based on the
Redundancy retention policy can be deleted automatically to free space.
D. The RMAN SHOW ALL command displays only settings with nondefault
Values.
E. A target database’s persistent RMAN configuration settings are always
Synchronized automatically with the RMAN catalog.
F. The V$RMAN_CONFIGURATION view displays only settings with valuesthat
Have been modified.
G.A DBA must specify either a redundancy retention policy or a recovery window
Retention policy.

[不定项选择题]Which three are true about RMAN archival backups with the RESTORE

POINT clause? (Choose three.)

A.

All archive logs are retained after an archival backup is taken, until the next

Archival backup is taken of the same database.

B.

The SPFILE is included in the archival backup.

C.

They are never considered obsolete by RMAN.

D.

Archive logs are retained if they are necessary to allow the database to be

Recovered to aconsistent state when an archival backup is restored.

E. The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
F.

They can optionally be written to a fast recovery area (FRA).

G.

Use of a recovery catalog is always required to support the creation and use of Archival backups.

[不定项选择题]Which three are true about using Database Resource Manager in an

Oracle multitenant environment? (Choose three.)

A.

A PDB-level resource plan can limit session PGA memory.

B.

A CDB-level resource plan can limit PDB CPU utilization.

C.

A CDB-level resource plan can limit session CPU utilization.

D.

PDB-level resource plans can limit uncommitted UNDO per consumer group.

E. A CDB-level resource plan can limit PDB UNDO use.
F. A CDB-level resource plan is mandatory when using PDB-level resource plans.

[不定项选择题]Which three statements are true about the keystore storage framework

For transparent data encryption?

A. It facilitates and helps to enforce keystore backup requirements.
B. It handles encrypted data without modifying applications.
C. It enables a keystore to be stored only in a file on a file system.
D. It enables separation of duties between the database administrator and the
Security administrator.
E. It transparently decrypts data for the database users and applications that
Access this data.
F. It helps to track encryption keys and implement requirements such as keystore
Password rotation and master encryption key reset or re-key operations.

[不定项选择题]Which three statements are true about Automatic Workload

Repository (AWR)?

A.

All AWR tables belong to the SYSTEM schema.

B.

The AWR data is stored in memory and in the database.

C.

The snapshots collected by AWR are used by the self-tuning components in the database

D.

AWR computes time model statistics based on time usage for activities, which

Are displayed in t he v$SYS time model and V$SESS_TIME_MODEL views.

E. AWR contains system wide tracing and logging information.

[不定项选择题]Which three statements are true about Flashback Data Archive?
A. To use Flashback Data Archive, users must have unlimited quota on the
Flashback Data Archive tablespace.
B. To enable Flashback Data Archive for a table, it is mandatory to have a default
Flashback Data Archive for a database.
C. While enabling Flashback Data Archive for a table, if no name is provided for
Flashback Data Archive, it is enabled using the default Flashback Data Archive.
D. A table enabled for Flashback Data Archive cannot be dropped unless
Flashback Data Archive is disabled or disassociated first.
E. Flashback Data Archive prevents flashback queries from getting a
Snapshot-too-old error.

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

[不定项选择题]Choose three. Which three are true about a whole database backup?
A. It can be created only by using RMAN.
B. It always includes all data files, the current control file, the server parameter file,
And archived redo logs.
C. It can be consistent.
D. It is the only possible backup type for a database in NOARCHIVELOG mode.
E. It can consist of either backup sets or image copies.
F. It can be inconsistent.

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

They are installed via OPatch or OPatchAuto.

B.

A base release is not needed to install patchsets.

C.

They can be applied in a rolling fashion for Clusterware and the databases.

D.

Installing a patchset is considered an "upgrade."

E.

They can introduce new features.

F.

They are only released quarterly.

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

An application container?

A.

An application root clone gets created automatically.

B.

The upgrade can be performed when connected either to CDB$ROOT or to

PDB$SEED.

C.

After an application upgrade, the application container's PDBs remain

Synchronized with the existing application root.

D.

The upgrade must be performed when connected to CDB$ROOT.

E. An application name and version number must be specified to upgrade the
Application.
F. After an application upgrade, the application container's PDBs are
Automatically synchronized with the application root clone.