Oracle 1Z0-054 問題集

質問 1：
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. purging the older SQL management objects
B. increasing the size of the SYSAUX tablespace
C. increasing the AWR retention period
D. increasing the size of the SYSTEM tablespace
正解：A,B

質問 2：
View the Exhibit.You decide to quickly configure the adaptive threshold. What would happen to the existing metric thresholds shown in the Exhibit?

A. Only the thresholds set with baselines other than the SYSTEM_MOVING_WINDOW baseline will remain in effect.
B. It would be overwritten.
C. It would remain in effect.
D. Only the thresholds set with the SYSTEM_MOVING_WINDOW baseline will remain in effect.
正解：B

質問 3：
View the Exhibit and examine the output for the query on V$IOSTAT_FUNCTION.Which two statements are true about the interpretation of the output? (Choose two.)

A. If there is a conflict of I/Ofunctions, the I/O is placed in the bucket with the lower FUNCTION_ID.
B. If there is a conflict of I/O functions, the I/O is placed in the bucket with the higher FUNCTION_I
C. The I/O statistics are for single block or multi-block read and write operations.
D. The I/O statistics are only for the single block read and write operations.
正解：A,C

質問 4：
Identify two correct statements about the Active Session History (ASH) data. (Choose two.)
A. All ASH data in memory are flushed to disk by MMNL process whenever the buffer is full.
B. The ASH data can be analyzed between any two small time intervals.
C. A part of SGA memory is used to store ASH data as rolling buffer.
D. All ASH data in memory are flushed to disk by MMON in every 3 seconds.
正解：B,C

質問 5：
You are working on a decision support system (DSS). The index is available on the COUNTRY_ID column of the CUSTOMERS table.View the Exhibit and examine the parameter settings and the query execution plan.

Why is the query using a full table scan instead of an index scan?
A. because the histogram statistics for the COUNTRY_ID column are not updated
B. because the DB_FILE_MULTIBLOCK_READ_COUNT initialization parameter is set to a higher value
C. because the index statistics for the index on the COUNTRY_ID column are not current
D. because the optimizer predicts that most of the blocks in the tableare accessed. Therefore, it uses a full table scan, even though indexes are available.
正解：D

質問 6：
Examine the query output shown below:
SQL> SELECT sum(pins), sum(reloads), sum(reloads)/sum(pins)
FROM v$librarycache;
SUM(PINS) SUM(RELOADS) SUM(RELOADS)/SUM(PINS)
16479 16000 0.9709327 Which statement describes the correct interpretation of the reloads-to-pin ratio and the action to be taken?
A. This ratio is reasonable. However, decrease the shared pool size for better performance.
B. This ratio is reasonable. However, this needs monitoring. Increase the shared pool size only if the ratio falls below 0.1.
C. This ratio is reasonable. However, this needs monitoring. Increase the shared pool size only if the ratio crosses 1.
D. This ratio is very high and the shared pool size should be increased immediately to reduce this ratio.
正解：D

質問 7：
The Service-Level Agreement for the production database includes a clause that the database down time should not be more than 15 minutes.Which two details would you examine in the alert log to diagnose whether your database meets this requirement? (Choose two.)
A. the FAST_START_MTTR_TARGET parameter setting
B. deadlock and timeout errors
C. instance recovery time
D. log switch frequency
E. data file recovery time
正解：A,C