loan

subject: 1z1-054 Practice Exam [print this page]

Testinside 1Z1-054 exam study materials includes 1Z1-054 braindumps, 1Z1-054 study guide, 1Z1-054 practice exam,Oracle free 1Z1-054 demo and much more which will not only enhance your abilities to cope with the problems but you will also be able to manage online real time problems.An authentic and comprehensive 1Z1-054 exam solution is available at Testinside.

Oracle Certification 1Z1-054 Exam

Oracle Database 11g: Performance Tuning

Exam Number/Code : 1Z1-054

Exam Name : Oracle Database 11g: Performance Tuning

Questions and Answers : 192 Q&As

Update Time: 2011-01-13

Exam : Oracle 1Z1-054

Title : Oracle Database 11g: Performance Tuning

1. View the Exhibit and examine a portion of the output obtained from the following query:

SQL> SELECT * FROM v$sys_time_model;

Select three correct interpretations of the time model statistics. (Choose three.)

A. DB time includes the wait time of all the nonidle and idle user sessions.

B. SQL execute elapsed time includes the time spent in performing fetches of query results.

C. DB CPU includes the CPU time spent on database user-level calls and background CPU time.

D. SQL execute elapsed time includes components of the hard parse elapsed time like bind elapsed time.

E. DB time includes the connection management call elapsed time excluding the background process time.

Answer: BDE

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

optimizer_index_caching integer 0

optimizer_index_cost_adj integer 100

optimizer_mode string ALL_ROWS

db_file_multiblock_read_count integer 64

You notice that the one of the queries is using a full table scan (view Exhibit1) instead of index unique scan (view

Exhibit2). The index is present on the column that is accessed in the WHERE clause of the query. The cost for a full

table scan is more than that for an index unique scan.

Why would the optimizer choose full table scan over index unique scan? (Choose all that apply.)

A. The OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to a low value.

B. The OPTIMIZER_INDEX_COST_ADJ initialization parameter is set to a high value.

C. The DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a low value.

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

Answer: BD

3. A user in a session executed the following SQL statement to set the optimizer mode:

ALTER SESSION SET OPTIMIZER_MODE = ALL_ROWS

What impact would it have on the goal of the optimizer for that session? (Choose all that apply.)

A. Statement level OPTIMIZER_MODE hints take precedence over the session-level setting.

B. The OPTIMIZER_MODE parameter set at instance level takes precedence over the session-level value.

C. The optimizer uses a cost-based approach, regardless of the presence of statistics; it optimizes with a goal of best

response time.

D. The optimizer uses a cost-based approach for all SQL statements in the session, regardless of the presence of

statistics; it optimizes with a goal of best throughput.

Answer: AD

To help with these preparations there are plenty of Testinside 1Z1-054 study materials available on the Internet that can dispel all these fears and nervousness. These 1Z1-054 study materials range from the official Oracle Certification Training courses and official Oracle 11g Certification Self Study Training Guide from Oracle Press, to the Testinside 1Z1-054 practice exams and Testinside 1Z1-054 study guide.

Testinside Oracle 1Z1-054 cover all content of Oracle 1Z1-054 exam, their accuracy have been checked, therefore, they are able to assure you success in your Oracle 1Z1-054 exam. These easily understood questions and answers in TESTING ENGINE make it simple for you to download and utilize. Great faith has been shown to Testinside Oracle 1Z1-054 questions and answers by more and more successful candidates.

Hot Exams:

HP0-D07 Planning and Designing HP Enterprise Solutions

HP0-J27 Advanced SAN Architecture

by: loveitexam

welcome to loan (http://www.yloan.com/)