Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Oracle 1Z0-054
Title
: Oracle Database 11g:
Performance Tuning
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. Identify two correct statements about the Active Session History (ASH) data. (Choose two.)
A. A part of SGA memory is used to store ASH data as rolling buffer.
B. The ASH data can be analyzed between any two small time intervals.
C. All ASH data in memory are flushed to disk by MMON in every 3 seconds.
D. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.
Answer: AB
2. 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
3. You are working on an online transaction processing (OLTP) system. By day most of the application
users perform queries accessing the most recently added or modified rows. The applications have most of
the queries based on multiple tables. But at night, some batch processing is also done.
Which two actions would you recommend to choose a goal for the optimizer based on the needs of your
application? (Choose two.)
A. setting the OPTIMIZER_MODE parameter to ALL_ROWS at the instance level
B. setting the OPTIMIZER_MODE parameter to FIRST_ROWS_n at the instance level
C. asking the developer to add a hint /*ALL_ROWS