Which SQL clause is used to sort the result set?
Anonymous Quiz
53%
ORDER BY
34%
SORT
4%
LIMIT
10%
GROUP BY
Q. Which SQL function is used to calculate the average value?
Anonymous Quiz
5%
SUM ()
5%
COUNT ()
1%
MIN ()
90%
AVG ()
Which clause is used to filter grouped data?
Anonymous Quiz
8%
WHERE
61%
GROUP BY
28%
HAVING
3%
ORDER BY
Which SQL function is used to convert text into uppercase?
Anonymous Quiz
1%
LOWER ()
94%
UPPER ()
3%
CAPITAL ()
2%
CONVERT ()
Which function is used to get the current date in SQL?
Anonymous Quiz
31%
GETDATE()
12%
TODAY()
43%
CURRENT_DATE
15%
NOWDATE()
Q. Which JOIN returns only matching records from both tables?
Anonymous Quiz
8%
LEFT JOIN
76%
INNER JOIN
16%
FULL JOIN
0%
RIGHT JOIN
Q. Which JOIN is used to join a table with itself?
Anonymous Poll
6%
FULL JOIN
79%
SELF JOIN
14%
INNER JOIN
1%
LEFT JOIN
What is a subquery?
Anonymous Quiz
2%
Query outside database
92%
Query inside another query
4%
Query without table
2%
Query with join
What does a SQL function return?
Anonymous Quiz
34%
Multiple rows
33%
Single value
5%
Nothing
27%
Table