SQL Quiz for Beginners Part 1 - to Test Analysis Skills

Q1: Which SQL statement is used to extract data from a database?

(a) GET
(b) SELECT
(c) EXTRACT
(d) OPEN

Q2: Which clause is used to filter the records returned by a SELECT query?

(a) ORDER BY
(b) GROUP BY
(c) WHERE
(d) HAVING

Q3: Which function returns the number of rows in a result set?

(a) SUM()
(b) COUNT()
(c) NUMBER()
(d) TOTAL()

Q4: What is the default sorting order in SQL when using ORDER BY?

(a) Descending
(b) Random
(c) No Order
(d) Ascending

Q5: Which SQL clause is used to group rows sharing a property so aggregate functions can be applied?

(a) ORDER BY
(b) GROUP BY
(c) UNION
(d) JOIN

Q6: What does the SQL INNER JOIN do?

(a) Returns unmatched rows from both tables
(b) Returns rows only from the left table
(c) Returns only matching rows from both tables
(d) Returns duplicate rows

Q7: Which keyword is used to eliminate duplicate records in a SELECT statement?

(a) DISTINCT
(b) UNIQUE
(c) FILTER
(d) ONLY

Q8: Which of the following is a DDL command?

(a) INSERT
(b) UPDATE
(c) CREATE
(d) SELECT

Q9: What will the following query return? SELECT MAX(salary) FROM employees;

(a) The sum of all salaries
(b) The lowest salary
(c) The average salary
(d) The highest salary

Q10: Which SQL keyword is used to sort results in descending order?

(a) ASC
(b) DOWN
(c) DESC
(d) SORT