Quiz: Say “Hello” to the Table

Test your SQL basics with this beginner-friendly quiz on SELECT.

We'll cover the following

In the last lesson, you wrote your very first SQL query! You learned how to use SELECT * FROM to retrieve all rows and columns from a table—in this case, the people table. You also learned that SQL is case-insensitive and that * is a wildcard that means “everything.”

Let’s check your understanding with a quick quiz.

1

What does the SQL query SELECT * FROM people do?

A)

Adds a new person to the people table

B)

Displays all rows and columns from the people table

C)

Selects only the ID column from the people table

Question 1 of 30 attempted

Well done! You’ve just learned one of the most fundamental SQL commands—SELECT *. Now you can read full tables with just a single line of code.

What’s next?

Now it’s time to put your skills into practice with a hands-on project! In this, you’ll:

  • Query a second table called pets.

  • Use the SELECT * FROM pets command to display all rows and columns.

  • View details like pet names, types, and ages.

Let’s see what data your next table holds!