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

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

Oracle Database 11g: Performance Tuning

Question No: 121

Identify two correct statements about the Active Session History (ASH) data. (Choose two.)

  1. A part of SGA memory is used to store ASH data as rolling buffer.

  2. The ASH data can be analyzed between any two small time intervals.

  3. All ASH data in memory are flushed to disk by MMON in every 3 seconds.

  4. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.

Answer: A,B

Question No: 122

You received complaints from users about slow response time in some parts of the application. On investigation, you find that this happens whenever the application runs any query against the PROD_DET

table that contains detailed information about all the products.

You gathered the table statistics and executed the following statements to find more information about

this table:

SQLgt; SELECT chain_cnt, 2 round(chain_cnt/num_rows*100,2) pct_chained, 3 avg_row_len, pct_free ,

pct_used 4 FROM user_tables 5 WHERE table_name = #39;PROD_DET#39;;CHAIN_CNT PCT_CHAINED

AVG_ROW_LEN PCT_FREE PCT_USED—– —— —— —– —–4789 100 3691 10 40

Which methods can you use to improve the performance? (Choose all that apply.)

  1. online table redefinition

  2. export and import the table

  3. decrease the PCTFREE value

  4. move the table using the ALTER TABLE command

Answer: A,B,D

Question No: 123

Examine the initialization parameter values for the instance given below: NAME TYPE VALUE

—————— —— ———

optimizer_capture_sql_plan_baselines boolean FALSE optimizer_dynamic_sampling integer 2

optimizer_features_enable string

optimizer_index_caching integer 0

optimizer_index_cost_adj integer 100 optimizer_mode string ALL_ROWS db_file_multiblock_read_count integer 64

The index created on the column used in the WHERE clause of the query. You notice that the query is not using the index. Instead of an index scan, a full table scan is used.

View the Exhibit and examine the autotrace output for a query.

Latesttests 2018 PDF and VCE

What could be the reason for it? (Choose all that apply.)

  1. The OPTIMIZER_INDEX_COST_ADJ initialization parameter has a low value.

  2. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter has a low value.

  3. The statistics for the table and all the indexes associated with the table are not current.

  4. The table has less than DB_FILE_MULTIBLOCK_READ_COUNT blocks under the high-water mark.

Answer: C,D

Question No: 124

Your organization has purchased licenses for the Diagnostic Pack along with the Oracle Database 11g software.The application workload on your database is known to be stable between 10:00 PM and midnight every night, but the performance on a particular Thursday was poor between 10:00 PM and 11:00 PM. Which tool would you consider using first to diagnose the cause of the performance degradation?

  1. Database Replay

  2. STATSPACK Report

  3. AWR Compare Report

  4. SQL Performance Analyzer

Answer: C

Question No: 125

You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events:


Event Total Seconds Total Wait

Name Waits Waiting Timeouts (in secs)

————— —— —- —— —–

direct path read temp 18,274 11,312 16,282 .619

direct path write temp 3,251 416 25 .127

Which step would be appropriate to improve the performance?

  1. Increase the number of I/O slaves.

  2. Increase the size of the Database Buffer Cache.

  3. Increase the size of the Program Global Area (PGA).

  4. Increase the number of database writer (DBWn) processes.

Answer: C

Question No: 126

Identify the situation in which you would use the Automatic Workload Repository (AWR) baseline template.

  1. when creating AWR snapshots based on a repeating time schedule

  2. when creating and dropping AWR baselines based on a repeating time schedule

  3. when computing statistics for all moving window baselines based on a repeating time schedule in the future

  4. when resetting the threshold values for the SYSTEM_MOVING_WINDOW baseline based on a repeating time schedule in the future

Answer: B

Question No: 127

As a DBA, you notice a change in the performance of your database. Which two pieces of tuning-related information can you examine in the alert log to identify possible causes? (Choose two.)

  1. the number of block corruption errors

  2. SQL statements that are consuming maximum resources

  3. the top five sessions that are consuming maximum resources

  4. the instance parameter values that have been changed using ALTER SYSTEM since the last baseline

Answer: A,D

Question No: 128

View the Exhibit and examine the partial output obtained when you issued the following query: SQLgt; SELECT name,class,value FROM v$sysstat ORDER BY class;Which two interpretations are correct about the information obtained from this view? (Choose two.)

Latesttests 2018 PDF and VCE

  1. db block changes indicates the number of data blocks that have been changed.

  2. buffer is pinned count indicates the number of buffers that are currently pinned in the database instance.

  3. Usage of CACHE and NOCACHE hints affects statistics for table scans (long tables) and table scans (short tables).

  4. redo log space requests indicates the number of times a there were waits for disk space to be allocated for the redo log entries.

Answer: C,D

Question No: 129

You look at the Top 5 Timed Events section of the Automatic Workload Repository (AWR) report and find that the wait event buffer busy waits is consuming a significant portion of DB time. What does this wait event indicate?

  1. buffer cache too small

  2. insufficient DBWn processes

  3. excessive block replacement

  4. a large number of locally-managed tablespaces in the database

  5. block contention on segment headers, data blocks, undo header, or undo blocks

Answer: E

Question No: 130

The columns CUST_CITY, CUST_STATE_PROVINCE, and COUNTRY_ID are frequently used together in the WHERE clause of the queries. The CUSTOMERS table is a big table with 20 GB of data. You notice that the selectivity for these three columns varies from the selectivity that the optimizer calculates. What would you recommend to influence the selectivity calculated by the optimizer?

  1. creating function-based indexes by concatenating all the columns

  2. updating histogram statistics for these columns by using the DBMS_STATS.GATHER_TABLE_STATS procedure

  3. using the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and create index on the virtual column

  4. using the DBMS_STATS.CREATE_EXTENDED_STATS function to create a virtual column and the DBMS_STATS.GATHER_TABLE_STATS procedure to collect statistics on the virtual column

Answer: D

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
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE