End of Term Assessment - Database

What is the main advantage of using a relational database instead of a flat-file database?

• Increases storage size

• Reduces data redundancy

• Makes data entry harder

• Eliminates the need for data validation

In a relational database, what ensures that records in different tables are correctly linked?

• Data types

• Primary keys and foreign keys

• Table views

• Queries

Which of the following best describes a primary key?

• A field that can store multiple values

• A field that links to another table

• A unique identifier for each record

• A special type of data format

What problem does a flat-file database often encounter?

• Faster processing speed

• Data redundancy

• More efficient searches

• Ability to store large amounts of data

Which of the following is NOT a component of a database table?

• Records

• Fields

• Queries

• Tables

Which relationship type allows one record in a table to link to multiple records in another table?

• One-to-One

• One-to-Many

• Many-to-One

• Independent

What is the purpose of a foreign key in a database?

• It uniquely identifies a record in a table

• It links a record to another table

• It ensures data integrity in a single table

• It is a backup of the primary key

Which of these database objects is used to enter, modify, and view data easily?

• Tables

• Queries

• Forms

• Reports

What is the primary function of queries in MS Access?

• Store raw data

• Retrieve and manipulate specific data

• Create reports

• Enter data

Which SQL keyword is used to retrieve specific fields from a database table?

• RETRIEVE

• FIND

• SELECT

• SORT