Reema wants to display names of those students who have not been assigned any stream. Help her select the correct query:

Question

Consider a table ‘SCORE’:

ROLLNO	NAME	STREAM	OPTIONAL
1	Greesha	Science	10
2	Satish	Commerce	30
3	Teena	NULL	20
4	Yasmine	Humanities	10
5	Yashika	Science	10
6	Lalit	Humanities	20

Reema wants to display names of those students who have not been assigned any stream. Help her select the correct query:

a. Select name from SCORE where stream = NULL;

b. Select name from SCORE where stream =null; 

c. Select name from SCORE where stream = “ “; 

d. Select name from SCORE where stream is NULL;

Answer 1

Correct option: d. Select name from SCORE where stream is NULL;