1z1-084問題集、Oracle実際の試験問題

質問 1

Which statement is true about DB time in V$$YS_TIME_MODEL?

A. DB time is organized as a simple list of statistics and any time period is attributable to only one statistic.

B. DB time can be many times greater than the elapsed time since the database instance started.

C. DB tine excludes the time spent waiting for a CPU in the operating system run queue.

D. DB time includes the time spent executing the RMAN backup and restore command.

正解: B

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

質問 2

Examine this output of a query of VSPGA_TAPGET_ADVICE:

Which statements is true'

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

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

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

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

正解: A

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

質問 3

You execute the following:
EXECUTE DBMS_AuTO_TASK_ADMIN.DISABLE;
Which advisor remains enabled?

A. Optimizer Statistics Advisor

B. Automatic SQL Tuning

C. Automatic Optimizer Statistics Collection

D. Automatic Segment Advisor

E. SQL Plan Management Evolve Advisor

正解: C

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

質問 4

Database performance has degraded recently.
index range scan operations on index ix_sales_time_id are slower due to an increase in buffer gets on sales table blocks.
Examine these attributes displayed by querying DBA_TABLES:

Now, examine these attributes displayed by querying DBA_INDEXES:

Which action will reduce the excessive buffer gets?

A. Re-create index IX_SALES_TIME_ID using ADVANCED COMPRESSION.

B. Re-create the SALES table using the columns in IX_SALES_TIME_ID as the hash partitioning key.

C. Re-create the SALES table sorted in order of index IX_SALES_TIME_ID.

D. Partition index IX_SALES_TIME_ID using hash partitioning.

正解: A

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

質問 5

Database performance degraded between 23:15 and 23:30 for the last three nights. The awr snapshot interval is one hour. The AODM report contains nothing about this performance problem.
With which tool can you further analyze this problem?

A. Active Session History report

B. SQL Performance Analyzer

C. AWR Compare Periods report

D. SQL Tuning Advisor

正解: A

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

質問 6

SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARGET is not set.
Which two statements are true?

A.

B.

C.

D.

E.

F.

G.

正解: A,B

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

Oracle Database 19c Performance and Tuning Management - 1z1-084 模擬練習