最新的Oracle 1Z0-084免費考試真題

問題1

Which two Oracle Database features use database services?

A. Oracle Automatic Reoptimization

B. Oracle SQL Performance Management

C. Oracle SQL Tuning Advisor

D. Oracle Scheduler

E. Database Resource Manager

正確答案: D,E

說明：（僅 Fast2test 成員可見）

問題2

You want to reduce the amount of db file scattered read that is generated in the database. You execute the SQL Tuning Advisor against the relevant workload. Which two can be part of the expected result?

A. recommendations regarding the creation of SQL Patches

B. recommendations regarding rewriting the SQL statements

C. recommendations regarding the creation of additional indexes

D. recommendations regarding partitioning the tables

E. recommendations regarding the creation of materialized views

正確答案: B,C

說明：（僅 Fast2test 成員可見）

問題3

What is the right time to stop tuning an Oracle database?

A. When the allocated budget for performance tuning has been exhausted

B. When the I/O is less than 10% of the DB time

C. When the buffer cache and library cache hit ratio is above 95%

D. When the tuning goal has been met

E. When all the concurrency waits are eliminated from the Top 10

正確答案: D

說明：（僅 Fast2test 成員可見）

問題4

18. The application provider has given full indications regarding the procedure to collect statistics.
To reduce the space used in the SYSAUX tablespace, you want to prevent the optimizer statistics Advisor from running.
Which method will allow you to do this?

A. Use DBMS_AUTO_TASK_ADMIN. DISABLE to disable the AUTO_STATS_ADVISOR_TASK task.

B. Set the parameter OPTIMIZER_ADAPTIVE_STATISTICS to FALSE.

C. Use DBMS STATS.DROP ADVISOR TASK to drop the AUTO_STATS_ADVISOR_TASK task.

D. Set the AUTO_STATS_ADVISOR_TASK global statistics preference to FALSE.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題5

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. In the current working directory

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

C. By viewing V$SERV_MOD_ACT_STATS

D. By viewing V$SERVICE_STATS

正確答案: C

說明：（僅 Fast2test 成員可見）

問題6

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. TKPROF and Trace Analyzer

B. Trcsess and TKPROF

C. Autotrace and TKPROF

D. Trace Analyzer and Tracsess

正確答案: B

說明：（僅 Fast2test 成員可見）

最新的Oracle Database 19c Performance and Tuning Management - 1Z0-084免費考試真題

聯系我們

站內鏈接

最新更新