Which of the following SQL statement would you typically use when you need to…
2025
Which of the following SQL statement would you typically use when you need to add a new column to an already existing table structure?
Answer: B. ALTER TABLE — The ALTER TABLE statement is used to modify the structure of an existing table in SQL. To add a new column, the syntax is typically: ALTER TABLE table_name…
- A.
INSERT INTO
- B.
ALTER TABLE
- C.
MODIFY TABLE
- D.
UPDATE COLUMN
Attempted by 491 students.
Show answer & explanation
Correct answer: B
The ALTER TABLE statement is used to modify the structure of an existing table in SQL. To add a new column, the syntax is typically:
ALTER TABLE table_name
ADD column_name datatype;Therefore, Option B is correct because it is specifically designed for changing table structures.
Loading lesson…