[不定项选择题]Choose the best answer. Which operating system group is NOT

Needed to perform an Oracle Database installation?

A.

OSASM

B.

OSRACDBA

C.

OSKMDBA

D.

OSDBA

E. OSOPER

[不定项选择题]Choose the best answer. Which statement correctly describes the SQL

Profiling performed by the SQL Tuning Advisor?

A.

It is a set of recommendations by the optimizer to change the access methods

Used.

B.

It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

C.

It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.

D.

It is auxiliary information collected by the optimizer for a SQL statement to

Help use better joins orders.

E. It is a set of recommendations by the optimizer to create new indexes.

[不定项选择题]Choose the best answer. Which should be tuned first when doing a
Performance tuning exercise for an Oracle Database environment?
A. log writer performance
B. database writer performance
C. general operating system health
D. SQL statements
E. database instance memory management and sizes

[不定项选择题]Which statement describes the significance of the CHANGE FAILURE

Command in RMAN? (Choose all that apply.) choose two

A.

It is used to change failure priority only for HIGH or LOW priorities.

B.

It is used to execute the advised repair script.

C.

It is used to change failure priority only for the CRITICAL priority.

D.

It is used to explicitly close the open failures.

E. It is used to inform the database about the repair after the repair script
Executes.

[不定项选择题]Which two are prerequisites for performing Flashback Transaction?
A.

Fast Recovery Area must be enabled for the database.

B.

The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK

Package.

C.

Undo retention guarantee must be configured for the database.

D.

A supplemental log must be enabled for the primary key.

E.

Row movement must be enabled.

[不定项选择题]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 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 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 requirements for various FLASHBACK
Operations? (Choose three.)
A. FLASHBACK transaction query requires undo to retrieve all versions of a row
That existed between two points in time.
B. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to
ON.
D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a
Table being tracked.
E. FLASHBACK drop requires undo to retrieve all versions of a row that existed
Between two points in time.
F. FLASHBACK version query requires undo to retrieve all versions of a row that
Existed between two points in time.

[不定项选择题]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 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 three tasks can be automatically performed by the Automatic
Data Optimization feature of Information lifecycle Management (ILM)?
A. Tracking the most recent read time for a table segment in a user tablespace
B. Tracking the most recent write time for a table segment in a user tablespace
C. Tracking insert time by row for table rows
D. Tracking the most recent write time for a table block
E. Tracking the most recent read time for a table segment in t he SYSTEM
Tablespace
F. Tracking the most recent write time for a table segment in t he SYSAUX
Tablespace

[不定项选择题]Which two are facets of performance planning that should always be

Considered or implemented for an Oracle Database environment? (Choose

Two.)

A. defining primary keys for all tables to speed up all queries
B. using check constraints to speed up updates
C. defining foreign keys for all tables to speed up joins
D. the physical data model
E. the configuration of storage arrays

[不定项选择题]Which three are true about Automatic Workload Repository (AWR),

Automatic Database Diagnostic Monitor (ADDM), and the Manageability

Monitor (MMON) background process? (Choose three.)

A. ADDM can recommend shrinking the buffer cache.
B. ADDM can recommend extending the buffer cache.
C. By default, MMON creates an AWR snapshot every 30 minutes.
D. ADDM performs its analysis only when a DBA requests it.
E. By default, AWR snapshots are automatically purged after eight days.
F. AWR snapshots must be deleted when no longer required by ADDM.

[不定项选择题]Which three are located by using environment variables? (Choose

Three.)

A.

the Optimal Flexible Architecture (OFA) compliant path to store Oracle

Software and configuration files.

B.

the location of Oracle Net Services configuration files

C.

the list of a disk group names to be mounted by an Oracle Automatic Storage

Management (ASM) instance at startup

D.

default directories for temporary files used by temporary tablespaces

E. the temporary disk space used by Oracle Installer during installation
F.

the maximum number of database files that can be opened by a database 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 three are true about monitoring waits for sessions and services?

(Choose three.)

A.

V$SESSION_EVENT displays all waits for all past and existing sessions if the

Wait has occurred at least once for a session.

B.

V$SERVICE_EVENT displays all waits for all services if the wait has occurred at

Least once for a service.

C.

V$SESSION_WAIT _CLASS displays waits broken down by wait class only for

Waiting sessions.

D.

V$SESSION_WAIT and V$SESSION both contain details of the event on which

A non-waiting session last waited.

E. V$SESSION_EVENT displays all waits for all past sessions if the wait has
Occurred at least once for a session.
F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a
Session is currently waiting.

[不定项选择题]Which three statements are true about Automatic Workload

Repository (AWR)?

A.

All AWR tables belong to the SYSTEM schema.

B.

The AWR data is stored in memory and in the database.

C.

The snapshots collected by AWR are used by the self-tuning components in the database

D.

AWR computes time model statistics based on time usage for activities, which

Are displayed in t he v$SYS time model and V$SESS_TIME_MODEL views.

E. AWR contains system wide tracing and logging information.

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