Online Access Free 1z1-417 Practice Test

Which functionality should be used to recommend materialized views and view logs, indexes, SQL profiles,and partitions for a specific workload use?

• A.Top SQL
• B.SQL Performance Analyzer
• C.SQL Access Advisor
• D.SQL Tuning Advisor
• E.Workload Advisor

In which two formats does Automatic Workload Repository (AWR) provide statistics?

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

You need to load SQL statements from a time period of optimal performance to compare against a time period that performance was reported as poor. Which functionality would you use to accomplish that task?

• A.SQL Tuning Sets
• B.Optimizer Statistics Comparator
• C.Dynamic Baseline Advisor
• D.Database Replay
• E.Automatic Workload Repository Baselines

Select two scenarios that an Oracle Database Performance and Tuning solution implementation addresses.

• A.An HR Team claims that it can hire staff fast enough to meet business demands.
• B.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.
• C.To prepare for an upcoming code audit, developers need to review their SQL and PL/SQL code for syntaxand runtime errors.
• 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.

To isolate performance problem in an Oracle real Application Cluster, for which two abilities would you implement Oracle Diagnostics Pack for Oracle Databases?

• A.ADDM X$ and V$ performance analysis and reports that compare the overall RAC Database to the sum ofits individual database instances.
• B.ADDM recommendations inclusive of SAN and NFS mounted storage to pinpoint issues within the storagecache.
• C.Database-wide analysis of global resources by ADDM for high-load SQL, global cache interconnect traffic,and skew in instance response times.
• D.Cluster-wide performance analysis and reports with ADDM on issues that affect an entire databaseas wellas its individual instances.
• E.ADDM's ability to review SNMP trap error messages and automatically open trouble tickets.