Which command is used to remove a relation | UGC NET

UGC NET 2018 : 

________  command is used to remove a  relation from an SQL database.  

(a) Remove table 

(b) Delete table  

(c) Update table 

(d) Drop table 

Solution:

The drop table command is used to delete a table and all rows in the table. 

DROP TABLE student;

The DELETE statement is used to delete existing records in a table.

DELETE FROM Student WHERE Name= 'Kunal';

The UPDATE statement is used to modify the existing records in a table.

UPDATE Student

SET Name = 'Kunal', City= 'Burhanpur'

WHERE RollNumber= 1201;