Multiple choice

Which of the following SQL keywords is used to resize a column definition?

  1. Alter table

  2. Resize

  3. Drop

  4. Change Size

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The alter statement is used to resize a column.  The size of a column can both be increased or decreased using the alter keyword. Normally, the size of a column can be increased to a large value but it can only be decreased to the limit that if there is data present in the column, it should not get trimmed.