Question

Case Based

Consider the table STUDENT with the following detail.

STU_ID	NAME	STREAM	MARKS	CLASS
1.	Aditya	Science	87.5	12A
2.	Vikram	Commerce	88.7	12B
3.	Astha	Humanities	76.8	12C
4.	Varsha	Science	79.5	12A
5.	Kanishka	Science	77.9	12A
6.	Anand	Commerce	86.7	12B

Now answer the question given below:

Delete records that belongs to 'Humanities' stream.

Options

• DELETE FROM STUDENT WHERE STREAM= 'Humanities' 

• DROP FROM STUDENT WHERE STREAM= 'Humanities'

• DROP TABLE STUDENT WHERE STREAM= 'Humanities'

• None of these

Answer 1

DELETE FROM STUDENT WHERE STREAM= 'Humanities'

Explanation:

To delete data from a table the SQL command DELETE is used.