__________ SQL command changes one or more fields in a record.
2017
__________ SQL command changes one or more fields in a record.
- A.
LOOK-UP
- B.
INSERT
- C.
MODIFY
- D.
CHANGE
Attempted by 1236 students.
Show answer & explanation
Correct answer: C
Answer: MODIFY
Explanation: The MODIFY command changes one or more fields in an existing record.
Note: In standard SQL the UPDATE statement is commonly used to perform this action. Different systems or teaching materials may use MODIFY as the wording here, so follow the terminology expected by your course or platform.
Why MODIFY is correct: It updates field values in an existing record.
Example usage: MODIFY table_name SET column_name = new_value WHERE condition. Alternatively, standard SQL example: UPDATE table_name SET column_name = new_value WHERE condition.
Why the other choices are incorrect:
LOOK-UP: Used to find or retrieve records, not to modify them.
INSERT: Adds new rows to a table; it does not change values in existing records.
CHANGE: Not a standard SQL command for updating row data.