報名費並不便宜，沒有人想為 1Z0-054 付第二次考試費。與其抱著僥倖上考場，不如先用 Fast2test 的 192 道練習題徹底檢驗實力，爭取一次就把 Oracle Database 11g: Performance Tuning 考到手。

Oracle 1Z0-054 考試概覽:

Oracle 1Z0-054 考試大綱主題:

Oracle 1Z0-054 考試疑問總整理

最新的 9i Internet Application Developer 1Z0-054 免費考試真題：

問題 #1

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

A. Automatic Workload Repository (AWR) snapshots
B. Stored outline
C. SQL Tuning Set
D. Cursor cache

問題 #2

The OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter is set to TRUE for a 24x7
database instance. The space consumption has significantly increased by the automatically
captured plan baselines. You are suggested to run the following block:
BEGIN
dbms_spm.configure('SPACE_BUDGET_PERCENT', 30);
END;
After a few weeks of work, you observe warnings on exceeding space usage by SQL Management
Base (SMB) in alert log file. Which two actions can be solutions for this? (Choose two.)

A. increasing the AWR retention period
B. purging the older SQL management objects
C. increasing the size of the SYSAUX tablespace
D. increasing the size of the SYSTEM tablespace

問題 #3

View the Exhibit and examine the partial output from the query on the v$file_histogram view: Which statement correctly interprets the output displayed in the Exhibit?

A. The database experienced 58 waits of two milliseconds duration each for FILE# 1.
B. The database experienced 58 waits of duration less than two milliseconds each that are not included in any smaller bucket.
C. The database performed 58 synchronous single block reads in a time interval of two milliseconds for FILE# 1.
D. The database waited 58 times in a time interval of two milliseconds for FILE# 1.

問題 #4

You noticed a high number of SQL statements with the same PLAN_HASH_VALUES. View Exhibit1 to see the details.

View Exhibit2 to see the details of the SQL text for the statements.

What do you infer from the results?

A. The cursor for the statement is aging out of the shared pool very quickly.
B. The statements are using the same cursor.
C. Removing the bind variable would improve performance.
D. The statements are not using the same cursor.

問題 #5

You work as a database administrator to manage an online transaction processing (OLTP)
system.The application code was recently tuned for optimum performance and users
acknowledged the performance improvement. However, the users are now again complaining that
the application response time has gone down considerably.
You used a few queries to investigate the problem and a couple of important queries are shown in
the Exhibit. View the Exhibit and analyze the output shown.
Which actions would improve the performance? (Choose all that apply.)

A. decreasing the value set to the FAST_START_MTTR_TARGET parameter
B. decreasing the size of the database buffer cache
C. increasing the number database writers
D. increasing the size of the database buffer cache
E. decreasing the number of database writers

問題與答案：