Question

A command that lets you change one or more field in a table is:

Select the correct answer from below options:

a) INSERT

b) MODIFY

c) LOOK-UP

d) All of the above

Answer 1

b) MODIFY

The modify command is used to change one or more columns in the existing table. It is generally used with ALTER TABLE statement as follows.

LTER TABLE table_name MODIFY column_name column_type;