National 5 Computing - Databases - Implementation

Which of the following is a valid data type in Access?

• Text

• Image

• Audio

• Video

Complete the data dictionary.

• A= Primary Key, B=Foreign Key, C=Boolean, D=True/False

• A= Foreign Key, B=Primary Key, C=Boolean, D=Restricted Choice

• A= Primary Key, B=Foreign Key, C=Text, D=Boolean

• A= Primary Key, B=Foreign Key, C=Boolean, D=Restricted Choice

Reorder the following

• FROM

• SELECT

• WHERE

• ORDER BY

what characters is used as a wildcard in Access to represent unknown values?

• %

• ?

• *

• /

Place the correct label next to the graphic.

b

d

ORDER BY number DESC

ORDER BY number DASC

ORDER BY number ASD

ORDER BY number ASC

Complete the SQL statement to produce the output shown in the table.

Complete the SQL to display the surname, town and street of all the customers who live in Port Glasgow

Customer Jack Shields who lives at 5 Brookside Close has mistakenly entered his address as 4 Brookside Close. Complete the SQL statement to update this record.

• 
• 
• 
• 

Which of the following SQL ORDER BY clauses would produce the records sorted in the order shown above.

• ORDER BY lastname ASC, schoolname ASC;

• ORDER BY firstname ASC, schoolname ASC;

• ORDER BY schoolname ASC, lastname ASC;

• ORDER BY schoolname ASC, firstname ASC;