1z0-054 dumps
Oracle Database 11g: Performance Tuning
Exam Number/Code : 1z0-054
Exam Name : Oracle Database 11g: Performance Tuning
Questions and Answers : 192 Q&As
Update Time: 2009-10-05
Price: $ 120.00
1. A batch workload that historically completed in the maintenance window between 10:00 PM and midnight is currently showing poor performance and completing at 2 AM.
To help in the diagnosis of the performance degradation, the senior DBA in your organization asks you to execute the awrddrpt.sql script to produce a Compare Periods report.
Which two statements are true about the report produced by this script? (Choose two.)
A. It is refreshed automatically based on the moving window baseline.
B. It compares details between any two selected time periods of the same duration.
C. It normalizes the statistics by the amount of time spent on the database for each time period.
D. It compares details between two consecutive time periods of the same or different durations and is refreshed every 60 minutes.
Answer: BC
2. You plan to use adaptive thresholds as part of the performance tuning activity. You decide to increase the window size of the default moving window baseline for all metric observations and comparisons in your database. The following error occurs when you try to increase the window size through Enterprise Manager:
Failed to commit: ORA-13541: system moving window baseline size (1296000) greater than retention (1036800) ORA-06512: at “SYS.DBMS_WORKLOAD_REPOSITORY”, line 601 ORA-06512: at line 2
Which action would allow you to perform the preceding task successfully?
A. increasing the flashback retention period
B. increasing the retention period for SQL Management Base
C. increasing the undo retention period for the database instance
D. increasing the Automatic Workload Repository (AWR) retention period
Answer: D
3. 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
4. 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
5. 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*/ in the long-running batch processing queries
D. asking the developer to add a hint /*FIRST_ROWS_n*/ in the long-running batch processing queries
Answer: BC
6. Which three factors influence the optimizer’s behavior while choosing an optimization approach and goal for a SQL statement? (Choose three.)
A. parsing of a SQL statement
B. operating system (OS) statistics
C. object statistics in the data dictionary
D. the OPTIMIZER_MODE initialization parameter
E. optimizer SQL hints for changing the query optimizer goal
Answer: CDE
Certinside 1z0-054 exam like testking 1z0-054 exam pass4sure 1z0-054 exam killtest 1z0-054 exam Certinside 1z0-054 dumps and passguide 1z0-054 exam,it downlaods from the test center.If you will take 1z0-054 exam,I suggest you choose vsualexams 1z0-054.We guarantee that you can pass 1z0-054 exam at your first try.