0 of 15 Questions completed
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 15 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
What does the distinct keyword return?
What does an “in” operator do?
BETWEEN operator selects values within a given range
What is the functionality of the count function?
What is the functionality of AVG function?
What is the function of the sum function?
Aggregate functions such as SUM, COUNT, AVG, MAX, and MIN exclude NULL values.
What does the “as” keyword do?
“order by” keyword is used to sort the result
“order by” keyword
“group by” keyword
The HAVING Clause enables you to specify conditions that filter which group results appear in the results
GROUP BY statement sort the result-set in ascending or descending order
The ORDER BY keyword sorts the records in ascending order by default