Multiple choice technology databases

Which of the following methods should you use to increase the number of nullable columns for a table?

  1. Use the alter table statement

  2. Ensure that all column values are NULL for all rows

  3. First, increase the size of adjacent column datatypes, and then add the column

  4. Add the column, populate the column, and then add the not NULL constraint
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To add nullable columns to a table, you use ALTER TABLE ADD COLUMN - columns are nullable by default unless you specify NOT NULL. Option D would work for a NOT NULL column, but it's unnecessarily complex for nullable columns. Options B and C are incorrect approaches.

Keep practicing — related questions