[不定项选择题]Which four are true about a Recovery Manager (RMAN) duplication

Without a TARGET connection? (Choose four.)

A. The NOREDO clause must be used if the backups of the database being
Duplicated were taken when the database was in NOARCHIVELOG mode.
B. The UNDO TABLESPACE clause is always required when no connection exists
To the TARGET instance.
C. RMAN “pushes” the backups of the database to be duplicated over the
Network to the auxiliary instance.
D. The NOREDO clause can be used if the backups of the database being
Duplicated were taken when the database was in ARCHIVE LOG mode.
E. RMAN SBT-based backups of the database to be duplicated can be used by
The auxiliary instance.
F. The UNDO TABLESPACE clause is always required when no connection exists
To the recovery catalog and the TARGET database is closed.
G. The UNDO TABLESPACE clause is always required when no connection exists
To the recovery catalog and the TARGET database is opened.
H. RMAN disk-based backups of the database to be duplicated can be used by
The auxiliary instance.

[不定项选择题]Which three are true about Recovery Manager (RMAN) in Oracle Database

19c and later releases? (Choose three.)

A. It is only possible for RMAN to connect to a pluggable database as a target if
An RMAN Virtual Private Catalog is used.
B. It is always possible for RMAN to connect to a pluggable database as a target
If any RMAN Catalog is used.
C. A Virtual Private Catalog used to register a container database must be
Created in a pluggable database.
D. A Virtual Private Catalog used to register a container database can be created
In a pluggable database.
E. It is always possible for RMAN to connect to a pluggable database as a target.
F. A Virtual Private Catalog used to register a container database can be created
In a non-container database.

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

[不定项选择题]Choose four. Which four are true about performing Tablespace

Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

A.

It can be performed using an auxiliary instance managed by RMAN.

B.

It can be performed using an auxiliary instance managed by a DBA.

C.

It can be used to recover a truncated table.

D.

It can be performed repeatedly until the correct time is found without using an

RMAN catalog. 

E.

RMAN always includes tablespaces containing UNDO segments

In the recovery set.

F.

RMAN automatically adds any required tablespaces to the recovery set to

Make it selfcontained.

G. FLASHBACK DATABASE must be enabled for it to work.
H. It can be used to recover a dropped tablespace.

[不定项选择题]Which four are true about RMAN backup sets? (Choose four.)
A. A backup piece can belong to only one backup set.
B. A data file can be split into multiple sections stored in different backup sets.
C. A data file can be split into multiple sections stored in different backup pieces
In the same backup set.
D. Blocks from multiple data files can be contained in one backup piece,
E. A backup set can contain only one backup piece.
F. A backup set must be written to media.
G. A backup set must be written to disk.
H. Blocks from multiple data files can be contained in one backup set,

[不定项选择题]Which four are true about duplicating a database using Recovery
Manager (RMAN)? (Choose four.)
A. Duplication can be done by having the auxiliary database instance pull backup
Sets from the target database instance.
B. A connection to an auxiliary instance is always required.
C. A subset of the target database can be duplicated.
D. A new DBID is always created for the duplicated database.
E. A connection to the recovery catalog instance is always required.
F. A backup of the target database is always required.
G. Duplication can be done by having the target database instance push copies
To the auxiliary database instance.
H. A connection to the target database instance is always required.

[不定项选择题]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 flashback features in Oracle Database 19c and

Later releases? (Choose two.)

A.Flashback logs are automatically purged when
DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have
Already been retained.
B. Flashback logs are monitored and proactively deleted when beyond the
Retention period defined in DB_FLASHBACK_RETENTION_TARGET only after
There is space pressure.
C. Flashback logs are monitored and proactively deleted when beyond the
Retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is
Space pressure.
D. Flashback logs are monitored for being older than the retention period
Defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an
Administrator written event trigger.
E. Flashback logs are automatically purged whenever the value of
DB_FLASHBACK_RETENTION_TARGET is changed.

[不定项选择题]Which three are true about upgrading Oracle Grid Infrastructure?

(Choose three.)

A.

A direct upgrade can be performed only from the immediately preceding

Oracle Grid Infrastructure version.

B.

The newer version is installed in a separate Oracle Grid Infrastructure home on

The same server as the existing version.

C.

An existing Oracle base can be used.

D.

The upgrade process will automatically install all mandatory patches for the

Current version of Oracle Grid Infrastructure.

E. Existing Oracle Database instances must be shut down before starting the
Upgrade.
F. Only the grid user can perform the upgrade.

[不定项选择题]Which three are true about RMAN persistent configuration settings,

Administration, and their effects? (Choose three.)

A. A target database’s persistent RMAN configuration settings are always stored
In the target’s control file
B. Backup older than the recovery window retention policy are always deleted
Automatically if the backup location has insufficient space.
C. Backups written to the fast recovery area (FRA) that are oboslete based on the
Redundancy retention policy can be deleted automatically to free space.
D. The RMAN SHOW ALL command displays only settings with nondefault
Values.
E. A target database’s persistent RMAN configuration settings are always
Synchronized automatically with the RMAN catalog.
F. The V$RMAN_CONFIGURATION view displays only settings with valuesthat
Have been modified.
G.A DBA must specify either a redundancy retention policy or a recovery window
Retention policy.

[不定项选择题]Which three are true about using Database Resource Manager in an

Oracle multitenant environment? (Choose three.)

A.

A PDB-level resource plan can limit session PGA memory.

B.

A CDB-level resource plan can limit PDB CPU utilization.

C.

A CDB-level resource plan can limit session CPU utilization.

D.

PDB-level resource plans can limit uncommitted UNDO per consumer group.

E. A CDB-level resource plan can limit PDB UNDO use.
F. A CDB-level resource plan is mandatory when using PDB-level resource plans.

[不定项选择题]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 three are true about Optimizer Statistics Advisor? (Choose

Three.)

A. It can be run only manually.
B. It is part of the DBMS_ADVISOR package.
C. It can recommend changes to improve the statistics gathering process.
D. It always analyzes all schemas in the database.
E. It runs automatically every night by default.
F. It is part of the DBMS_STATS package.

[不定项选择题]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 three are true about Automatic Workload Repository (AWR)

Snapshots?

A. They can be retained forever.
B. They are always created automatically.
C. They are always created manually.
D. They are generated if STATISTICS LEVEL is set to TYPICAL.
E. They are generated if STATISTICS LEVEL is set to BASIC.
F. They are generated if STATISTICS LEVEL is set to ALL.

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