[Free] 2018(Jan) Latesttests Testking Oracle 1z0-054 Dumps with VCE and PDF Download 51-60

Latesttests 2018 Jan Oracle Official New Released 1z0-054
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-054.html

Oracle Database 11g: Performance Tuning

Question No: 51

You work as a DBA in ABC Corp. You are working on an online transaction processing (OLTP) database. The database size has grown to 100 GB. The database will support new applications and more users will be added. Presently, the database uses normal file system storage. Before the new applications are added, you want to move the storage to RAID. You are in consultation with the OS Administrator for finalizing the RAID option for the storage.

You have the following requirements for the database:

  1. Less mean time to recover (MTTR)

  2. Striped for performance

  3. Mirrored for safety

Which RAID option would you recommend?

  1. RAID level 0

  2. RAID level 1

  3. RAID level 0 over 1(1 0)

  4. RAID level 1 over 0(0 1)

Answer: C

Question No: 52

You work as a DBA and have the responsibility of managing a large online transaction processing (OLTP) system. You used three queries to check the database performance as

shown in the Exhibit.View the Exhibit and analyze the output.

Latesttests 2018 PDF and VCE

What conclusion can you draw from this?

  1. There are many physical I/Os happening.

  2. There are many full table scans happening.

  3. The data blocks are aging out of the buffer cache very fast.

  4. There are many cursors trying to access the same data blocks.

  5. The DBWn processes are not freeing sufficient buffers to meet the demand.

Answer: D

Question No: 53

Your company wants to migrate a single instance Oracle 11g Release 1 database to a RAC environment. The database supports middle-tier applications using connection pooling for connecting to database.

Being a part of the performance management team, you want to test the performance of the SQL statements and the peak workload of the applications in the new environment before upgrading the production system.

Given below are some of the steps in random order to accomplish the task:

  1. Capture the real workload on the existing system.

  2. Create a SQL Tuning Set (STS) for the statements executed by the application.

  3. Transport STS on the test environment and use SQL Tuning Advisor to compare the before and after performance.

  4. Replay the workload on the test environment.

  5. Analyze the divergence after replay.

  6. Use Automatic Workload Repository (AWR) to capture the information for top SQL on the existing system.

  7. Transport STS on the test environment and use SQL Performance Analyzer to compare the before and after performance.

Identify the correct steps required to perform the test.

  1. 2 and 3 only

  2. 6 and 7 only

  3. 1, 4, and 5 only

  4. 2, 3, and 5 only

  5. 2, 3, 4, and 5 only

Answer: C

Question No: 54

View the Exhibit and examine the partial output from the query on the v$file_histogram view: Which statement correctly interprets the output displayed in the Exhibit?

Latesttests 2018 PDF and VCE

  1. The database waited 58 times in a time interval of two milliseconds for FILE# 1.

  2. The database experienced 58 waits of two milliseconds duration each for FILE# 1.

  3. The database performed 58 synchronous single block reads in a time interval of two milliseconds for FILE# 1.

  4. The database experienced 58 waits of duration less than two milliseconds each that are not included in any smaller bucket.

Answer: D

Question No: 55

View the Exhibit.You want to set the threshold for the number of transactions (per second)metric with the threshold type as significance level. Which baseline would you choose to make the threshold adaptive?

Latesttests 2018 PDF and VCE

  1. LAST_NIGHT

  2. THU_SECTION

  3. SYSTEM_MOVING_WINDOW

D. MONDAY_1_2008-07-15.02:00

Answer: C

Question No: 56

You work as a DBA for a company and as a performance improvement measure, you implemented the result cache in your database.

View the Exhibit named SETTING and note the result cache settings.

Latesttests 2018 PDF and VCE

Many users in the company state that performance has improved on the queries they use but some users complain that they have not got any performance benefit on the queries they use.

You checked all the queries they use and the following is one of them: SQLgt; SELECT slnoq.currval as quot;SLNOquot;, prod_id, pdname,

