Free Test SELECT Statement – SQL

Q1: What does the SELECT statement do in SQL?

A. Deletes data B. Updates rows C. Retrieves data D. Creates table

Q2: Which keyword is used to eliminate duplicate values in a SELECT query?

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

Q3: How can you select all columns from a table?

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

Q4: Which clause is used to filter records in SELECT?

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

Q5: Which of the following is a valid SELECT query?

A. SELECT name age FROM students; B. SELECT name, age FROM students; C. SELECT FROM students; D. SELECT name FROM;

Q6: What is the result of SELECT 2+2?

A. Error B. 2 C. 4 D. 22

Q7: What does SELECT NOW(); return?

A. Current Date B. Current Time C. Current Date and Time D. Nothing

Q8: Which function returns the number of records in a table?

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

Q9: How can you rename a column in SELECT output?

A. RENAME B. AS C. WITH D. CALL

Q10: Which operator checks for pattern matching?

A. = B. LIKE C. IN D. IS

Q11: Which wildcard represents any number of characters in SQL?

A. _ B. % C. * D. #

Q12: Which clause is used to group rows?

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

Q13: Which statement returns the current date?

A. GETDATE() B. TODAY() C. CURRENT_DATE() D. DATE()

Q14: Which clause is used to limit number of rows returned?

A. STOP B. TOP C. LIMIT D. ROWNUM

Q15: Which SQL keyword is used to combine rows from two queries?

A. JOIN B. UNION C. MERGE D. CONNECT

Q16: Which function returns the maximum value of a column?

A. MAX() B. HIGH() C. TOP() D. LARGEST()

Q17: What does SELECT LENGTH('SQL') return?

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

Q18: What is the primary purpose of the SELECT statement in SQL?

A. To update records B. To delete records C. To retrieve records D. To insert records

Q19: Which keyword is used to remove duplicate records in a SELECT query?

A. UNIQUE B. REMOVE C. DISTINCT D. NO DUPLICATE

Q20: What does SELECT * do in SQL?

A. Selects all columns from a table B. Selects only unique rows C. Selects all tables D. Deletes all rows

Q21: Which clause in a SELECT statement filters the rows returned?

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

Q22: How do you rename a column in the SELECT statement?

A. Using AS keyword B. Using RENAME keyword C. Using CHANGE keyword D. Using UPDATE keyword

Q23: Which SQL clause sorts the result set of a SELECT query?

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

Q24: What is the default sort order of ORDER BY clause?

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

Q25: What is used to limit the number of rows returned in a query?

A. TOP B. LIMIT C. ROWNUM D. All of the above

Q26: Which clause is used to group rows in a SELECT query?

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

Q27: Which clause is used to filter groups in SQL?

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

Q28: Which keyword combines rows from two or more tables?

A. JOIN B. MERGE C. GROUP D. APPEND

Q29: What does the alias do in SQL SELECT statement?

A. Deletes table B. Renames column or table temporarily C. Encrypts data D. None of the above

Q30: Which character is used for wildcard matching in LIKE clause?

A. % B. # C. * D. $

Q31: How to select distinct department names from a table?

A. SELECT ALL department FROM emp; B. SELECT DISTINCT department FROM emp; C. SELECT department FROM emp WHERE UNIQUE; D. SELECT department UNIQUE FROM emp;

Q32: Which function returns the number of rows in a SELECT query?