Multiple choice

Which of the following statements about using PCTFREE and PCTUSED is true?

  1. Block space utilization can be specified only at the segment level.

  2. Block space utilization can be specified only in the data dictionary.

  3. Block space utilization parameters can only be specified at the tablespace.

  4. Block space utilization can be specified both at the tablespace level and segment level.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

PCTFREE and PCTUSED are storage parameters that control block space utilization and are specified at the segment level (table or index), not at the tablespace level or data dictionary. They determine how much free space to leave in blocks for updates (PCTFREE) and when blocks become available for new inserts (PCTUSED). Option A correctly states this.

Keep practicing — related questions