[单选题]当 a>all(2,12,18)and a<any(5,10,20)为 true，a 的值为 1
A.6
B.12
C.19
D.22

[单选题]当 a>al(2, 12,18) and aA.22
B.19
C.6
D.12

[判断题]逻辑值TRUE大于FALSE( )
A.正确
B.错误

[单选题]•TRUE大会一共有几场分论坛
A.4
B.6
C.8
D.10

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

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

[不定项选择题]choose three

Which three are true about unified auditing in full mode?

A.

The unified audit trail is written to a read-only table.

B.

The unified audit trail is written to a read-only external file.

C.

Audit records are created for COMMIT, ROLLBACK, and SAVEPOINT statements.

D.

Audit records are created for SYS.

E. Audit records are created for non-sys users.