Computing Y9 Level 9

Which of the following BEST defines a 'record' in a database?

• A column that holds similar data types

• A unique identifier for a form

• A row containing related fields for one item

• A table storing all data

What is the MAIN purpose of a primary key in a database?

• To allow duplication of fields

• To link unrelated tables

• To ensure each record is uniquely identified

• To determine field data type

In a school database, which of the following is the LEAST appropriate field to use as a primary key?

• Admission Number

• Student ID

• First Name

• Email Address

Which statement about ‘fields’ is MOST accurate?

• Each field must hold all types of data

• A field represents a category of data in a table

• Fields are always numerical

• Fields are only used in reports

What is the correct relationship between a table, field, and record?

• Fields contain tables, which contain records

• A table contains fields, and each record contains tables

• A table contains records, and each record contains fields

• A field contains records, and each record is a table

Which of the following is a valid reason for using a form in a database?

• To create relationships between tables

• To secure data through encryption

• To simplify and control data entry

• To design the structure of tables

A Boolean data type is MOST suitable for which of the following fields?

• Age of student

• Date of birth

• Has paid fees (Yes/No)

• Student’s full name

Which of these fields is MOST appropriate to use an ‘alphanumeric’ data type?

• Grade (A, B, C)

• Student’s name

• Shoe size

• Number of absences

Which of the following is TRUE about a flat-file database?

• It stores data across multiple linked tables

• It has a higher level of data security

• It stores all data in one table

• It can only store Boolean values

What happens if data types are incorrectly set up in a table?

• The form layout improves

• Relationships are automatically fixed

• Errors may occur during data entry

• The primary key is ignored