[不定项选择题]Which two are true about gathering optimizer statistics? (Choose two.)
A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to
CDB$ROOT gathers
Object statistics in all open PDBs except PDB$SEED.
B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB
Opened in
Read/write mode gathers object statistics for that PDB.
C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to
CDB$ROOT gathers
Object statistics only in CDB$ROOT.
D. System statistics can be gathered only while connected to CDB$ROOT.
E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to
CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

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

[不定项选择题]Which two are true about instance recovery? (Choose two.)
A.

It is not possible if an archived log is missing.

B.

It is performed automatically after the database is opened; however, blocks

Requiring recovery are not available until they are recovered.

C.

Setting FAST_START_MTTR_TARGET to a lower value reduces instance

Recovery time by causing

Dirty buffers to be written to disk more frequently, thereby reducing the number

Of I/Os needed during instance recovery.

D.

It is performed by the Recovery Writer (RVWR) background process.

E. Setting FAST_START_MTTR_TARGET to a higher value reduces instance
Recovery time by causing
The log writer to write more frquently, thereby reducing the number of I/Os
Needed during instance recovery.
F.

It is performed automatically while the database remains in MOUNT state.

Then the database is opened.

[不定项选择题]Which two are true about Optimizer Statistics? (Choose two.)
A. They can be gathered by the DBMS_STATS package.
B. They are gathered by the SQL Tuning Advisor.
C. They provide real-time data about schema objects.
D. They are ignored by Optimizer if they are stale.
E. By default, they are automatically gathered by a maintenance job.

[不定项选择题]Which two are true about creating pluggable databases (PDBs) using

Snapshots in Oracle 19c and later releases? (Choose two.)

A.

A PDB snapshot is always a full copy of the source PDB.

B.

A PDB snapshot is always a sparse copy of the source PDB.

C.

A snapshot copy PDB depends on a storage snapshot which can only be

Stored on specific file systems.

D.

A PDB snapshot depends on a storage snapshot which can be stored on any

File system.

E.

A PDB snapshot depends on a storage snapshot which can only be stored on

Specific file systems.

F. A snapshot copy PDB depends on a storage snapshot which can be stored on
Any file system.
G. A snapshot copy PDB can be created from a stand-alone clone PDB.

[不定项选择题]Which two are true about Recovery Manager (RMAN) diagnostic

Message output? (Choose two.)

A.

Media Management messages for SBT devices are always written to sbtio.log.

B.

RMAN error stacks should be read from the bottom up as that is the order in

Which errors are generated.

C.

RMAN error stacks should be read from the top down as that is the order in

Which errors are generated.

D.

The RMAN LOG command line clause causes output issued during RMAN

Command

Compilation to be written to a log file and to standard output.

E.

The RMAN LOG command line clause causes output issued during RMAN

Command compilation to be written to a log file only.

F.

Media Management messages for

SBT devices are written to an Oracle trace file.

[不定项选择题]Which two are true about RMAN Multisection backups when a very

Large data file is divided into four sections? (Choose two.)

A. Each of the file sections must be processed serially.
B. The four sections can be created serially.
C. The four sections must be image copies.
D. The four sections can be created in parallel.
E. The four sections must be contained in backup sets.

[不定项选择题]Which two are true about Oracle Flashback features? (Choose two.)
A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVE D
REDO LOG files.
B. FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and
ARCHIVE D REDO
LOG files.
C. FLASHBACK TABLE can undrop a column.
D. FLASHBACK DROP can undrop an index when undropping a table.
E. After a database is restored from flashback logs using the FLASHBACK
DATABASE command, it is
Sometimes rolled forward using redo logs.

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

[不定项选择题]Which two are true about data movement between a non-CDB and a

PDB using Data Pump? (Choose two.)

A. Tablespaces are automatically created as need while importing full exports in
Either a non-CDB or a PDB.
B. Oracle attempts to convert conventional database users to local users when
Moving schemas from a non-CDB to a PDB.
C. A new PDB is automatically created when importing a non-CDB into a CDB.
D. Oracle attempts to convert common users to conventional users when moving
Schemas from a PDB to a non-CDB.
E. Moving data from a PDB to a non-CDB is only possible by using transportable
Tablespace export and import.
F. Moving data from a non-CDB to a PDB is only possible by using conventional
Export and import.

[不定项选择题]Which two are true about unplugging an application container from a

Container database and plugging it into a different container database?

A. It requires local undo mode in both container databases.
B. It requires only local undo mode in the database where the application
Container will beunplugged.
C. Plugging the application root into a different CDB plugs In all its application
PDBs.
D. Application PDBs In the application container must beunplugged before the
Application root Is unplugged.
E. Unplugging the application root from a CDB unplugs all its application PDBs.
F. The application root of an application container should be plugged Into the
Other CDB beforeIts application PDBs are plugged in.

[不定项选择题]Which two are true about Oracle Grid Infrastructure for a Standalone

Server? (Choose two.)

A. It supports volume management, file system, and automatic restart capabilities.
B. It must be installed before the Oracle database software is installed.
C. The CSS daemon runs from the Grid Infrastructure home.
D. It can manage database resources on the server where it is installed or on a
Different server.
E. It requires Oracle Automatic Storage Management (ASM) components to be
Installed separately.

[不定项选择题]Which two are true about automatic block repair? (Choose two.)
A.

Automatic block repair can repair blocks with no standby database if

DB_BLOCK_CHECKING = TRUE.

B.

Real-Time Query must be enabled on a physical standby database for

Automatic block repair to be done on that physical standby database.

C.

Real-Time Query must be enabled on a primary database for automatic block

Repair to be done on any of its physical standby databases.

D.

It is not possible for media corrupt blocks.

E. Real-Time Query must be enabled on a physical standby database for
Automatic block repair to be done on its primary database.