If the block is not in memory the server process

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: e buffer cache using a hash function. If it is already in memory, the server process uses it. If the block is not in memory, the server process contacts the DBWR process to read the data block into the buffer cache. Once it is there, the server process can access the data block. Answer: C QUESTION 129: Database Resource Manager uses resource plans to determine resource limits for the set of users. Which statement is true? A. Resource plans are set using profiles. B. Only one resource plan can be stored in the database at one time. C. The database can have many resource plans, but only one can be active at any one time. D. The database can have many resource plans, and each user chooses which plan to belong to. Answer: C QUESTION 130: You have free buffer waits occurring in your Oracle9 i database. You determine that DBWn performance is the problem. Which two situations could cause the problem? (Choose two.) A. The I/O system is too slow. B. The buffer cache is too large. C. DBWn is waiting for resources such as latches. D. The DBWn process is busy satisfying users' read requests. Actualtests.com - The Power of Knowing 1Z0-030 E. Buffers are being kept in the OS cache, instead of going straight to disk. Answer: A, C QUESTION 131: The buffer cache advisory is used for which two purposes? (Choose two.) A. Provides a physical read factor for the keep buffer pool if it is in use in the SGA. B. Advises DBAs on the optimal size of the default buffer cache for the current workload. C. Advises DBAs on whether to set up the keep and recycle buffer pools if neither is defined in the SGA. D. Advises DBAs on whether to set up buffer caches with different block sizes when only the default buffer cache is being used in the SGA. Answer: A, B QUESTION 132: You want to gather statistics for all objects in a schema, but you don't want to discard the current statistics. What is the most efficient method of completing this task with minimal impact on database downtime and performance? A. Create a clone database and gather statistics from it. B. Take DB backup, gather statistics, then restore the database. C. Export tables in the schema, gather statistics, then import the tables. D. Use the DBMS_STATS package to gather statistics while saving the current statistics, then restore the original statistics. Answer: D QUESTION 133: Which dynamic performance view should you query to find out how many sorts went to disk and how many sorts went to memory? A. V$LOG B. V$CACHE C. V$SYSSTAT D. V$SESSION E. V$SQLAREA F. V$ROWCACHE Answer: C Actualtests.com - The Power of Knowing 1Z0-030 QUESTION 134: You and several other DBAs are discussing the different areas in the SGA and debating the importance of tuning each area. The four statements below are made during your conversation. Which two are true? (Choose two.) A. When you tune the shared pool, you should concentrate on tuning the data dictionary cache. If the hit ratio for the data dictionary cache is acceptable, the hit ratio for the library cache should also be acceptable. B. A cache miss in the database buffer cache is more expensive that a miss in the data dictionary cache or the library cache, so tuning the database buffer cache is a priority. C. A cache miss in the data dictionary cache or the library cache is more expensive than a miss on the database buffer cache, so tuning the shared pool is a priority. D. When using shared servers, you should either allocate additional space to the shared pool or set up the large pool to accommodate the User Global Area for the shared server users. Answer: C, D Actualtests.com - The Power of Knowing...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online