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

出題：1

A Standard Edition production database has performance problems for two hours on the same day each week.
Which tool must you use to diagnose the problem?

A. Statspack report

B. SQL Performance Analyzer

C. Database Replay

D. AWR Compare Periods report

正解：A 解答を投票する

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

出題：2

You need to collect and aggregate statistics for the ACCTG service and PAYROLL module, and execute:

Where do you find the output of this command?

A. By viewing V$SERVICE_STATS

B. By viewing V$SERV_MOD_ACT_STATS

C. In $ORACLE_BASE/diag/rdbms/<db unique name>/<instance name>/trace

D. In the current working directory

正解：B 解答を投票する

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

出題：3

Which three statements are true about tuning dimensions and details of v$sys_time_model and DB time?

A. Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time. When CPU time is high, SQL tuning may improve performance.

B. Parse Time Elapsed accounts for successful soft and hard parse operations only.

C. DB Time accounts for all time used by background processes and user sessions.

D. The proportion of WAIT TIME to CPU TIME always increases with increased system load.

E. Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.

F. When WAIT TIME is high, instance tuning may improve performance.

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

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

出題：4

Examine this statement and its corresponding execution plan:

Which phase introduces the CONCATENATION step?

A. SQL Row Source Generation

B. SQL Execution

C. SQL Transformation

D. SQL Semantic Check

E. SQL Adaptive Execution

正解：C 解答を投票する

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

出題：5

Buffer cache access is too frequent when querying the SALES table. Examine this command which executes successfully:
ALTER TABLE SALES SHRINK SPACE;
For which access method does query performance on sales improve?

A. index range scan

B. index full scan

C. db file sequential read

D. db file scattered read

正解：C 解答を投票する

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

出題：6

You must write a statement that returns the ten most recent sales. Examine this statement:

Users complain that the query executes too slowly. Examine the statement's current execution plan:

What must you do to reduce the execution time and why?

A. Collect a new set of statistics on PRODUCT, CUSTOMERS, and SALES because the current stats are inaccurate.

B. Create an index on SALES.TIME_ID to force the return of rows in the order specified by the ORDER BY clause.

C. Create an index on SALES.CUST_ID to force an INDEX RANGE SCAN on this index followed by a NESTED LOOP join between CUSTOMERS and SALES.

D. Enable Adaptive Plans so that Oracle can change the Join method as well as the Join order for this query.

E. Replace the FETCH FIRST clause with ROWNUM to enable the use of an index on SALES.

正解：B 解答を投票する

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

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