Class 12: SQL Question Set 2

1.
which of the following is not an aggregate function?

a) AVG
b) Sum
c) With
d) Min

 

 

2.
Which of the following is an aggregate function?

a) LEFT
b) AVG
c) JOIN
d) LEN

3.
Whcih of the following fucntion ignore null values?

a) Max
b) Sum
c) Count
d) All of them

 

 

4.
Which SQL function is used to count the number of rows in a SQL query?

a) Count()
b) Sum()
c) Number()
d) Count(*)

5.
In SQL which command is used to select only one copy of each set of duplicate rows?

a) Select Differrent
b) Select Unique
c) Select Distinct
d) All

Number Of Visitors

0125683