Oracle 1Z0-054 問題集

質問 1：
View the Exhibit and examine the result of Automatic SQL Tuning for a period. None of the recommended SQL profiles are implemented. What would you do to allow the Automatic SQL Tuning implement the SQL profiles automatically?

A. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to TRUE.
B. Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE for the database instance.
C. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.
D. Set the OPTIMIZER_MODE parameter to ALL_ROWS for the database instance.
正解：A

質問 2：
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. The GETS column shows the number of times a mutex/location was requested by the requesting session while being held by the blocking session.
B. The Cursor Stat and Cursor Pin SLEEPS indicate that the CURSOR_SHARING parameter is set to EXACT.
C. Each row in the output represents a SQL statement that had to wait for mutexes.
D. 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.
正解：A

質問 3：
You find that the OS utilization is over 40% in your database server. Examine the following set of performance monitoring-related activities:
1.Investigate the operating system for network transfers, paging, and swapping.
2.Check the SQL and the transactions submitting the SQL for optimal execution.
3.Investigate the top SQL by CPU utilization.
4.Consider rescheduling some work to off-peak hours.
5.Check whether there are any nondatabase jobs consuming CPU time on the machine. What is the correct sequence in which the above activities should be performed to diagnose and reduce potential performance issues?
A. 2,4,5,3,1
B. 1,2,3,4,5
C. 1,5,3,2,4
D. 4,5,3,1,2
正解：C

質問 4：
View the Exhibit and examine the content. ALLOCATED_SPACE and FREE_SPACE are not matching with the TABLESPACE_SIZE value. What would you conclude from this?

A. TEMP_L is a default temporary tablespace because the numbers show some overhead on this tablespace.
B. The temporary space allocated to large sort operations is not deallocated.
C. The temporary space was not sufficient for sort operations.
D. A new temporary file is added to the tablespace.
正解：B

質問 5：
You work as a DBA and you have the responsibility of managing a large online transaction
processing (OLTP) system. You used the following query during the performance tuning activity:
SQL> SELECT (1-((phy.value-phyd.value) / (cur.value + con.value))) * 100
2 "Cache Hit ratio"
3 FROM v$sysstat cur, v$sysstat con, v$sysstat phy, v$sysstat phyd
4 WHERE cur.name = 'db block gets'
5 AND con.name = 'consistent gets'
6 AND phy.name = 'physical reads'
7 AND phyd.name = 'physical reads direct';
Cache Hit Ratio
Which understanding of this ratio is correct?
A. 98.43% of times the requests have found the required data blocks in the buffer cache.
B. 98.43% of times the requests were satisfied by performing physicalI/Os.
C. 98.43% of times the requests have found free buffers.
D. 98.43% of the total number of requests used the buffer cache.
正解：A

質問 6：
You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently, whereas other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command at regular intervals: SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'AUTO');You need statistics to be collected more quickly. How do you achieve this?
A. Increase the value of the STALE_PERCENT preference for the partition table.
B. Set the PUBLISH preference to TRUE for the partition table.
C. Set the NO_VALIDATE preference to TRUE for the partition table.
D. Set the INCREMENTAL preference to TRUE for the partition table.
正解：D

質問 7：
You want information in the form of charts for throughput and services that shows baseline values and thresholds for the baseline. How would you achieve this?
A. By computing statistics for the desired baseline
B. By adding a baseline template to the performance page in Oracle Enterprise Manager
C. By quickly configuring the metric threshold
D. By adding a baseline to the performance page in Oracle Enterprise Manager
正解：D