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

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

Oracle Database 11g: Performance Tuning

Question No: 101

You query the V$SYSSTAT view and notice a significantly high value for the redo log space requests statistic.Which three components would you consider for further investigation based on this information? (Choose three.)

  1. LGWR

  2. checkpoints

  3. archiver activity

  4. size of the log buffer

  5. size of the redo log files

Answer: B,C,E

Question No: 102

You identified a SQL statement with SQL ID 9g485acn2n30m, which is expensive on the resources. To view the execution plan for the statement, you executed the following command:

SQLgt; SELECT * FROM TABLE(dbms_xplan.display_cursor(#39;9g485acn2n30m#39;,1)); What would this command accomplish?

  1. It formats and displays the contents of the execution plan for the cursor with the SQL_ID #39;9g485acn2n30m#39; from the library cache.

  2. It formats and displays the contents of the execution plan but does not guarantee accuracy if the SQL statement has bind variables.

  3. It formats and displays the contents of the execution plan but does not guarantee that the same execution plan would be executed.

  4. It formats and displays the contents of the execution plan for the cursor with the SQL_ID #39;9g485acn2n30m#39; from the DBA_HIST_SQL_PLAN view.

Answer: A

Question No: 103

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version that contains important SQL statements. You are not sure about the elapsed time that the SQL statements will have in the new system due to the version change of the optimizer. Which tool provides a comparative report with respect to the elapsed time in both versions of the optimizer?

  1. SQL Access Advisor

  2. SQL Tuning Advisor (STA)

  3. SQL Performance Analyzer (SPA)

  4. Automatic Workload Repository (AWR) compare period report

Answer: C

Question No: 104

Which statement is correct about server-generated alerts?

  1. All server-generated alerts are based on threshold levels.

  2. Alerts are not issued for locally managed tablespaces in read-only mode.

  3. The STATISTIC_LEVEL initialization parameter must be set to ALL to enable server- generated alerts.

  4. Alerts for both locally managed tablespaces and dictionary-managed tablespaces are server generated.

Answer: B

Question No: 105

Which two activities can be identified as common unscalable causes of suboptimal database performance? (Choose two.)

  1. defining multiple buffer pools

  2. applications generating dynamic SQL

  3. large amounts of recursive SQL executed by SYS

  4. recursive SQL executed by a user other than SYS

  5. using cursors with bind variables that open the cursor and execute it many times

Answer: B,C

Question No: 106

View the Exhibit and analyze the output of the query.What does the high value for the table fetch continued rows statistics indicate?

Latesttests 2018 PDF and VCE

  1. chained rows fetched only

  2. migrated rows fetched only

  3. rows fetched from external tables

  4. both chained and migrated rows fetched

  5. rows fetched from Index Organized Tables (IOT)

Answer: D

Question No: 107

You work on an online transaction processing (OLTP) database in which the SALES table has 10,000 rows but only four distinct products are sold.

View the Exhibit named HIST to check data distribution in the table and the histograms on the table.

Latesttests 2018 PDF and VCE

View the Exhibit named QUERY-1 that shows details in the V$SQL view for the query executed on the SALES table having product id 1.

Latesttests 2018 PDF and VCE

Further, you query the SALES table thrice more in the following order:

  • query rows having product ID 4

  • query rows having product ID 2

  • query rows having product ID 4

View the Exhibit named QUERY-n to see the details about these queries.

Latesttests 2018 PDF and VCE

What do you infer from this?

  1. The second plan was created because the first plan was aged out.

  2. The CURSOR_SHARING parameter value was changed to EXACT after the second query was executed.

  3. The third plan was created because the first plan was aged out and the second plan had different selectivity.

  4. The first two executions used the same plan because at parse time the optimizer did not consider selectivity as the cursor was not yet considered bind-aware.

Answer: D

Question No: 108

Examine the output of the following query:

SQLgt; SELECT c.name,a.addr,a.gets,a.misses,a.sleeps, 2 a.immediate_gets,a.immediate_misses,b.pid

  1. FROM v$latch a, v$latchholder b, v$latchname c

  2. WHERE a.addr = b.laddr( ) and a.latch# = c.latch#

  3. AND c.name LIKE #39;amp;latch_name%#39; ORDER BY a.latch#;


—— —- —- —- — ——- ——– shared pool 20016544 8520540 14112 3137 0 0

You calculated the Gets-to-Misses ratio, which is .99834, and this ratio is dropping over a

period of time.

Which two actions can improve this? (Choose two.)

  1. reducing hard parses

  2. increasing the size of the shared pool

  3. using only dedicated server connections

  4. setting the CURSOR_SHARING parameter to EXACT

  5. encouraging the use of more literal SQL statements

Answer: A,B

Question No: 109

You work for a small manufacturing company as a DBA. The company has various applications to manage the details of its business and customer base. The company has only one sales outlet where the operator updates the SALES table in the sales application with the details when a product is sold. The company has many other applications for various other businesses that use the same database.

The sales operator, while generating a report, noticed that there are some gaps generated in the serial number in the SLNO column during peak hours of business.

On investigating, you find that the SLNO column in the SALES table uses the SLNSEQ sequence to generate the serial numbers when a record is inserted.

During peak hours, you noticed the following:

When the operator entered the sales details the last time, the sequence number was 1056300, but when you checked the sequence as follows, you found a gap of 100 numbers:

SQLgt; SELECT sequence_name, last_number FROM user_sequences WHERE sequence_name=#39;SLNSEQ#39;;


————— —— SLNSEQ 1056400

You observed this behavior many times and only during peak hours. What could be the problem and solution for this?

  1. The reserved pool is not configured. Configure the reserved pool.

  2. The keep buffer pool is not configured. Configure the keep buffer pool.

  3. The sequence was created with a CACHE of 100 numbers. Re-create the sequence with a higher CACHE number.

  4. The sequence is aging out of the shared pool. Keep the sequence in the shared pool using the DBMS_SHARED_POOL.KEEP procedure.

Answer: D

Question No: 110

View the Exhibit and note the workload type selected to quickly configure the metric threshold. Which statement describes the result after finishing this quick configuration process?

Latesttests 2018 PDF and VCE

  1. It sets thresholds for all basic metrics.

  2. All thresholds set are of the Significance Level type.

  3. It uses only the SYSTEM_MOVING_WINDOW baseline for thresholds.

  4. The thresholds set by the quick configuration process are of the Fixed Value type.

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

2018 Latesttests IT Certification PDF and VCE