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

[不定项选择题]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 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 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 backup set compression using RMAN default

Compression? (Choose two.)

A.

Compressed backups can be written only to media.

B.

Binary compression adds CPU overhead to backup operations.

C.

Unused blocks below the high water mark are backed up.

D.

Compressed backups cannot have a section size defined.

E. Compression can be done only for locally managed tablespaces.

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

To write backups to tape when there are only two tape drives? (Choose two.)

A.

SBT tape compression can be used even if no RMAN compression is configured.

B.

Any backup set written to the SBT device in this configuration can contain a

Maximum of two backup pieces.

C.

Any backup written to the SBT device in this configuration can contain a

Maximum of two backup sets.

D.

SBT tape compression and RMAN backup compression should be used in Parallel.

E.

The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

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