Structured Query Language (SQL) · Class 12 · CBSE · Science Computer Science
Which SQL query correctly adds a column named Email to the STUDENT table?
Practice question from Structured Query Language (SQL) (Class 12 · CBSE · Science Computer Science), with the correct answer and a step-by-step solution.
easy · MCQ · Q-F2FF44
Which SQL query correctly adds a column named Email to the STUDENT table?
- A.ALTER TABLE STUDENT ADD COLUMN Email VARCHAR(50);Correct answer
- B.UPDATE STUDENT ADD Email VARCHAR(50);
- C.INSERT COLUMN Email VARCHAR(50) INTO STUDENT;
- D.MODIFY STUDENT ADD Email VARCHAR(50);
Solution
The ALTER TABLE command is used to modify the structure of an existing table. The ADD COLUMN clause adds the Email column with a VARCHAR(50) data type.
More from Structured Query Language (SQL)
- Which SQL query displays each different city name only once from the relation STUDENT?
- A relation named EMPLOYEE has the columns EmpID, Dept, and Salary. Which query displays the departments whose average salary is greater tha…
- A relation named STUDENT has the columns RollNo, Name, and Marks. Write an SQL query to display the Name and Marks of students whose Marks…
- A database has CUSTOMER(CustID, Name) and ORDERINFO(OrderID, CustID, Amount). Which query displays the names of customers who have not plac…
Practise more Computer Science
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed