Databases and SQL

Which SQL command retrieves data?

• 1 DELETE
• 2 UPDATE
• 3 SELECT
• 4 INSERT

Which SQL command adds a new row?

• 1 DROP
• 2 INSERT
• 3 SELECT
• 4 ALTER

The clause used to filter rows in SQL is:

• 1 WHERE
• 2 GROUP
• 3 ORDER
• 4 FROM

A foreign key is used to:

• 1 Hide data
• 2 Sort rows
• 3 Delete a table
• 4 Link two tables

Which clause sorts the result of a query?

• 1 JOIN
• 2 WHERE
• 3 HAVING
• 4 ORDER BY

Removing repeated data from tables is called:

• 1 Backup
• 2 Compilation
• 3 Normalisation
• 4 Formatting