Relational databases and SQL

Question 1 of 10

Which clause filters records in a SELECT query?

Question 2 of 10

Why is a phone number usually stored as text (VARCHAR) rather than a number?

Question 3 of 10

Explain the three types of relationship in a relational database, with an example of each from a school.

Question 4 of 10

The SQL statement used to add a record is INSERT ___.

Question 5 of 10

The SQL keyword LIKE 'A%' finds values that

Question 6 of 10

A foreign key links one table to another.

Question 7 of 10

Explain the difference between DELETE FROM Students; and DROP TABLE Students;.

Question 8 of 10

The overall design of a database, showing its tables, fields, data types and relationships, is the

Question 9 of 10

Which data type is best for a student's date of birth?

Question 10 of 10

SELECT COUNT(*) FROM Pupils returns