Database Systems Quiz

What is a database?

• A hardware component of a computer

• A type of software for word processing

• A collection of data and relationships between them

• A programming language

Answer explanation

A database is defined as a collection of data and the relationships between them, allowing for efficient storage, retrieval, and management of information. The other options do not accurately describe what a database is.

Which of the following is a component of a database in Microsoft Access?

• Presentation

• Table

• Spreadsheet

• Document

Answer explanation

In Microsoft Access, a Table is a fundamental component used to store data in a structured format. Unlike Presentation, Spreadsheet, or Document, which are not specific to Access, Tables are essential for database functionality.

What does a primary key do in a database table?

• It creates hyperlinks

• It uniquely identifies each record

• It stores images

• It formats text

Answer explanation

A primary key in a database table uniquely identifies each record, ensuring that no two records have the same key value. This is essential for maintaining data integrity and enabling efficient data retrieval.

Which data type is used for monetary values in Access?

• Boolean

• Currency

• Text

• Numeric

Answer explanation

The Currency data type in Access is specifically designed to store monetary values, allowing for accurate calculations and formatting. Other types like Boolean, Text, and Numeric do not provide the same precision for financial data.

What is the purpose of a query in a database?

• To format text

• To create new tables

• To provide a custom view of data

• To delete records

Answer explanation

A query in a database is used to retrieve and present data in a specific format, allowing users to view customized data sets based on their needs. Thus, the correct answer is 'To provide a custom view of data'.

What type of relationship allows one record in table A to correspond to many records in table B?

• Many-to-many

• One-to-one

• One-to-many

• None

Answer explanation

A one-to-many relationship allows a single record in table A to be linked to multiple records in table B. This is the correct choice, as it directly describes the scenario where one entity relates to many others.

In Microsoft Access, what is a form primarily used for?

• Running queries

• Data input and display

• Formatting text

• Creating tables

Answer explanation

In Microsoft Access, a form is primarily used for data input and display, allowing users to enter, view, and manage data easily. This makes it the correct choice over running queries, formatting text, or creating tables.

What is the function of the Lookup Wizard in Access?

• To delete records

• To impose restrictions on field values

• To create new tables

• To format data

Answer explanation

The Lookup Wizard in Access is used to impose restrictions on field values by allowing users to select from a predefined list, ensuring data integrity and consistency in the database.

Which of the following is NOT a type of field in Access?

• Text

• Counter

• Boolean

• Image

Answer explanation

In Access, common field types include Text, Counter, and Boolean. However, 'Image' is not a standard field type in Access, making it the correct answer to the question.

What is the purpose of the 'Design mode' in Access?

• To define the structure of tables

• To format text

• To enter data

• To run queries

Answer explanation

The 'Design mode' in Access is used to define the structure of tables, allowing users to create and modify fields, data types, and relationships, which is essential for organizing data effectively.