Quiz for Sorting with ORDER BY

Q1: Which SQL keyword is used to sort the result set?

A. GROUP BY B. SORT BY C. ORDER BY D. ARRANGE BY

Q2: Which clause is used to sort the result set in SQL?

A. GROUP BY B. ORDER BY C. SORT BY D. FILTER BY

Q3: What is the default sorting order of ORDER BY?

A. Ascending B. Descending C. Random D. Grouped

Q4: How do you sort the result in descending order?

A. ORDER BY column_name DESC B. SORT BY column_name ASC C. ORDER DESC column_name D. GROUP BY column_name DESC

Q5: Which keyword is used to sort by multiple columns?

A. BY B. THEN C. ORDER D. ORDER BY

Q6: What happens if you use ORDER BY on a non-selected column?

A. Error is thrown B. Only selected columns are allowed C. It still works D. Query fails silently

Q7: Which of the following correctly sorts employees by salary and then by name?

A. ORDER BY salary, name B. SORT BY name, salary C. GROUP BY salary, name D. ORDER salary AND name

Q8: Which clause is compatible with ORDER BY for filtering rows?

A. WHERE B. LIMIT C. HAVING D. All of the above

Q9: What is the result of: SELECT * FROM students ORDER BY age DESC;

A. Students sorted by increasing age B. Students sorted by decreasing age C. All students removed D. Syntax error

Q10: How does SQL treat NULLs in ORDER BY?

A. Always last B. Always first C. Depends on DBMS D. Causes an error

Q11: Which of the following is a valid ORDER BY usage?

A. ORDER BY 1 DESC B. ORDER DESC BY name C. SORT name DESC D. ORDER name FROM employees

Q12: Can ORDER BY be used in subqueries?

A. No B. Only with GROUP BY C. Yes D. Only in MySQL

Q13: What will SELECT * FROM table ORDER BY 2 do?

A. Order by second column B. Throws an error C. Ignores ORDER BY D. Sorts by second row

Q14: Which is more efficient for sorting indexed columns?

A. ORDER BY B. GROUP BY C. JOIN D. HAVING

Q15: In which clause position should ORDER BY be used in a SQL query?

A. After SELECT B. After WHERE C. After GROUP BY D. Last in the query

Q16: Which sorting orders are valid in ORDER BY?

A. ASC and DESC B. UP and DOWN C. LOW and HIGH D. INC and DEC

Q17: What does ORDER BY salary DESC, name ASC do?

A. Sorts only by salary B. Sorts by name then salary C. Sorts by salary descending and name ascending D. Throws an error

Q18: Which is the default order when ORDER BY is used without specifying ASC or DESC?

A. DESC B. ASC C. None D. Depends on RDBMS

Q19: What will happen with ORDER BY salary NULLS FIRST?

A. NULLs appear at top B. NULLs appear at bottom C. Error D. Ignores NULLs

Q20: Which RDBMS allows ORDER BY in CTE (Common Table Expression)?

A. MySQL B. PostgreSQL C. SQL Server D. All of the above