nerdexam
Oracle

1Z0-054 · Question #106

Which statement is true regarding the setting of the PCTFREE value for an index?

The correct answer is A. It decides how much of a block to fill when the index is created. See the full explanation below for the reasoning.

Question

Which statement is true regarding the setting of the PCTFREE value for an index?

Options

  • AIt decides how much of a block to fill when the index is created.
  • BIt has no role to play when segment space management is automatic.
  • CIt keeps space reserved in a block for possible updates to existing rows in that block.
  • DIt is the minimum percentage of a block that can be used for row data and overhead before new

How the community answered

(48 responses)
  • A
    83% (40)
  • B
    10% (5)
  • C
    2% (1)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice