Oracle Database Performance and Tuning Essentials 2015 - 1z1-417 Free Exam Questions

A. SQLHints

B. Stored Outlines

C. SQL Plan Management

D. Stored Profiles

E. SQL Profiles

A. Statistics are collected during automatic maintenance tasks.

B. Any external tables are incorporated.

C. Statistics are gathered after table statistics are marked stale.

D. All tables in the data dictionary are included by defaults.

E. Any fixed objects are disregarded.

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

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

C. shut down any running applications prior to collection

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

E. lock out user sessions and gather system statistics overnight

A. Disable Oracle Enterprise Manager Database Express by setting the HTTP Port to 0.

B. Enable SNMP and configure MIBS on each databaseand forward database monitoring SNMP traps.

C. Changes permissions of the "express" directory to real only by root.

D. Using the appropriate architectureimplement Oracle Enterprise Manager.

E. For the always active Oracle Enterprise Manager Database Express process, create a script that willdisable that process upon database boot.

F. Delete the "express" directory in Oracle Home to disable Oracle Enterprise Manager Database Express.

A. It enables you to conduct performance analysis of transient issues.

B. It enables you to conduct performance analysis of long-running sessions.

C. It accesses database kernel structures indirectly via the buffer cache.

D. It enables you to look at all database sessions since the database was created.

E. In memory, active sessions are sampled every second.

A. integration with Enterprise Manager

B. SQL script code management capabilities

C. statspack integration and support

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

E. non-intrusive metric collections

F. real-time and historical monitoring capabilities

A. a performance methodology

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

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

D. automated database diagnostics based on deep database kernel integration

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

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

A. PARTIAL

B. CLUSTER

C. INSTANCE

D. DATABASE

E. ALL

F. FULL

A. to review space usage of individual schema objects or tablespaces

B. to identify any fragmentation in the database cache or swap space

C. to determine if objects have unusedspace that can be released

D. to advise if materialized views can be used to reduce size of views

E. to advise if there are any duplicate indexes and automate their removal