Multiple choice technology databases

What keyword is used to define the number of pages that the database will write to one container before skipping to the next container?

  1. SKIPSIZE

  2. PREFETCHSIZE

  3. STRIPSIZE

  4. EXTENTSIZE

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

EXTENTSIZE defines the number of pages written to a container before moving to the next. STRIPSIZE is for striping across containers, PREFETCHSIZE is for read-ahead, and SKIPSIZE is not a standard database storage parameter. The extent is the fundamental allocation unit.