SQL bingo

Exercise and reference answers

Clues and terms

1. Clue

   The most popular query language for relational systems.

   Item

   SQL

2. Clue

   Statements that define, modify and delete schemas.

   Item

   DDL

3. Clue

   Insert, select, update and delete statements.

   Item

   DML

4. Clue

   A restriction on the values an attribute may hold.

   Item

   Constraint

5. Clue

   Forbids missing or unknown values in a column.

   Item

   NOT NULL

6. Clue

   Removes a table or database permanently.

   Item

   DROP

7. Clue

   Combines rows of two tables on a common field.

   Item

   Join

8. Clue

   COUNT, MAX, MIN, AVG and SUM belong here.

   Item

   Aggregate

9. Clue

   Takes one value and returns one value.

   Item

   Scalar

Instructions

Read each clue and tap the term it describes.

Explanation