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

A. Active SQL History Analyzer to doperform a comparison of SQL statements before and after. B. Oracle Exadata, as it already includes Diagnostic Pack for Oracle Database. C. Oracle Workload Advisor that automatically turns on and captures the offending SQL Statements whenthresholds are reached. D. Active Session History to capture sessions and dump the SQL executing, performance attributes andrelevant information into a buffer for analysis. E. SQL Performance Analyzer to capture the information in the SGA, the sessions active, and analyze theSQL executing. F. Active Workload History to collect SQL at the time of its execution.

A. View real-time and historical Oracle Database performance information. B. Consolidate ADDM, AWR, and ASH repositories within an enterprise and enable centralized performancereporting. C. View health status and performance of an Oracle Database instance via Database Control. D. View only real-time Oracle Database performance information. E. View only historical Oracle Database performance information. F. Launch and view STATSPACK reports.

A. Inefficient "Bad" application SQL can be detected by Diagnostics Pack and then optimized utilizing TuningPack SQL Profiles, even if it can't be changed at the application end. B. Diagnostics and Tuning Packs are needed to keepOracle Database table and index statistics current. C. With Diagnostics and Tuning Packs installed, an Oracle database recovers easily from a crash orcorruption. D. Diagnostics and Tuning packs are a prerequisite for a customer to license Oracle Database EnterpriseEdition. E. Oracle Databases are constantly changing; more users, data added and deleted, varying SQL atapplication level.

A. doesn't develop an execution plan, but uses enabled plans in the baseline B. compares plans that itdevelops with accepted plans in baselines C. develops plans and adds them to baselines as verified D. doesn't develop an execution plan, but uses an accepted plan from baselines

A. It builds on capabilities built into Oracle databases. B. It is available for Oracle Database Standard and Enterprise Editions. C. It is applicable for Oracle Database 12c and later versions. D. It is recommended for Production environments, but not for Development or QA. E. It is delivered with Oracle Engineered Systems.

A. The listener needs to be running for it to be accessed. B. Oracle Enterprise Manager Database Control must be configured first. C. A Oracle Enterprise Manager Database Express WebLogic Server must be configured first. D. Oracle Enterprise Manager Database Express can be used only from a command-line. E. Oracle Internet Application Server needs to be installed to use it.

A. Implement primary and foreign keys, enforce database integrity, joins, message queuing, maintenance ofsequencesoutside of the database. B. Perform testing with Real Application Testing. C. Maintain and analyze performance statistics using AWR and ADDM. D. Eliminate hot spots in applications, monitor, measure, and optimize SQL statement execution. E. Use Big Data to hold everything into one big table.

A. APEX is required to access ADDM. B. ADDM and AWR are new features of Oracle Database 12c. C. ADDM analyzes information in RMAN. D. ADDM analyzes information stored in snapshots in tables of the Automatic Workload Repository (AWR). E. Automatic Workload Repository (AWR) analyzes information stored in snapshots in tables of ADDM.

A. Persistent B. Unlimited C. Basic D. Full E. Temporary