Multiple choice technology databases

How to prevent ROW MIGRATION?

  1. specify large pct free

  2. specify large pct used

  3. specify large initial & next sizes

  4. specify small initrans

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

PCTFREE specifies the percentage of space reserved in each block for row expansion. Specifying a large PCTFREE prevents row migration by ensuring sufficient space remains for updates that increase row size. PCTUSED controls when blocks return to free list, INITTRANS controls concurrent transaction slots, and storage sizes affect allocation not migration.