Computing

Question 1

1The SQL function that counts records is ___.

Medium

Your answer (fill in the blank)

Question 2

2A foreign key is

Medium

A. the first field in a table B. a password C. a key from another country D. a field in one table that refers to the primary key of another table

Question 3

3A many-to-many relationship between Students and Clubs is usually resolved by

Easy

A. deleting one table B. making both keys text C. adding a linking table such as Membership(StudentID, ClubID) D. using one big table

Question 4

4Referential integrity means

Hard

A. tables have no keys B. all fields are text C. data is encrypted D. a foreign key must match an existing primary key

Question 5

5Normalisation is the process of

Hard

A. encrypting the database B. deleting all data C. making tables bigger D. organising tables to reduce redundancy and improve integrity

Question 6

6SELECT COUNT(*) FROM Pupils returns

Medium

A. the first record B. the number of records in Pupils C. all pupils' names D. the table structure

Question 7

7Which SQL statement changes existing data?

Medium

A. SELECT B. INSERT C. ALTER only D. UPDATE

Question 8

8A foreign key links one table to another.

Easy

A. True B. False

Question 9

9Which query lists pupils older than 16, youngest first?

Hard

A. SELECT * FROM Pupils WHERE Age > 16 ORDER BY Age ASC B. SELECT * FROM Pupils ORDER BY Age > 16 C. SELECT Age > 16 FROM Pupils D. FIND Pupils WHERE Age > 16

Question 10

10In a relational database, data is stored in

Easy

A. a spreadsheet chart B. a single text file C. tables (relations) linked by keys D. a stack