최신Oracle Database Performance and Tuning Essentials 2015 - 1z1-417무료샘플문제

A. ADDM's ability to review SNMP trap error messages and automatically open trouble tickets.

B. ADDM recommendations inclusive of SAN and NFS mounted storage to pinpoint issues within the storagecache.

C. Cluster-wide performance analysis and reports with ADDM on issues that affect an entire databaseas wellas its individual instances.

D. Database-wide analysis of global resources by ADDM for high-load SQL, global cache interconnect traffic,and skew in instance response times.

E. ADDM X$ and V$ performance analysis and reports that compare the overall RAC Database to the sum ofits individual database instances.

A. An invisible index is ignored by the optimizer.

B. I/O bottlenecks are easy to spot when invisible indexes are used.

C. After an index becomes invisible, it is no longer maintained during insertsand updates.

D. The session or system parameter needs to be changed toOPTIMIZER_USE_INVISIBLE_INDEXEStoTRUEfor an invisible index to become visible to the Optimizer.

E. An index only needs to be rebuilt for it to be visible again.

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

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

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

D. a performance methodology

E. automated database diagnostics based on deep database kernel integration

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

A. It uses internal infrastructure components, such as XDB and SQL*NET.

B. Performance Hub and Composite Active Reports are its key functionalities.

C. It is not supported on Oracle Standard Edition or Express Edition.

D. It can perform actions inside and outside the database.

E. It replaces Oracle Grid Control.

A. STATISTICS_LEVEL parameter set to TYPICAL

B. STATISTICS_LEVELparameter set to BASIC.

C. AUTO_STATSparameter set to TRUE

D. STATISTICS_LEVELparameter set to All

E. TIMED_STATISTICSparameter set to true

F. ALL_TIMED_STATISTICSparameter set to TRUE

A. Consolidation Planner

B. Enterprise Manager Cloud Control

C. Workload Consolidator and Playback

D. Automatic Workload Repository

E. Consolidated Database Replay

A. Oracle SQL Developer

B. Oracle Database Diagnostics Pack for Oracle Database

C. Oracle Real Application Testing

D. Oracle Database Replay and Testing Suite

E. Oracle Real Tuning Pack for Oracle Database

A. simulate Exadata on existing hardware

B. JSQL Heap Memory overflow testing

C. find and flashback explain plan anomalies

D. debug SQL code syntax before and after a change

E. forecast impact of a system change on aSQL workload

F. compare performance of SQL statements before and after a change

A. INSTANCE

B. ALL

C. PARTIAL

D. FULL

E. DATABASE

F. CLUSTER