Year11 - SQL Plenary Quiz

Quick recap of SELECT, FROM, WHERE, LIKE, ORDER BY and records/fields.

1. What does SQL stand for?

SQL stands for Structured Query Language.

2. In a database, a record is made up of...

Each record can contain a number of fields.

3. Which clause chooses what to return?

SELECT chooses the field(s) to be returned.

4. Which clause chooses the table?

FROM identifies which table to read.

5. What does * mean in SELECT *?

* means return all fields in the table.

6. What does WHERE name LIKE "A%" find?

A% is a wildcard pattern for values that begin with A.

7. Which query gets Germany's population?

This follows the lesson example: SELECT population FROM world WHERE name = "Germany".

8. What does ORDER BY name ASC do?

ASC sorts results in ascending order (A to Z or smallest to largest).

One Thing I Learned

Write one key idea you will remember from today’s lesson.