[不定项选择题]Which three statements are true about Flashback Database?
A.

Flashback logs are written sequentially, and are archived.

B.

Flashback Database uses a restored control file to recover a database.

C.

The Oracle database automatically creates, deletes, and resides flashback logs

In the Fast Recovery Area.

D.

Flashback Database can recover a database to the state that it was in before a

Reset logs operation.

E. Flashback Database can recover a data file that was dropped during the span
Of time of the flashback.
F. Flashback logs are used to restore to the blocks' before images, and then the
Redo data may be used to roll forward to the desired flashback time.

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

[不定项选择题]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 two statements are true about recovering logically corrupted

Tables or table partitions from an RMAN backup?

A. Tables or table partitions can be recovered by using an auxiliary instance only.
B. Tables or table partitions with a foreign key cannot be recovered.
C. Tables or table partitions can be recovered only when the database is in
Mount state.
D. Tables or table partitions from the system and sysaux tablespaces cannot be
Recovered.
E. Tables with not null constraints cannot be recovered.

[不定项选择题]Which two statements are true about Resource Manager plans for

Individual pluggable databases (PDB plans) in a multitenant container

Database (CDB)?

A. If no PDB plan is enabled for a pluggable database, then all sessions for that
PDB are treated to an equal degree of the resource share of that PDB.
B. In a PDB plan, subplans may be used with up to eight consumer groups.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated
To consumer groups across all PDBs in the CDB.
D. If no PDB plan is enabled for a pluggable database, then the PDB share in the
CDB plan is dynamically calculated.
E. If a PDB plan is enabled for a pluggable database, then resources are allocated
To consumer groups based on the shares provided to the PDB in the CDB plan
And the shares provided to the consumer groups in the PDB plan.

[不定项选择题]Which two statements are true about the Database Configuration

Assistant (DBCA)?

A. It can configure Automatic Storage Management (ASM) diskgroups.
B. It can be used to copy an existing Oracle database to a new host and apply
Any patches necessary in the new host.
C. It can be used to add a new tablespace.
D. It can be used to create a database template from an existing database.
E. It can generate SQL database creation scripts.

[不定项选择题]Which two statements are true about RMAN duplexed backups?
A. It is not supported for image copies.
B. It is only supported for backups to tape via the media management interface.
C. Duplex backups can be performed on either disk or media, but cannot be
Performed on media and disk simultaneously.
D. Duplex backups can contain only data files and control files.
E. For performing duplexed backups, the parallelism for the device must be set
Equal to the number of copies.

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