Multiple choice technology

Default value of DeleteXid is

  1. 0

  2. 1

  3. NULL

  4. None of the above

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

DeleteXid defaults to 0, which is a special value indicating the record has not been deleted. When a record is deleted, its DeleteXid is set to the transaction ID that performed the deletion. This is part of Netezza's transaction tracking system where each record carries both InsertXid and DeleteXid.