Interview prep
SQL interview questions
Joins, indexes, normalisation, transactions and query optimisation. Practise free with instant feedback, then test yourself in a timed exam.
Sample SQL questions
-
Q1
Which SQL command is used to retrieve data from a table?
- A DELETE
- B INSERT
- C SELECT
- D UPDATE
-
Q2
Which clause is used to filter records?
- A GROUP BY
- B WHERE
- C HAVING
- D ORDER BY
-
Q3
Which SQL statement retrieves all columns from a table?
- A SELECT column_name
- B GET ALL
- C SELECT *
- D SHOW TABLE
-
Q4
Which clause sorts query results?
- A GROUP BY
- B ORDER BY
- C HAVING
- D WHERE
-
Q5
Which keyword removes duplicate rows from query results?
- A PRIMARY
- B UNIQUE
- C DISTINCT
- D FILTER
Answers and explanations appear as you practise — take the free quiz to check yours.