Which SQL command is used to add a new column to an existing table?

Options

  • A. UPDATE
  • B. INSERT
  • C. ALTER
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

C. ALTER

Detailed Explanation

  • ALTER TABLE modifies the structure of an existing table.
  • It can add, modify or drop columns depending on the DBMS.
  • Example: ALTER TABLE students ADD age INT;
← Previous Next →

Attempt Quiz Now:

TRE 4.0 DBMS Quiz Practice Set 1

Feature Posts