Oracle Database Performance and Tuning Essentials 2015 - 1z1-417 Exam Practice Test

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

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

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

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

A. Flashback queries

B. XA transactions

C. SQL-based object access

D. Oracle Call Interface (OCI) based object navigations

E. Database Resident Connection Pooling (DRCP)

A. SQL Query Sets (SQS)

B. Database Replay

C. SQL Performance Analyzer (SPA)

D. Real Application Cluster Replay

E. SQL Tuning Analyzer

A. SQLHints

B. SQL Plan Management

C. Stored Profiles

D. SQL Profiles

E. Stored Outlines

A. a parallelized SQL statement

B. any SQL statement run

C. any DDL statement

D. a statement that consumes at least 5 second of CPU or I/O time.

E. a statement that consumes at least 1 second of CPU or I/O time.

F. any DML statement

A. It is the most inexpensive tool in the market.

B. It has the largest library of custom scripts and procedures and includes an assembly builder to maintainthem and add more.

C. It is a part of the database, which means no added installations, configurations, extra user accounts,privilege granting, etc.

D. Results come from the Oracle Database Optimizer and not rules or heuristics trying to predict what theoptimizer may do.

E. It eliminates the need to reverify compatibility, upgrade third-party tools, or rewrite scripts after a patch ordatabase upgrade.

A. View health status and performance of an Oracle Database instance via Database Control.

B. View only historical Oracle Database performance information.

C. Consolidate ADDM, AWR, and ASH repositories within an enterprise and enable centralized performancereporting.

D. View real-time and historical Oracle Database performance information.

E. Launch and view STATSPACK reports.

F. View only real-time Oracle Database performance information.

A. Automatic Database Diagnostic Monitor

B. SQL Tuning Set

C. Automatic Workload Repository

D. SQL Tuning Advisor

A. STATSPACK

B. Oracle SQL Developer

C. Oracle Performance Pack for Oracle Database

D. Oracle Diagnostics Pack for Oracle Database

E. Oracle Real Application Testing

F. Oracle Tuning Pack for Oracle Database

G. SQL Tuning Pack for Oracle Database