Which of the following is not part of the database buffer pool?
1. KEEP
2. RECYCLE
3. LIBRARY
4. DEFAULT
Answer 3 - There is no database buffer cache called LIBRARY. The DBA can configure multiple buffer pools using the appropriate initialization parameters for improved performance. The KEEP buffer pool retains the data blocks in memory, thay are not aged out (as the name implies). The RECYCLE buffer pool removes the buffers from memory as soon as they are not needed. The DEFAULT buffer pool contains the blocks that are not assigned to the other pools.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment