2018 Jan Oracle Official New Released 1z0-417
100% Free Download! 100% Pass Guaranteed!

Database Performance and Tuning Essentials 2015

Question No: 11

SQL Access Advisor takes database workload as input and recommends adding various access structures. Which three does it consider the impact of adding when it generates recommendations?

  1. Materialized views

  2. Indexes

  3. Partitions

  4. Tablespaces

  5. V$ performance views

  6. Hints

Answer: B,D,E

Question No: 12

Which three are benefits of implementing an Oracle Database Performance and Tuning solution?

  1. automated database diagnostics based on deep database kernel integration

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

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

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

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

  6. a performance methodology

Answer: D,E,F

Question No: 13

What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?

  1. You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.

  2. After a SQL Profile is created, it will then run efficiently for the life of the database.

  3. The SQL Profile rewrites the SQL Statement issued by theapplication so it appears to the Optimizer as aperfectly written SQL statement.

  4. You can have only one SQL Profile active at one time for a single SQL statement.

  5. You need Oracle Database 12c or later to use SQL Profiles.

  6. SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack islicensed.

Answer: A,E

Question No: 14

Which three are SQL Performance Analyzer capabilities that enable forecasting impact of system changes on a SQL workload?

  1. measuring performance before and after the change

  2. generating a list of SQL Hints that the Optimizer will use to improve overall performance

  3. identifying the SQL statements that regressed or improved

  4. providing tuning recommendations for each SQL statement that is regressed

  5. measuring performance and comparing to industry benchmarks (TPC-C, TPC-D)

  6. measuring a change in user session logins

Answer: A,C,E

Question No: 15

For which one would you use an index fast full scan to improve performance?

  1. a query having all the columns of an index in the where clause

  2. a query that does not need to access table rows

  3. a query that needs to access table rows along with an index

  4. a column in an index that is compressed

Answer: A Explanation:

All of the columns required by SQL must reside in the index tree; that is, all columns in the SELECT and WHERE clauses must exist in the index.


Question No: 16

The IT team said that a system appeared OK based on their third-party network and systems management tool; yet customers continue to complain of database performance- related issues. Which two would you implement to find and fix the problem?

  1. Oracle Real User Experience Insight

  2. Oracle Application Testing Suite

  3. Oracle Exadata

  4. Oracle Real Application Clusters

  5. Oracle Diagnostic and Tuning Pack for Oracle Database

Answer: D,E

Question No: 17

Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?

  1. ASH provides time based data, SQL Trace/TKPROF does not

  2. ASH provides detailed session level data, SQL Trace/TKPROF does not

  3. ASH is always on, SQL Trace/TKPROF is not

  4. ASH identifies Bind variables that are available, SQL Trace/TKPROF does not

  5. ASH counts and has occurrence data, SQL Trace/TKPROF does not

Answer: B

Question No: 18

A customer not familiar with Active Session History (ASH) asked you what it was used for. Which are two statements you can use to accurately describe (ASH) capabilities?

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

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

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

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

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

Answer: A,C


Question No: 19

When reviewing a customer#39;s database configuration, you find thatOPTIMIZER_USE_SQL_PLAN_BASELINESis set asTRUE. What does the Optimizer do?

  1. compares plans that itdevelops with accepted plans in baselines

  2. develops plans and adds them to baselines as verified

  3. doesn#39;t develop an execution plan, but uses an accepted plan from baselines

  4. doesn#39;t develop an execution plan, but uses enabled plans in the baseline

Answer: B

Question No: 20

At the IT Manager request, you are reviewing the databases that the DBA has implemented. You findSTATISTICS_LEVELconfigured asBASIC. What finding do you report back to the IT Manager?

  1. The configuration of their databases is set up to also provide timed Operating System statistics and planexecution statistics.

  2. The configuration of their databases is incorrect and should be set toNOT_TYPICAL.

  3. The configuration of their databases has disabled collection of important statistics required for OracleDatabase functionality.

  4. The configuration of their databases needs to be set toALLto enable collection of Operating System, Middleware, and storage statistics.

Answer: C

100% Free Download!
Download Free Demo:1z0-417 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-417 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE

Comments are closed.