Default value of DeleteXid is
-
0
-
1
-
NULL
-
None of the above
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.