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

出題：1

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 メンバーにのみ表示されます)

出題：2

Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

A. Compress the SALES table.

B. Increase PCTFREE for the SALES table.

C. Re-create the SALES table.

D. Partition the SALES table.

E. Coalesce all sales table indexes.

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

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

出題：3

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 メンバーにのみ表示されます)

出題：4

Which three statements are true about server-generated alerts?

A. Their threshold settings can be modified by using DBMS_SERVER_ALERT.

B. They may contain suggestions for correcting the identified problems.

C. They provide notifications but never any suggestions for correcting the identified problems.

D. They can be viewed only from the Cloud Control Database home page.

E. They are logged in the alert log.

F. They are notifications from the Oracle Database Server of an existing or impending problem.

正解：B,E,F 解答を投票する

解説: (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

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

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

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

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

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

正解：B 解答を投票する

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

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