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:

Command to select all Science students from the table STUDENT

Options

• SELECT * FROM STUDENT

• SELECT STREAM FROM STUDENT WHERE STREAM = 'Science'

• SELECT * FROM STUDENT WHERE STREAM = 'Science'

• SELECT NAME FROM STUDENT WHERE STREAM = 'Science'

Answer 1

SELECT * FROM STUDENT WHERE STREAM = 'Science'

Explanation:

SELECT command helps you make queries on the database.