Which of the following will be the correct SQL command to add a new column…
2023
Which of the following will be the correct SQL command to add a new column FEES in a table TEACHER?
- A.
ALTER TABLE TEACHER
ADD COLUMN FEES FLOAТ; - B.
ADD COLUMN FEES FLOAT
INTO TEACHER; - C.
UPDATE TEACHER
ADD COLUMN FEES FLOAT; - D.
INSERT INTO TEACHER
ADD COLUMN FEES FLOAT;
Attempted by 1862 students.
Show answer & explanation
Correct answer: A
To add a new column FEES to an existing table TEACHER, use the ALTER TABLE command. Correct SQL command is: ALTER TABLE TEACHER ADD COLUMN FEES FLOAT; ALTER TABLE → used to modify the table structure (schema).
A video solution is available for this question — log in and enroll to watch it.