[Free] 2018(Jan) EnsurePass Pass4sure Oracle 1z0-054 Dumps with VCE and PDF 81-90

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-054
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-054.html

Oracle Database 11g: Performance Tuning

Question No: 81

You are working on an online transaction processing (OLTP) system. You detected free buffer waits events for your database instance running in a machine that has multiple CPUs. You increased the database buffer cache size as the first step. After a few hours of work on the database, further investigation shows that the same event is being recorded. What would be your next step to avoid this event in future?

  1. Decrease the value of the DBWR_IO_SLAVES parameter.

  2. Set the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.

  3. Increase the value of the DB_WRITER_PROCESSES parameter.

  4. Increase the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.

Answer: C

Question No: 82

Which is the correct description of SQL profiling while using SQL Tuning Advisor?

  1. It is a set of recommendations by the optimizer to create new indexes.

  2. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

  3. It is a set of recommendations by the optimizer to refresh stale statistics to avoid bad execution plan.

  4. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid bad execution plan.

Answer: B

Question No: 83

The SALES table in your database undergoes frequent changes. While observing the statistics for the table in the middle of the day, you find a change since the last observation. But the information about the statistics collection is not recorded in the DBA_TAB_STATS_HISTORY. Identify the reason for this.

  1. The AWR retention time was set to zero.

  2. The STATISTICS_LEVEL parameter was set to BASIC.

  3. Some of the statistics were collected using the ANALYZE command.

  4. There were user-defined statistics that were set by using the

DBMS_STATS.SET_TABLE_STATS procedure.

Answer: C

Question No: 84

What is the purpose of running the statspack.snap script during the installation of the Statspack package?

  1. It creates the initial baseline.

  2. It automates the collection of statistics.

  3. It stores the current performance statistics in the Statspack tables.

  4. It creates the PERFSTAT user, the Statspack tables, and constraints

Answer: C

Question No: 85

The OS administrator in your company informed you about the upgrade of storage to new disk controllers and hard disks. You want to test if the new I/O devices are capable of handling the I/O load. The database is using Automatic Storage Management(ASM) for storage. To test the throughput and other I/O metrics, you performed IO calibration from the Enterprise Manager but you notice that the IO calibration job failed.

To see the details of the error, view the Exhibit.

Ensurepass 2018 PDF and VCE

How you can resolve the error?

  1. Set FILESYSTEMIO_OPTIONS to NONE and DISK_ASYNCH_IO to FALSE.

  2. Set FILESYSTEMIO_OPTIONS to SYNCH and DISK_ASYNCH_IO to FALSE.

  3. Set FILESYSTEMIO_OPTIONS to ASYNCH and DISK_ASYNCH_IO to TRUE.

  4. Set FILESYSTEMIO_OPTIONS to DIRECTIO and DISK_ASYNCH_IO

Answer: C

Question No: 86

You used SQL Tuning Advisor for a long-running SQL statement that suggested a SQL profile which can be used by the query subsequently for better execution plan. View the Exhibit. But youwant certain user sessions not to use this SQL profile for their queries. How would you implement this?

Ensurepass 2018 PDF and VCE

  1. Alter the SQL profile to change the category of the SQL profile.

  2. Set the OPTIMIZER_USE_PENDING_STATISTICS to TRUE the desired sessions.

  3. Use database resource manager to prevent the use of the SQL profile by these user sessions.

  4. Use database resource manager to preUse the resource management feature in profiles of these users to prevent the use of the SQL profile.

Answer: A

Question No: 87

Your system is upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After running the SQL Performance Analyzer for optimizer version change, you observe performance regression for a few SQL statements. What would you suggest to avoid performance regression for these SQL statements?

  1. Include the old plans in the SQL plan baseline.

  2. Use DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE to evolve plans.

  3. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE.

  4. Increase the value for the OPTIMIZER_DYNAMIC_SAMPLING parameter.

Answer: A

Question No: 88

View the Exhibit that shows your investigation of performance degradation in your database.You also know that there are a few tablespaces using automatic segment-space management in the database.What could be the problem?

Ensurepass 2018 PDF and VCE

  1. There are excessive disk sorts.

  2. There are excessive memory sorts.

  3. There is a contention due to free list management.

  4. The tablespace that contains the segments on which waits are occurring is full.

  5. The server process is processing buffers at a rate that is faster than the rate at which the I/O system can return the buffers.

Answer: C

Question No: 89

You analyze an Automatic Database Diagnostic Monitor (ADDM) report to identify the component that contributes most to the database time. Which is the correct description of database time?

  1. It is the sum of the CPU time of all nonidle sessions.

  2. It is the sum of wait time and the CPU time of all nonidle sessions.

  3. It is the time spent in processing the input/output (I/O) request by users.

  4. It is the difference between the wait time and the CPU time of all nonidle sessions.

Answer: B

Question No: 90

You upgraded database from the Oracle Database 10g to Oracle Database 11g. To test theperformance SQL on the upgraded database. You want to build the before-change performance data by using SQL Performance Analyzer .Which method would allow the task to execute quickly?

  1. the EXPLAIN PLAN method

  2. the TEST EXECUTE method

  3. the COMPARE PERFORMANCE method

  4. the OPTIMIZER_USE_SQL_PLAN_BASELINE parameter set to TRUE

    Answer: A

    100% Ensurepass Free Download!
    Download Free Demo:1z0-054 Demo PDF
    100% Ensurepass Free Guaranteed!
    1z0-054 Dumps

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.