Choose the correct query/queries that will give the following output: Name Harit Kritika

Question

Consider the Table EMPLOYEE given below:

Name	Zone	Age	Dept
Harit	West	28	10
Kritika	Centre	30	10
Naveen	East	40	20
Uday	North	38	30
Nupur	East	24	20
Moksh	South	28	10
Shelly	North	24	30

Choose the correct query/queries that will give the following output:

Name

Harit

Kritika

Moksh

1. Select Name from EMPLOYEE where DEPT in (10); 

2. Select Name from EMPLOYEE where AGE between 25 and 30; 

3. Select Name from EMPLOYEE where NAME like “i%”; 

4. Select Name from EMPLOYEE where ZONE in (“West”, “Centre”, ”South”);

Choose the correct option 

a. Only (i) 

b. Both (i) and (ii) 

c. Both (ii) and (iv) 

d. All (i), (ii) and (iv)

Answer 1

Correct option: d. All (i), (ii) and (iv)