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

[不定项选择题]Choose two. Which two are true about backup encryption?
A. The Transparent Data Encryption (TDE) keystore is backed up using RMAN.
B. Vendor-specific media management software can be used for making
Encrypted RMAN backups to media.
C. The BACKUP BACKUPSET command can encrypt and decrypt backup sets.
D. Image copies can be encrypted.
E. Keystore-based encryption is the default mode for RMAN backup encryption.
F. Backup encryption can be enabled selectively for specific tablespaces.

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

If Automatic Memory Management is enabled, no memory advisors are

Available.

B.

If Automatic Memory Management is enabled, the Shared Pool Advisor and

Buffer Cache Advisor are available to set the maximum size for these individual

System Global Area components.

C.

All memory advisors use data from Automatic Workload Repository.

D.

If Automatic Shared Memory Management is enabled, both the SGA Advisor

And PGA Advisor are always available.

E. If Manual Shared Memory Management is enabled, only the Shared Pool
Advisor and Buffer Cache Advisor are available.

[不定项选择题]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 Optimizer Statistics?
A. They can be gathered by the DBMS_STATS package.
B. They provide real-time data about schema objects.
C. They are gathered by the SQL Tuning Advisor.
D. They are ignored by Optimizer if they are stale.
E. By default, they are automatically gathered by a maintenance job.

[不定项选择题]Choose two. Which two are true about Rapid Home Provisioning of

Oracle software?

A. It can be used for applications and middleware.
B. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
C. It can be used for both Oracle Database and Oracle Grid Infrastructure,
Including Oracle Restart.
D. It can be used for both Oracle Database and Oracle Grid Infrastructure,
Excluding Oracle Restart.
E. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

[不定项选择题]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 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 are true about poorly performing SQL

Statements and their tuning in Oracle database instances?

A. SQL statements performing many physical I/Os can always have their
Performance improved by creating indexes.
B. The solution that best optimizes one SQL statement can degrade the
Performance of others.
C. SQL statements doing joins always do more physical I/O than single table
Queries.
D. Poorly performing SQL statements can be tuned automatically by the Oracle
Server.
E. SQL statements doing only logical reads never require tuning because they do
No physical I/O.

[不定项选择题]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 the Optimizer Statistics Advisor?

A.

It always analyzes all schemas in the database.

B.

It can recommend changes to improve the statistics gathering process.

C.

It can be run only manually.

D.

It runs automatically every night by default.

E. It can be run only automatically.

[不定项选择题]Choose two.

Which two are true about RMAN virtual private catalogs (VPCs)?

A.

The RMAN catalog owner can grant access for an already registered database

To a new virtual catalog owner.

B.

Each VPC is owned by the recovery catalog schema owner.

C.

RMAN uses Oracle Virtual Private Database (VPD) to implement VPCs.

D.

Only one target database can be registered in a VPC.

E.

VPC functionality is enabled by default.

[不定项选择题]Choose two. Which two are true about the Program Global Area (PGA)

And its management in an Oracle database instance?

A.

The entire PGA is located in the System Global Area (SGA) when using shared

Servers.

B.

PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.

C.

The private SQL area (UGA) is located in the System Global Area (SGA) when

Using dedicated servers.

D.

The private SQL area (UGA) is located in the System Global Area (SGA) when

Using shared servers.

E. Sorts and Hash Joins use PGA memory.

[不定项选择题]Choose two. Which two are true about the automatic execution of

Operating system scripts when performing silent mode installation starting

From Oracle Database 19c?

A. The response file can specify the path of the sudo program.
B. The response file must contain the root or sudo password.
C. Silent install always runs operating scripts automatically.
D. The response file can specify the root or sudo password.
E. The installer will prompt for the root or sudo password.

[不定项选择题]Choose two. Which two are true about PDB archive files?
A. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.
B. They contain a PDB manifest file and all the data files in uncompressed form
For a PDB.
C. They contain all the data files only in uncompressed form for a PDB.
D. They must be created using the DBMS_PDB package.
E. They contain a PDB manifest file and all the data files in compressed form for a
PDB.
F. They contain all the data files only in compressed form for a PDB.

[不定项选择题]Choose two. Which two are true about an RPM-based Oracle Database

Installation?

A.

It includes the Oracle Preinstallation RPM.

B.

From Oracle Database 18c, a single RPM can be used to install only Oracle

Database Server for a single instance.

C.

It requires an Unbreakable Linux Network (ULN) subscription.

D.

It performs a software-only Oracle Database installation.

E. It uses a service configuration script to create a single-instance database as
Part of the installation.

[不定项选择题]Choose two. Which two are true about a read-only Oracle home?
A. It is enabled by performing a software-only Oracle Database installation and
Then running the roohctl enable script.
B. It requires the Rapid Home Provisioning service.
C. Its configuration data and log files reside in subdirectories under the Oracle
Home.
D. It is enabled by performing an Oracle Database installation with database
Creation and then running the roohctl -enable script.
E. It contains an image that can be distributed across multiple servers.

[不定项选择题]Choose two. Which two are true about Oracle Database Configuration

Assistant (DBCA)?

A. It can only be launched from the command line interface.
B. It can be launched from both the command line and the Universal Installer
(OUI) interfaces.
C. It can be used to create container databases and non-container databases.
D. It can be used to change the character set of an existing database.
E. It can be used to convert a non-container database to a container database.