The statement CHANGE FULLNAME TO is equal to which of the statements below?
-
CHANGE FULLNAME TO NULL
-
CHANGE FULLNAME TO ‘NULL’
-
CHANGE FULLNAME TO 0
-
DELETE FULLNAME
The statement 'CHANGE FULLNAME TO' with no value specified is equivalent to 'DELETE FULLNAME' - it removes the field from the record. This is a shorthand way to delete a field without explicitly using the DELETE command. Option D correctly identifies this equivalence. Options A, B, and C are incorrect because they attempt to assign specific values (NULL as keyword, string, or number) when the actual operation is deletion.
This question references an unidentified proprietary tool/language's 'CHANGE TO ' statement syntax (possibly a legacy 4GL, database utility, or record-management language), and no target platform is named in the question text. Extensive web searches for this exact syntax turned up no authoritative documentation (dBase/FoxPro's closest analogs — REPLACE...WITH, MODIFY STRUCTURE, DELETE — don't match this exact CHANGE/DELETE pairing). Without knowing which product's command reference this is drawn from, there's no way to independently verify whether 'CHANGE FULLNAME TO' (with an empty/blank target) is documented as equivalent to deleting the field's value versus setting it to NULL, an empty string literal, or zero. No evidence was found to contradict the existing key, so it is retained, but with low confidence given the unresolved tool context.