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

[不定项选择题]Choose two. Which two are true about monitoring waits for sessions

And services?

A. V$SERVICE_EVENT displays wait counts for every wait event for each service
Even including counts of zero for waits that never occurred.
B. V$SESSION_WAIT and V$SESSION both contain details of the event on which
A non-waiting session last waited.
C. V$SESSION_WAIT and V$SESSION both contain details of the event on which
A waiting session is currently waiting.
D. V$SESSION_EVENT displays all waits events for those events that have
Occurred at least once for sessions that have now terminated.
E. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for
Terminated sessions.

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

[不定项选择题]Which two are true about reclaiming space used by Flashback logs in

Oracle Database 19c later releases? (Choose two.)

A.

Space is always reclaimed automatically when the retention period for

Flashback logs is lowered.

B.

Space might be reclaimed proactively before space pressure occurs.

C.

Space might be reclaimed automatically when the retention period for

Flashback logs is lowered.

D.

Space is only reclaimed when there is space pressure in the Fast Recovery Area.

(FRA)

E. Space is always reclaimed proactively before space pressure occurs.

[不定项选择题]Which two are true about Oracle Optimizer Statistics, their use, and

Their collection? (Choose two.)

A. The number of table rows is considered when evaluating the cost of accessing
A table using an index.
B. Index balanced B*Tree height is considered when evaluating the cost of using
An index.
C. The Statistics Advisor can help recommend the best way to gather statistics.
D. Statistics collected using DBMS_STATS always yield the best optimizer result.
E. The Statistics Advisor generates actions for all recommendations.

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

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

[不定项选择题]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 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 diagnosing Oracle Database failure situations

Using Data Recovery Advisor? (Choose two.)

A.

Using the Data Recovery Advisor LIST FAILURE command always requires that

The database for Which failures are to be listed is in MOUNT state.

B.

A failure can be closed only when it has been repaired.

C.

Data Recovery Advisor can be used if a database is closed.

D.

The Data Recovery Advisor CHANGE FAILURE command can be used only to

Change failure priorities.

E. Data Recovery Advisor can proactively check for failures.

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

[不定项选择题]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 are true about RMAN backups when using a media manager?

(Choose two.)

A. A media manager always writes RMAN requested backups to tape.
B. By default, a request for a proxy copy may result in a backup set being created.
C. A media manager is required to create RMAN proxy copies.
D. A media manager is required to create RMAN image copies.
E. The media manager layer (MML) routines provided by Oracle support any
Vendors' media management products.