Question

A command that lets you change one or more fields in a record is

(a) Insert

(b) Modify

(c) Look-up

(d) All of the Mentioned

Answer 1

The correct option is (b) Modify

To elaborate: Sometimes we need to change the data type of a column. To do this, we use the ALTER TABLE Modify Column ALTER TABLE table_name, MODIFY column_name “New Data Type”.