Back to articles list Articles Cookbook
12 minutes read

SQL Quiz

Want to quickly check your SQL skills? Take this short quiz and get immediate results, together with advice on your future learning path!

Want to quickly check your SQL skills? Our SQL Quiz is tailored just for you! It's a great way to verify your current knowledge and identify areas for improvement.

If you want a more thorough test for your skills – including advanced topics like reports, window functions and much more – check out our free SQL Skill Assessment. If you pass the assessment, you will get a certificate at the end!

Ready for a challenge? We have 25 questions to test your knowledge of basic SQL syntax and functions. You can take as much time as you need to solve each problem. You will get immediate feedback after you are done with the quiz, together with some further study recommendations. And if you want to enhance your skills after taking this quiz, our SQL Basics course is the perfect next step.

Let’s begin!

Question 1

How do you select all the data from a table?

Question 2

How do you select specific columns from a table?

Question 3

How do you sort data by date so that the most recent dates appear first?

Question 4

What operator do you use to filter records for meeting any of several conditions?

Question 5

What operator do you use to filter records for meeting all conditions?

Question 6

What will this expression return?

‘John Doe’ != NULL

Question 7

How do you filter for string values that begin with the letter 'a'? Select all that apply.

Question 8

Which of the following queries sorts the results by name in descending order?

Question 9

Which is not a valid type of JOIN?

Question 10

What type of JOIN will select all data from both tables, even if some rows in either table don’t have a match?

Question 11

Which of the following is a valid join condition? Select all that apply.

Question 12

How do you define an alias for a table? Select all that apply.

Question 13

In which statements can you use aggregate functions? Select all that apply.

Question 14

Select all true statements about how MIN() and MAX() compare different data types.

Question 15

How do you count non-null values in a column? Select all that apply.

Question 16

How do you group for each unique combination of column1 and column2? Select all that apply.

Question 17

How do you filter the aggregated columns for each group?

Question 18

Which statement(s) change the data in the database? Select all that apply.

Question 19

How do you insert a row in a table? Select all that apply.

Question 20

How do you remove every row from the table?

Question 21

How do you increment the value of the price column by one in every row? Select all that apply.

Question 22

Which clauses can subqueries be used in? Select all that apply.

Question 23

What can a subquery return? Select all that apply.

Question 24

Which operator(s) will only return rows that match the WHERE condition for every row returned by the subquery? Select all that apply.

Question 25

Which of these are correlated subqueries? Select all that apply.

Congratulations – you’ve finished the quiz! Review your answers, then click Submit to get your result!