WorksheetsXII CSc-Qiz20ii
Total questions: 10
Worksheet time: 20mins
Name
Class
Date
1.
How many clauses are there innSQL?
a)
5
b)
4
c)
3
d)
2
2.
Distinct clause is helpful to avoid ______ values
a)
duplicate
b)
same
c)
unique
d)
different
3.
Distinct keyword fetches only __________ values
a)
unique
b)
different
c)
same
d)
dulplicate
4.
WHERE clause is used to fulfill ______ condition
a)
all
b)
specified
c)
one
d)
two
5.
The __________ clause groups records into summary rows
a)
GROUP BY
b)
ORDER BY
c)
HAVING
d)
SELECT
6.
COUNT is an _________ function
a)
aggregate
b)
recursive
c)
normal
7.
_________ clause is used to sort the data
a)
ORDER BY
b)
GROUP BY
c)
HAVING
d)
WHERE
8.
By default _______ order is used in program
a)
ascending
b)
descending
9.
Having clause is used to _______ data based on group functions
a)
filter
b)
separate
c)
same
d)
order
10.
Group functions cannot be used in ________ clause
a)
WHERE
b)
HAVING
c)
ORDER BY
d)
DISTINCT
100 %
