Quiz for SELECT Basics

Q1: Which SQL command is used to retrieve data from a database?

A. FETCH B. SELECT C. EXTRACT D. GET

Q2: Which keyword is used to retrieve all columns from a table?

A. * B. ALL C. EVERY D. COLUMNS

Q3: What is the result of SELECT 5 + 3;

A. 8 B. 53 C. Error D. Null

Q4: Which clause is used to filter rows?

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

Q5: How do you select unique values in a column?

A. SELECT DISTINCT B. SELECT UNIQUE C. SELECT DIFFERENT D. SELECT ONLY

Q6: What is the purpose of the FROM clause?

A. To filter rows B. To sort data C. To specify table D. To join tables

Q7: Which operator is used to combine multiple conditions?

A. == B. != C. AND D. EQ

Q8: What does LIMIT 5 do in a SELECT statement?

A. Limits columns B. Limits rows to 5 C. Limits tables D. Limits queries per second

Q9: What will SELECT NULL + 1 return?

A. 1 B. NULL C. Error D. 0

Q10: How can you rename a column in the SELECT output?

A. RENAME B. REPLACE C. AS D. ALIAS

Q11: Which clause is used to sort the result set?

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

Q12: Which SQL function counts the number of rows?

A. SUM() B. AVG() C. COUNT() D. TOTAL()

Q13: How do you select rows where age is greater than 30?

A. WHERE age > 30 B. WHERE age < 30 C. WHERE age = 30 D. WHERE age >= 30

Q14: Which of the following is a valid SQL comment?

A. -- comment B. // comment C. # comment D. /* comment */

Q15: What keyword is used to remove duplicate rows?

A. DISTINCT B. UNIQUE C. FILTER D. REMOVE

Q16: Which clause is evaluated first in SELECT?

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

Q17: Which clause is used for conditional filtering after grouping?

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

Q18: Which SQL keyword returns records matching one of many values?

A. BETWEEN B. IN C. LIKE D. OR

Q19: What will SELECT LENGTH("SQL") return?

A. 2 B. 3 C. 4 D. 5