最新的Oracle Database Performance and Tuning Essentials 2015 - 1z1-417免費考試真題

A. lock out user sessions and gather system statistics overnight

B. gather system statistics for several hours when there is no workload

C. gather system statistics for several hours during normal workload periods

D. gather system statistics after a performance issue has been reported

E. shut down any running applications prior to collection

A. the most extensive and up-to-date collection of database monitoring and tuning scripts

B. automated database diagnostics based on deep database kernel integration

C. monitor and alert on every Oracle Database Database Dictionary view using SNMP MIBS built into theOptimizer

D. a performance methodology

E. built-in instrumentation, real-time and historical monitoring, and data collection

F. a library of hundreds of PL/SQL procedures to choose from for writing scripts to instrument the database tocollect performance information

A. ASH data is available 24 hoursbecause AWR snapshots refresh every night.

B. As ASH data is flushed every 60 seconds, you need to set up a snapshot withDBA_JOBSfor what you want to keep.

C. 60 minutes of ASH data can be held in memory, but more than 1 hour can be reported.

D. 60 minutes of ASH data can be held in memory, so only 1 hour can be reported.

A. Result Cache

B. Mega Cache

C. Database Smart Flash Cache

D. Oracle In-Memory Database Cache

E. Oracle In-Memory DBSTATS Cache

A. generating a list of SQL Hints that the Optimizer will use to improve overall performance

B. measuring performance and comparing to industry benchmarks (TPC-C, TPC-D)

C. measuring performance before and after the change

D. identifying the SQL statements that regressed or improved

E. providing tuning recommendations for each SQL statement that is regressed

F. measuring a change in user session logins

A. User privileges statistics

B. Session and System statistics

C. Standby Database throughput statistics

D. Interconnect statistics

E. Wait Event statistics

A. LGWR

B. CKPT

C. DBWR

D. MMNL

E. MMON

A. real-time and historical monitoring capabilities

B. statspack integration and support

C. SQL script code management capabilities

D. included scripts for querying X$ and V$ views

E. non-intrusive metric collections

F. integration with Enterprise Manager

A. ASH is always on, SQL Trace/TKPROF is not

B. ASH provides detailed session level data, SQL Trace/TKPROF does not

C. ASH identifies Bind variables that are available, SQL Trace/TKPROF does not

D. ASH counts and has occurrence data, SQL Trace/TKPROF does not

E. ASH provides time based data, SQL Trace/TKPROF does not