1z1-084試験無料問題集（57題）「Oracle Database 19c Performance and Tuning Management 認定」

出題：1

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

A. With a target of 700 MB or more, all multipass executions work areas would be eliminated.

B. GGREGATE_TARGET should be set to at least 700 MB.

C. With a target of 800 MB or more, all one-pass execution work areas would be eliminated.

D. PGAA_AGGREGATE should be set to at least 800 MB.

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which two Oracle Database features use database services?

A. Oracle SQL Tuning Advisor

B. Database Resource Manager

C. Oracle Scheduler

D. Oracle Automatic Reoptimization

E. Oracle SQL Performance Management

正解：B,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

A database instance is suffering poor I/O performance on two frequently accessed large tables.
No Big Table caching occurs in the database.
Examine these parameter settings:

Which are two actions either one of which will allow Big Table caching to occur?

A. Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 50

B. Setting PARALLEL_DEGREE_POLICYAUTO

C. Increasing DB_BIG_TABLE_CACHE_PERCENT_TARGET to at least 25

D. Setting PARALLEL_DEGREE_POLICYADAPTIVE

E. Increasing DB_CACHESIZE to 1 G

F. Setting DB_KEEP_CACHE_SIZE to at least 50M

正解：C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Examine this command:

What is the maximum number of baselines generated by this command that you can have at any given time?

A. 1

B. 52

C. 5

D. 3

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Examine these commands, which execute successfully:

Which statement is true?

A. ADDM, AWR, and ASH reports can be purged automatically.

B. AD DM is enabled for all pluggable databases.

C. AWR snapshots can be purged manually in pluggable databases.

D. AWR- snapshots in all pluggable databases will be purgedautomatically after every 60 mins.

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which procedure gathers statistics that are always used in the generation of any execution plan?

A. DBMS_STATS.GATHER_FIXED_ OBJECTS_STATS

B. DBMS_STATS.GATHER_SYSTEM_STATS

C. DBMS_STATS.GATHER_DATABASE_STATS

D. DBMS_STATS.GATHER_DICTIONARY_STATS

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1z1-084試験無料問題集「Oracle Database 19c Performance and Tuning Management 認定」