2 cust_name FROM sales WHERE sl_date lt; sysdate;

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

Latesttests 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 CLIENT_RESULT_CACHE_SIZE parameter is set to 0

Answer: A,C

Question No: 57

You are working on a database that was upgraded to Oracle Database 11g from Oracle Database 9i. An ADDM finding in this database says that the shared pool is inadequately

sized, as shown in the Exhibit.

Latesttests 2018 PDF and VCE

You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. The following are the related parameter settings:

SQLgt; show parameter sga name TYPE VALUE

————— ——– ———

lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 300M sga_target big integer 0

SQLgt; show parameter target name TYPE VALUE

————— ——– ———

…..

fast_start_mttr_target integer 0 memory_max_target big integer 0 memory_target big integer 0 pga_aggregate_target big integer 100M sga_target big integer 0

You want to balance the memory between the System Global Area (SGA) components within the SGA

depending on the workloads. Which two options would solve this problem? (Choose two.)

  1. Set the SGA_TARGET parameter to 300M.

  2. Set the SGA_MAX_SIZE parameter to 400M.

  3. Set the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to 400M.

  4. Set the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to 100M.

  5. Set the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZEparameter to 400M.

Answer: A,C

Question No: 58

You are working on a development database that was upgraded to Oracle Database 11g from Oracle Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown in the Exhibit.

Latesttests 2018 PDF and VCE

You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. You tried to resize this by shrinking the database buffer cache but that caused inadequate buffer cache problems. The following are the related parameter settings:

SQLgt; show parameter sga NAME TYPE VALUE

————— ——– ———

lock_sga boolean FALSE pre_page_sga boolean FALSE sga_max_size big integer 300M sga_target big integer 0

SQLgt; show parameter target NAME TYPE VALUE

————— ——– ———

…..

fast_start_mttr_target integer 0 memory_max_target big integer 0 memory_target big integer 0 pga_aggregate_target big integer 100M sga_target big integer 0

You want to balance the memory between the System Global Area (SGA) components within SGA without affecting the size of the Program Global Area (PGA). Which action would solve this problem?

  1. Set the SGA_TARGET parameter to 300M.

  2. Set the SGA_MAX_SIZE parameter to 400M.

  3. Set the MEMORY_TARGET parameter to 100M.

  4. Set the MEMORY_MAX_TARGET parameter to 300M.

Answer: A

Question No: 59

You are managing an online transaction processing (OLTP) database with multiple applications. The applications support a large number of users and most of the applications execute groups of SQL that run

together.Which option would you use to monitor the performance issues for users of these applications?

  1. Monitor statistics for individual sessions in an application by querying V$SESSION.

  2. Specify service-level thresholds and priorities for users of applications and monitor the alerts.

  3. Monitor statistics and wait events collected for a MODULE and ACTION by performing service aggregation.

  4. Configure application users as part of the resource consumer group and monitor the resource usage statistics for the resource consumer group.

Answer: C

Question No: 60

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 a better execution plan. After implementing the profile, you altered the profile to include it in a category as follows:

SQLgt; EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE ( name=gt;

#39;SYS_SQLPROF_0146ced728214000, attribute_name =gt; #39;CATEGORY#39;, value =gt; #39;DEV2#39;).

But the performance has not improved for the user session. The profile is enabled and on investigating the query plan, you find that the query from the user session does not use the SQL profile. View the Exhibit and examine the parameters for the user session. What could be the reason for this?

Latesttests 2018 PDF and VCE

  1. The CONTROL_MANAGEMENT_PACK_ACCESS parameter is not set to DEV2.

  2. The OPTIMIZER_MODE parameter is set to ALL_ROWS for the user session.

  3. The SQLTUNE_CATEGORY parameter is set to DEFAULT for the user session.

  4. The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE for the user session.

Answer: C

100% Free Download!
Download Free Demo:1z0-054 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-054 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
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE