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

A. AUTO_STATSparameter set to TRUE

B. STATISTICS_LEVELparameter set to BASIC.

C. TIMED_STATISTICSparameter set to true

D. STATISTICS_LEVEL parameter set to TYPICAL

E. STATISTICS_LEVELparameter set to All

F. ALL_TIMED_STATISTICSparameter set to TRUE

A. An HR Team claims that it can hire staff fast enough to meet business demands.

B. To prepare for an upcoming code audit, developers need to review their SQL and PL/SQL code for syntaxand runtime errors.

C. After migration off a legacy system, an ERP team complains that they have no ability to isolate performanceproblems in the new distributed Oracle Database architecture.

D. Systems and Storage teams report that over the past 12 month, it is taking 40% longer time to back up theservers with Oracle databaseson them.

E. Development Team members demand that their SQL should run fast while the DBAs blame SQL as theroot of performance issues.

A. Oracle Diagnostic and Tuning Pack for Oracle Database

B. Oracle Real User Experience Insight

C. Oracle Real Application Clusters

D. Oracle Application Testing Suite

E. Oracle Exadata

A. Oracle Migration Pack for Databases

B. Oracle Migration Performance Advisor

C. SQL Performance Testing Suite

D. Real Application Testing

E. Oracle Diagnostic Pack for Database

A. Active Workload History to collect SQL at the time of its execution.

B. SQL Performance Analyzer to capture the information in the SGA, the sessions active, and analyze theSQL executing.

C. Oracle Exadata, as it already includes Diagnostic Pack for Oracle Database.

D. Oracle Workload Advisor that automatically turns on and captures the offending SQL Statements whenthresholds are reached.

E. Active Session History to capture sessions and dump the SQL executing, performance attributes andrelevant information into a buffer for analysis.

F. Active SQL History Analyzer to doperform a comparison of SQL statements before and after.

A. Utilize the Oracle Database Performance Method to help identify and correct issue.

B. Turnoff RAC interconnects to isolate any network issues impacting database performance problems.

C. Use the application load testing utility to overload a copy of their application in development to flush out theissue.

D. Run the V$RAC script to dump all the RAC statistics and look for what has the highest metric accumulation.

E. Use a third-party RAC tool to identify the bad SQL and then rewrite it.

A. Compare database performance between two periods of time, and resolve performance degradation thatmay happen from one time period to another.

B. Analyze transient performance problems that have happened in the database since it has been started.

C. Analyze transient performance problems with the database that are short-lived and do not appear in theADDM analysis.

D. Optimize the performance of data access paths by creating the proper set of materialized views,materialized view logs, and indexes for a given workload.

A. MMNL

B. DBWR

C. CKPT

D. LGWR

E. MMON

A. Database Smart Flash Cache

B. Oracle In-Memory DBSTATS Cache

C. Oracle In-Memory Database Cache

D. Mega Cache

E. Result Cache