[Free] 2018(Jan) EnsurePass Testking Oracle 1z0-054 Dumps with VCE and PDF 11-20

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

Oracle Database 11g: Performance Tuning

Question No: 11

View the Exhibit and analyze the output of a query executed on the V$MEMORY_RESIZE_OPS view. Why do INITIAL_SIZE, TARGET_SIZE, and

FINAL_SIZE columns have the value zero for some of the components?

Ensurepass 2018 PDF and VCE

  1. because they are the only components that are auto-tuned

  2. because they are the only components that are not auto-tuned

  3. because they are the only components that have not undergone any manual resizing

  4. because they are the only components that do not have a default size or their respective parameters are not set in the initialization parameter file

Answer: D

Question No: 12

You work as a consultant DBA for various clients. A performance issue in one of the online transaction processing (OLTP) systems is reported to you and you received the Automatic Workload Repository (AWR) report generated in the database. The main sections of the AWRreport is shown in the Exhibits.

View the Exhibit named DBTIME and note % DB Time.

Ensurepass 2018 PDF and VCE

View the Exhibit named TIMEMODEL and note what has contributed to % DB Time.

Ensurepass 2018 PDF and VCE

View the Exhibit named EFFICIENCY and examine the various percentages shown.

Ensurepass 2018 PDF and VCE

Which option describes the correct understanding of the main problem?

  1. The Exhibit DBTIME shows that the DB CPU event consumed very high % DB Time, which indicates that the CPU is very slow.

  2. sql execute elapsed time and parse time elapsed are consuming very high % DB Time in the TIMEMODEL Exhibit. This indicates too many soft parses.

  3. hard parse elapsed time has the majority time in parse time elapsed, which is shown in the TIMEMODEL Exhibit. This indicates inadequate database buffer cache.

  4. % Non-Parse CPU: and Soft Parse %: are low in the EFFICIENCY Exhibit, which shows that very few statements are found in the cache. This indicates that there were too many hard parses.

Answer: D

Question No: 13

You are working on an online transaction processing (OLTP) system. The middle-tier applications use connection pooling to connect to the database. Presently, you have a single-node database. The company plans to migrate the database to a RAC environment. Before you move to a RAC environment, you want to test the performance of the SQL statements and the peak workload on the new environment. To accomplish the Database Capture for replay, you identified the peak workload period on the existing system and started the Database Capture. Which client requests to the database can be captured as part of the workload capture? (Choose all that apply.)

  1. flashback query

  2. distributed transactions

  3. logging in and logging out of sessions

  4. all DDL statements having bind variables

  5. direct path load of data from external files

Answer: C,D

Question No: 14

View the Exhibit and examine the content of the V$MEMORY_RESIZE_OPS view.Which two conclusions can you draw? (Choose two.)

Ensurepass 2018 PDF and VCE

  1. Automatic Memory Management (AMM) is enabled.

  2. Automatic Shared Memory Management (ASMM) is enabled but not AMM.

  3. The Shared Pool grew in IMMEDIATE mode to avoid an out-of-memory error.

  4. The Default Buffer Cache grew in DEFERRED mode to avoid an out-of-memory error.

  5. The memory is transferred in IMMEDIATE mode only if there are entirely empty granules available in other components.

Answer: A,C

Question No: 15

You work as a DBA for a company and as a performance improvement measure, you implemented the result cache in your database. Many users in the company say that performance has improved on the queries they use, but some users complain that they have not got any performance benefiton the queries they use.

You checked all the queries they use and the following is one of them:

SQLgt; SELECT /* RESULT_CACHE */ slnoq.currval as quot;SLNOquot;, prod_id, pdname, 2 cust_name FROM sales WHERE sl_date lt; sysdate;

View the Exhibit and examine the testing performed to check this.

Ensurepass 2018 PDF and VCE

Why is the result cache not used? (Choose all that apply.)

  1. because the query uses SYSDATE

  2. because the query uses an alias for a column

  3. because the query uses the SLNOQ.CURRVAL sequence

  4. because the table might have an index on the SL_DATE column

Answer: A,C

Question No: 16

Identify the reason why chained or migrated rows in a table cause performance

degradation when you access them.

  1. because the ROWID changes for these rows

  2. because these rows make existing indexes invalid

  3. because it is not possible to use indexes to retrieve these rows

  4. because retrieving these rows requires more than one data block to be accessed

  5. because the rows force queries to use temporary segments while retrieving them

Answer: D

Question No: 17

Which three statements are true about performance analysis by SQL Performance Analyzer? (Choose three.)

  1. It detects changes in SQL execution plans.

  2. It shows only the overall impact on workload.

  3. It produces results that can be used to create the SQL plan baseline.

  4. It generates recommendations to run SQL Tuning Advisor to tune regressed SQL statements.

  5. The importance of SQL statements to be analyzed is based on the size of the objects accessed.

Answer: A,C,D

Question No: 18

During a proactive database performance monitoring routine, on examining the AWR report you find that log file sync appears among the top 5 wait events.What does this event indicate?

  1. Frequent logfile switches are occurring.

  2. Redo is generated faster than LGWR can write it out.

  3. Frequent commits or rollbacks are taking place in the application.

  4. Frequent incremental checkpoints are taking place in the database.

Answer: C

Question No: 19

You are asked to implement Automatic Memory Management (AMM) and you added two initialization parameters to do this. The following are the some of the parameter settings:


When you tried to start the database instance with these parameter settings, you received the following error:

SQLgt; startup

ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information

You modified the parameter settings as shown below and the database instance started successfully.


Analyze the parameter settings and identify why the instance failed to start the first time?

  1. because the STATISTICS_LEVEL parameter was set to BASIC

  2. because the PGA_AGGREGATE_TARGET parameter was set to zero

  3. because both the SGA_TARGET and MEMORY_TARGET parameters were set

  4. because MEMORY_TARGET and MEMORY_MAX_TARGET parameters were equal

  5. because the PROCESSES parameter was set to a value less than the minimum required

Answer: A

Question No: 20

The database application developers are planning to make some major schema changes such as creating new indexes and materialized views. They want to check the net impact of these changes on the workload performance. This activity has to be performed in the production database, so they want only the query part of the data manipulation language (DML) statements to be executed so that the side effects to the database or user data can be prevented. What should they use to achieve this?

  1. Database Replay

  2. SQL Tuning Advisor

  3. SQL Access Advisor

  4. SQL Performance Analyzer

Answer: D

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
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.