S4 Database Lesson 1

Multiple Choice

Which if the following would be an end-user requirement of a database?

• Limited access for users
• User-friendly query interface
• Complex data structure
• High maintenance cost

Multiple Choice

Which of the following would be functional requirement of a database?

• Backup and recovery procedures
• Data encryption methods
• CRUD operations (Create, Read, Update, Delete)
• User interface design

Fill in the Blanks

State 1 requirement of GDPR for a company storing customer details.

Match

Match the following

• Stores all the data in a structured format

• Represents a single piece of data about a single person or item

• Collection of related data entries for a single person or item

• Software for managing databases

Database File

Database Field

database record

Database Management System

• Database File

• Database Field

• database record

• Database Management System

Multiple Choice

Which data type is best suited to storing data that involves a formulae?

• Number

• Text

• Calculated

Match

Match the following

• check that data has been entered into the field

• can only seelect form a given list of values

• ensures data entered is of the correct size

• checks data entered is between set limits

Presence Check

Restricted Choice

Length Check

Range Check

• Presence Check

• Restricted Choice

• Length Check

• Range Check

Multiple Choice

What is a foreign key in a database?

• A foreign key is a unique identifier for a record in the same table.
• A foreign key is a type of index that speeds up database queries.
• A foreign key is a field in a database table that links to the primary key of another table.
• A foreign key is a field that stores images in a database.

Multiple Choice

What is a primary key in a database?

• A primary key is a unique identifier for a record in a database.
• A primary key is used to store large amounts of data in a database.
• A primary key can have duplicate values in a database.
• A primary key is a type of foreign key in a database.

Multiple Choice

Whoch of the following would be a complex sort on a database about products a shop sells?

• Sorting by category, then by price, then by product name.
• Sorting by price.

• Sorting by product name alphabetically.
• Sorting by stock quantity in descending order.

Multiple Choice

Which of the following would be an example of a complex search on a database about pupils in a school?

• Searching for pupils in S4

• Finding pupils in S4 with an attendance above 90%

• Finding pupils with an attendance less than 70%

• Listing all pupils in the school