Question

Consider the table STUDENT given below:

RollNo	Name	Class	DOB	Gender	City	Marks
1	Anand	XI	6/6/97	M	Agra	430
2	Chetan	XII	7/5/94	M	Mumbai	460
3	Geet	XI	6/5/97	F	Agra	470
4	Preeti	XII	8/8/95	F	Mumbai	492
5	Saniyal	XII	8/10/95	M	Delhi	360
6	Maakhiy	XI	12/12/94	F	Dubai	256
7	Neha	X	8/12/95	F	Moscow	324
8	Nishant	X	12/6/95	M	Moscow	429

State the command that will give the output as:

Name

Anand

Chetan

Geet

Preeti

(i) select Name from student where Class ='XI' and Class='XII';

(ii) select name from student where not Class='XI' and Class='XII';

(iii) select name from student where City="Agra" or City="Mumbai";

(iv) select name from student where City in("Agra", "Mumbai");

Choose the correct option:

Options

• Both (i) and (ii)

• Both (iii) and (iv)

• Any of the options (i), (ii) and (iv)

• Only (iii)

Answer 1

Both (iii) and (iv)

Explanation:

The IN condition (sometimes called the IN operator) allows you to easily test if an expression matches any value in a list of values.