[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-054 Dumps with VCE and PDF 71-80

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

Oracle Database 11g: Performance Tuning

Question No: 71

You are working as a DBA in ABC Corp. You are working on online transaction processing (OLTP) system. The database uses ASM storage. One of the ASM disk goes offline because of hardware failure. When the disk is added back again after the fix, because the database is active, rebalance operations impact the I/O subsystem.Which two recommendations would you give to lower the impact on the I/O subsystem? (Choose two.)

  1. Increase the number of ASMB processes.

  2. Increase the number of DBWR_IO_SLAVES.

  3. Decrease the value for the ASM_POWER_LIMIT parameter.

  4. Increase the value for the ASM_POWER_LIMIT parameter.

  5. Set the DISK_REPAIR_TIME disk attribute to a lower value.

  6. Specify the POWER clause with a lower value in an ALTER DISKGROUP statement.

Answer: C,F

Question No: 72

View the Exhibit and examine the content.

Ensurepass 2018 PDF and VCE

ALLOCATED_SPACE and FREE_SPACE indicate that a large amount of space is allocated to the temporary tablespace that is being used.Which action would reclaim the space and refresh these values?

  1. shrinking the tablespace

  2. closing all the current sessions

  3. restarting the database instance

  4. forcing a checkpoint or waiting for a checkpoint to occur

Answer: A

Question No: 73

View the Exhibit and examine the details of the Top 5 Timed Events from an Automatic

Workload Repository (AWR) report.What can be the three possible causes for the latch- related wait events? (Choose three.)

Ensurepass 2018 PDF and VCE

  1. Shared pool size is too small.

  2. Cursors are not being shared.

  3. There are frequent logons/logoffs.

  4. A large number of COMMITs are being performed.

  5. A large number of data definition language (DDL) and query statements are being executed simultaneously by different sessions.

Answer: A,B,C

Question No: 74

You work as a DBA and have the responsibility of managing a large online transaction processing (OLTP) system. You used the following query during the performance tuning activity:

SQLgt; SELECT (1-((phy.value-phyd.value) / (cur.value con.value))) * 100 2 quot;Cache Hit ratioquot;

3 FROM v$sysstat cur, v$sysstat con, v$sysstat phy, v$sysstat phyd 4 WHERE cur.name = #39;db block gets#39;

5 AND con.name = #39;consistent gets#39; 6 AND phy.name = #39;physical reads#39;

7 AND phyd.name = #39;physical reads direct#39;; Cache Hit Ratio

——– 98.43

What can you conclude based on this ratio?

  1. The database performance is very good because of reduced logical I/Os.

  2. The database performance cannot be determined based only on this ratio.

  3. Good database performance is guaranteed because very few physical I/Os are performed.

  4. The database performance is very good because most of the requested data blocks are found in the buffer cache.

Answer: B

Question No: 75

You observed that some of the queries are performing poorly on the SALES_RECORDS table in your database.

On further investigation, you find that at the end of each day the contents of the SALES_RECORDS table are transferred to the SALES table and deleted from the SALES_RECORDS table. The deleted operations cause the table to be sparsely populated.

The SALES_RECORDS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24×7 mode.

What is the most efficient method to improve the performance?

  1. Perform EXPORT, DROP, and IMPORT operations on the SALES_RECORDS table sequentially.

  2. Shrink the SALES_RECORDS table by using the ALTER TABLE…SHRINK SPACE command.

  3. Move the SALES_RECORDS table to a different location by using the ALTER TABLE…MOVE command.

  4. Deallocate the space in the SALES_RECORDS table by using the ALTER TABLE…DEALLOCATE UNUSED command.

Answer: B

Question No: 76

Examine the following query and its output:

SQLgt;SELECT namespace, gets, gethits, gethitratio, pins, pinhits, reloads,invalidations

FROM v$librarycache

WHERE namespace = #39;SQL AREA#39;;


—– — —- —— — —- —- ——- SQL AREA 11942 2832 .237146207 65900 62486 28 118

Which two observations are correct? (Choose two.)

  1. About 24% of the parse calls were able to find a cursor to share.

  2. DML locks were requested 65,900 times for objects in the SQL AREA.

  3. Library cache misses happened 118 times because invalidations occurred due to DDL on the dependant objects.

  4. Reparsing of SQL statements before they had finished executing happened 28 times due to modification of a dependent object.

Answer: A,C

Question No: 77

You are working on a decision support system (DSS). The index is available on the COUNTRY_ID column of the CUSTOMERS table.View the Exhibit and examine the parameter settings and the query execution plan.

Ensurepass 2018 PDF and VCE

Why is the query using a full table scan instead of an index scan?

  1. because the histogram statistics for the COUNTRY_ID column are not updated

  2. because the index statistics for the index on the COUNTRY_ID column are not current

  3. because the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a higher value

  4. because the optimizer predicts that most of the blocks in the table are accessed. Therefore, it uses a full table scan, even though indexes are available.

Answer: D

Question No: 78

You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP) system.The applications running on the database use connection pooling to connect to the database to perform transactions.

The company wants to upgrade the CPU and the memory for the machine on which the production database is running. To test the realistic workload on the new machine with increased CPU and memory, you identified the peak workload time for the database and captured the workload on the production system. You set up the test machine with the upgraded CPU and memory, and performed the following operations for replay:

  1. You preprocessed the captured workload.

  2. You restored the replay database to match the capture database at the start of the workload capture.

  3. You resolved all external references.

  4. You set up replay clients.

You have the following replay considerations:

  1. load testing to be performed

  2. all the sessions to connect immediately

  3. user waits between issuing calls to be kept to a minimum What replay options would you choose to accomplish the replay?








Answer: A

Question No: 79

There are 500 users of an online transaction processing (OLTP) application that resides in your database. The system had been maintaining an average response rate of 10 seconds as specified by the Service-Level Agreement (SLA).This morning you were informed that for the past four days the average response time has gone up to 15-20 seconds. No changes have been made to the hardware or networking setup.What is the first thing that you should do to diagnose the cause of the slow response time?

  1. Determine whether it is a memory configuration issue.

  2. Determine whether the slow response is wait bound or CPU bound.

  3. Determine whether the application is performing excessive I/O due to poor access path choice.

  4. Determine whether new tablespaces have been created on the disks that are being used by the existing tablespaces.

Answer: B

Question No: 80

View the Exhibit and examine the sample Automatic Database Diagnostic Monitor (ADDM) report.Which statement is true about the report?

Ensurepass 2018 PDF and VCE

  1. The sum of impacts under recommendations in Finding 2 cannot exceed 100%.

  2. It is possible that the sum of impacts under recommendations in Finding 2 can exceed 100%.

  3. The recommendations regarding quot;buffer busyquot; wait cannot appear more than once in the report.

  4. The sum of impacts of recommendation 2 in Finding 1 and recommendation 2 in Finding 2 cannot exceed 100%.

Answer: B

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

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

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


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