1Z0-054 考試一旦沒通過，報名費就得再繳一次，重考成本不容小覷。與其事後補救，不如先用 Fast2test 的 Oracle Database 11g: Performance Tuning 練習題充分演練，把 192 道題目練熟練透再上場。

Oracle 1Z0-054 考試概覽:

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

關於 Oracle 1Z0-054 考試，您可能想問

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

問題 #1

View the Exhibit.Which statement is true about applying the threshold setting in the Exhibit.

A. The threshold is decided by comparing the warning and threshold values with the SYSTEM_MOVING_WINDOW baseline.
B. The threshold is decided by comparing the warning and critical values with the baseline set on the performance page.
C. The threshold is decided by comparing the warning and threshold values with the LAST_NIGHT baseline.
D. The threshold does not depend on any baseline.

問題 #2

You are working for a company that uses huge applications to manage its customer details. During your regular performance checks, you executed the following query: SQL> show parameter shared_pool_reserved_size NAME TYPE VALUE
shared_pool_reserved_size big integer 6920601 SQL> SELECT free_space, used_space, request_misses, request_failures from V$SHARED_POOL_RESERVED; FREE_SPACE USED_SPACE REQUEST_MISSES REQUEST_FAILURES
6469776 555528 0 113
You observed that REQUEST_FAILURES is 113 but not increasing, and also that
REQUEST_MISSES is not increasing.
What would you interpret from this?

A. The reserved pool is very small and is not finding enough memory to satisfy requests. Increase the size of the shared pool.
B. The reserved pool is very small and is not finding enough memory to satisfy requests. Increase the size of the reserved pool.
C. The reserved pool is very large. Consider reducing the size of the shared pool.
D. The reserved pool is large and has free space to satisfy requests. Consider reducing the size of the reserved pool.

問題 #3

View the Exhibit and examine the sample Automatic Database Diagnostic Monitor (ADDM) report.Which statement is true about the report?

A. The sum of impacts under recommendations in Finding 2 cannot exceed 100%.
B. It is possible that the sum of impacts under recommendations in Finding 2 can exceed 100%.
C. The sum of impacts of recommendation2 in Finding 1 and recommendation 2 in Finding 2 cannot exceed 100%.
D. The recommendations regarding "buffer busy" wait cannot appear more than once in the report.

問題 #4

Examine the output of the query given below:
SQL> SELECT mutex_type, location, sum(gets), sum(sleeps) FROM v$mutex_sleep_history
GROUP BY mutex_type, location;
MUTEX_TYPE LOCATION SUM(GETS) SUM(SLEEPS)
Library Cache kglhdgn1 62 8669586 4538 Library Cache kglget2 2 2016618 24 Cursor Stat kkocsStoreBindAwareStats [KKSSTALOC8] 2975 1 Cursor Pin kkslce [KKSCHLPIN2] 666831 678 Library Cache kgllkdl1 85 3369224 110 Library Cache kglpnal1 90 224199 13 Library Cache kglic1 49 42068 10 Library Cache kglpin1 4 9620087 374 Library Cache kglpndl1 95 2065089 79 9 rows selected. Which statement is true?

A. Each row in the output represents a SQL statement that had to wait for mutexes.
B. The sum of numbers in the GETS and SLEEPS columns indicates the number of times a mutex/location was requested by the requesting session while being held by the blocking session.
C. The Cursor Stat and Cursor Pin SLEEPS indicate that the CURSOR_SHARING parameter is set to EXACT.
D. The GETS column shows the number of times a mutex/location was requested by the requesting session while being held by the blocking session.

問題 #5

View the Exhibit and examine the details of the Top 5 Timed Events from an Automatic Workload Repository (AWR) report.What can be the three possible causes for the latch-related wait events? (Choose three.)

A. Cursors are not being shared.
B. Shared pool size is too small.
C. A large number of data definition language (DDL) and query statements are being executed simultaneously by different sessions.
D. There are frequent logons/logoffs.
E. A large number of COMMITs are being performed.

問題與答案：