Quiz for ORDER BY Clause

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

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

Q2: What is the purpose of the ORDER BY clause?

A. To group rows B. To filter rows C. To sort rows D. To join tables

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

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

Q4: Which keyword is used for descending order in ORDER BY?

A. DESC B. ASC C. DOWN D. ORDER DESC

Q5: Can you order results by multiple columns in SQL?

A. No B. Only two columns C. Yes D. Only primary key columns

Q6: Which clause must ORDER BY appear after?

A. FROM B. WHERE C. SELECT D. GROUP BY

Q7: What does ORDER BY 1 mean?

A. Order by first column name alphabetically B. Order by column at index 1 C. Order by column value "1" D. It has no meaning

Q8: How do you sort a result set by salary descending then name ascending?

A. ORDER BY salary ASC, name DESC B. ORDER BY salary, name ASC C. ORDER BY salary DESC, name ASC D. ORDER BY salary, name

Q9: Which of the following clauses is optional in a SELECT query?

A. FROM B. ORDER BY C. SELECT D. WHERE

Q10: Can you use aliases in ORDER BY clause?

A. No B. Yes C. Only in subqueries D. Only in joins

Q11: Which SQL query is valid to sort employees by department?

A. SELECT * FROM employees ORDER department; B. SELECT * FROM employees ORDER BY department; C. SELECT * ORDER BY department FROM employees; D. SELECT * FROM employees SORT BY department;

Q12: What happens if you specify ORDER BY on a column not in SELECT?

A. It gives error B. It is ignored C. It works fine D. Depends on DBMS

Q13: Which SQL clause is used to sort query results?

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

Q14: Can ORDER BY sort numeric and text data together?

A. Yes B. No C. Only text D. Only numbers

Q15: How to sort NULL values last in ascending order?

A. ORDER BY column DESC NULLS LAST B. ORDER BY column ASC C. ORDER BY column ASC NULLS LAST D. ORDER BY column DESC

Q16: What does this query do? SELECT name FROM students ORDER BY age DESC;

A. Lists students sorted by name B. Lists students sorted by age descending C. Lists students randomly D. Lists students with youngest first

Q17: Which clause comes first, ORDER BY or LIMIT?

A. LIMIT B. ORDER BY C. Doesn’t matter D. Depends on DBMS

Q18: What is the correct order of SQL clauses in SELECT query?

A. FROM > SELECT > ORDER BY B. SELECT > FROM > ORDER BY C. SELECT > ORDER BY > FROM D. ORDER BY > SELECT > FROM

Q19: Can you sort by an expression in ORDER BY?

A. Yes B. No C. Only if indexed D. Only if numeric

Q20: What does ORDER BY LENGTH(name) do?

A. Orders by name in descending order B. Orders by name alphabetically C. Orders by length of the name D. Orders by ASCII value of name

Q21: Is ORDER BY case-sensitive?

A. Yes B. No C. Only for text D. Only for numbers