Multiple choice technology databases

Which SQL statement is used to insert new column in a table with an alter statement?

  1. ADD

  2. ADD NEW

  3. INSERT

  4. INSERT NEW
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The ADD clause is used with ALTER TABLE to insert a new column into an existing table. INSERT is used to add new rows, not columns. The correct SQL syntax is 'ALTER TABLE table_name ADD column_name data_type'.

Keep practicing — related questions