Multiple choice technology databases

The "ENABLE ROW MOVEMENT"

  1. allows Logical Rowid's to remain independent of physical rowid's

  2. allows rows to move across partitions

  3. allows rows to be physically located in a different tablespace, while remaining tagged to a partition

  4. allows rows to be copied to non-partitioned tables
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ENABLE ROW MOVEMENT permits rows to move between partitions when their partition key values are updated. Without this clause, updating a partition key would fail because rows cannot naturally change partitions without explicit permission for row movement.

Keep practicing — related questions