Class 12: SQL Question Set 1

16.
The keyword used with SELECT command to display unique value of any column is

a) All
b) From
c) Distinct
d) Unique

 

17.
The keyword used with SELECT command to display all values of any column is

a) All
b) From
c) Distinct
d) Unique

 

18.
________ clause must be added with keyword _____ to display the fields given in the select list as per given condition

a) where having
b) select from
c) where from
d) where select

 

19.
Which operator performs pattern matching?

a) Between
b) IN
c) Like
d) None

 

20.
Which operator checks for null value?

a) Exists
b) IS
c) Not
d) None.