Class 12: SQL Question Set 2

6.
Aggregate fucntions can be used in the select list of _________ clause of a select statement. They cannot be used in a ________ clause.

a) Where, having
b) Having, Where
c) Group by, having
d) Group by, where

 

7.
SQL supplies conditions on the groups through ________ clause after groups have been formed.

a) Group by
b) SELECT
c) Where
d) Having

 

8.
Which clause is used with aggregate functions?

a) Group by
b) SELECT
c) Where
d) both a and c

 

9.
What is the meaning of HAVING clause in select query?

a) To filter out the summary groups
b) To filter out the column groups
c) To filter out the row and column values
d) None of the mentioned

 

10.
WHERE and HAVING clause can be used interchangeably in SELECT queries?

a) True
b) False
c) Only in views
c) with order by

Number Of Visitors

0173215