Database Concepts Quiz

What is a key field in a database?

• A field that stores the largest value

• A unique identifier for each record

• A field that stores text data

• A field that stores date and time

Which of the following is an example of a primary key?

• Student candidate number

• Student name

• Student address

• Student age

What is a foreign key?

• A key that is used to encrypt data

• A primary key from one table that appears in another table to link the two together

• A key that is used to delete records

• A key that is used to update records

What is the purpose of a data dictionary?

• To store large amounts of data

• To decide what data is going to be stored in each table of a database

• To delete unnecessary data

• To encrypt data

How do data dictionaries help ensure data integrity and consistency?

• By deleting old data

• By defining data types, constraints, and relationships

• By storing data in multiple locations

• By encrypting data

Which of the following is NOT a reason for manual data entry mistakes?

• Misreading the original data

• Input error with long codes

• Transposition error

• Automatic data validation

What is a transposition error?

• When data is omitted or excluded

• When two characters are accidentally swapped

• When data is lost or damaged

• When data is encrypted incorrectly

What is the purpose of validation in a computerised system?

• To ensure the data entered is accurate

• To ensure the data entered is sensible and reasonable

• To correct any errors in the data entered

• To check the speed of data entry

What does validation NOT check in a computerised system?

• Sensibility of data

• Reasonableness of data

• Accuracy of data

• Format of data