Q8
A command that lets you change one or more fields in a record is
A.
Insert
B.
Modify
AnswerC.
Look-up
D.
All of the above
Answer: Option B
Solution
Answer: Option B
Solution:
Sometimes we need to change the data type of a column. To do this, we use the ALTER TABLE Modify Column command.
Sytax:
ALTER TABLE table_name
MODIFY column_name "New Data Type"