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

[不定项选择题]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 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 unplugging an application container from a

Container database and plugging it into a different container database?

A.

Plugging the application root into a different CDB plugs in all its application

PDBs.

B.

The application root of an application container should be plugged into the

Other CDB before its application PDBs are plugged in.

C.

Application PDBs in the application container must be unplugged before the

Application root is unplugged.

D.

Unplugging the application root from a CDB unplugs all its application PDBs.

E. It requires only local UNDO mode in the database where the application
Container will be unplugged.
F. It requires local UNDO mode in both container databases.

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

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

[不定项选择题]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 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 duplicating pluggable databases (PDBs) with

RMAN? (Choose two.)

A.

Two or more PDBs can be duplicated with the same RMAN DUPLICATE

Command.

B.

All tablespaces belonging to a PDB must be duplicated when duplicating the

PDB.

C.

The auxiliary instance is automatically created with

ENABLE_PLUGGABLE_DATABASE = TRUE.

D.

A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB

To duplicate it.

E. CDB$ROOT and PDB$SEED are automatically duplicated.

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