Relational databases and SQL

Question 1 of 10

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

Question 2 of 10

Write SQL to create a table Pupils with fields PupilID (primary key), Name, Class and Age.

Question 3 of 10

Normalisation reduces data redundancy.

Question 4 of 10

A field that refers to the primary key of another table is a ___ key.

Question 5 of 10

A one-to-many relationship exists between Class and Pupil when

Question 6 of 10

Write an SQL query to list each pupil's name with their class teacher, using Pupils(PupilID, Name, ClassID) and Classes(ClassID, Teacher).

Question 7 of 10

GROUP BY is used with aggregate functions to

Question 8 of 10

Referential integrity means

Question 9 of 10

Which SQL statement removes records?

Question 10 of 10

Which query lists pupils older than 16, youngest first?