Multiple choice technology databases

What is FREEPAGE and PCTFREE in TABLESPACE creation?

  1. PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be loaded with data between each free page.

  2. PCTFREE: percentage of each page to be loaded with data and FREEPAGE: Number of pages to be loaded with data between each free page.

  3. PCTFREE: percentage of each page to be left free and FREEPAGE: Number of pages to be left free with data between each loaded page.

  4. PCTFREE: percentage of each page to be loaded with data between each free page and FREEPAGE: Number of pages to be left free.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In DB2, PCTFREE defines the percentage of space on each page to be left empty during initial load or reorganization for future updates. FREEPAGE specifies how often a completely empty page should be left in the tablespace (e.g., every 'n' pages) to accommodate growth.

Keep practicing — related questions