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

出題：1

Which two types of performance problems are reported by ADDM for PDBS?

A. SGA sizing issues

B. User I/O waits

C. I/O capacity limits

D. Top SQL statements

E. Excessive checkpoint writes

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

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

出題：2

Examine this code block, which executes successfully:
DBMS_SERVER_ALERT. SET_THRESHOLD (
DBMS_SERVER_ALERT.CPU_TIME_PER_CALL, DBMS_SERVER_ALERT. OPERATOR_GE, '8000', DBMS_SERVER_ALERT.OPERATOR_GE, '10000', 1, 2, 'inst1', DBMS_SERVER_ALERT.OBJECT_TYPE_SERVICE, 'main.regress.rdbms.dev.us.example.com') ;

What will happen?

A. A warning alert will be issued when CPU time exceeds 1 minute for each user call.

B. A critical alert will be issued when CPU time exceeds 10000 microseconds for each user call.

C. A critical alert will be issued when CPU time exceeds 2 minutes for each user call.

D. A warning alert will be issued only when CPU time exceeds 10000 microseconds for each user call.

正解：B 解答を投票する

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

出題：3

You use SQL Tuning Advisor to tune a given SQL statement.
The analysis eventually results in the implementation of a SQL Profile.
You then generate the new SQL Profile plan and enforce it using a SQL Plan Baseline but forget to disable the SQL Profile and a few days later you find out that the SQL Profile is generating a new execution plan.
Which two statements are true?

A. The existence of two concurrent plan stability methods generates a child cursor for every execution.

B. The conflict between the two plan stability methods results in an error.

C. The execution plan is the one enforced by the SQL Profile.

D. The SQL Profiles as well as SQL Plan Baseline are implemented using hints, so they both generate the same plan.

E. The execution plan is the one enforced by the SQL Plan Baseline.

F. The SQL Plan Baseline must be accepted in order to be used for the execution plan.

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

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

出題：4

You must produce a consolidated formatted trace file by combining all trace files generated by all clients for a single service.
Which combination of utilities does this?

A. Autotrace and TKPROF

B. TKPROF and Trace Analyzer

C. Trace Analyzer and Tracsess

D. Trcsess and TKPROF

正解：D 解答を投票する

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

出題：5

Which two statements are true about session wait information contained in v$session or v$session_wait?

A. Rows for sessions that are currently waiting have a wait time of 0.

B. Rows for sessions displaying WAITED UNKNOWN TIME in the STATE column indicate that the session is still waiting.

C. Rows for sessions that are not waiting always contain the total wait time since the session started.

D. Rows for sessions that are not waiting might contain the actual wait time for the last event for which they waited.

E. Rows for sessions that are currently waiting have their wait time incremented every microsecond.

正解：A,D 解答を投票する

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

出題：6

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. Partition index IX_SALES_TIME_ID using hash partitioning.

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. Re-create index IX_SALES_TIME_ID using ADVANCED COMPRESSION.

正解：D 解答を投票する

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

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