aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Oracle Database Administration
  • Which SGA database buffer is used to store different bloc...
Multiple choice

Which SGA database buffer is used to store different block sizes?

  1. Database buffer cache

  2. KEEP buffer pool

  3. RECYCLE buffer pool

  4. nK buffer cache

  5. Shared pool

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

nK buffer cache, one of the several specialised database buffer caches designed to hold block sizes different from the default database block size.

Keep practicing — related questions

  • Which of the following SGAs is the circular buffer that stores all changes made in database?
  • Which of the following memory components of the SGA stores the most recently used block of data?
  • Which of the following memory components of the SGA is used to hold data blocks read from data files by ser...
  • Which of the following memory components of the SGA consists of blocks that hold data dictionary informatio...
  • Which of the following memory components of the SGA contains 'dirty' or modified blocks and clean or unused...
  • Which memory area is not part of the SGA?
  • Which of the following memory components of the SGA stores all the changes made in the database?
  • Which of the following memory components of the SGA is managed in a manner that free blocks are always made...
Play the full quiz 🎤 Practise this topic out loud

Practice this topic

  • Database Management Systems (5344 questions)
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy