This preview shows page 1. Sign up to view the full content.
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.
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
D. The database can have many resource plans, and each user chooses which plan to
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
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
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
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.
Which dynamic performance view should you query to find out how many sorts
went to disk and how many sorts went to memory?
Answer: C Actualtests.com - The Power of Knowing 1Z0-030
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
Answer: C, D Actualtests.com - The Power of Knowing...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09