Database Concepts Quiz

What is the primary purpose of a database?

• To store and manage structured data

• To browse the internet

• To create documents

• To edit images

Answer explanation

The primary purpose of a database is to store and manage structured data efficiently, allowing for easy retrieval, manipulation, and organization, which is essential for various applications.

Which of the following is an example of a field in a database table?

• A single row in a table

• A single column in a table

• A collection of records

• The relationship between two tables

Answer explanation

A field in a database table refers to a single column, which holds a specific type of data for each record. Therefore, the correct answer is 'A single column in a table', as it represents a distinct attribute of the records.

What is the role of a primary key in a database table?

• To store duplicate values

• To uniquely identify each record

• To delete unnecessary data

• To create a relationship between databases

Answer explanation

The primary key in a database table serves to uniquely identify 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 of the following data types is best suited for storing phone numbers?

• Numeric

• Text

• Currency

• Logical

Answer explanation

Phone numbers can include non-numeric characters like parentheses and hyphens, making 'Text' the best choice. 'Numeric' would limit input to digits only, which is not suitable for formatting phone numbers.

A relationship between two tables is established using which key?

• Primary Key

• Candidate Key

• Foreign Key

• Unique Key

Answer explanation

A relationship between two tables is established using a Foreign Key. The Foreign Key in one table points to the Primary Key in another, creating a link between the two tables.

Which of the following types of queries retrieves specific data from a database?

• Delete Query

• Select Query

• Append Query

• Make Table Query

Answer explanation

A Select Query is used to retrieve specific data from a database, allowing users to specify which columns and rows to return. In contrast, Delete, Append, and Make Table Queries serve different purposes.

What type of relationship exists when a single record in Table A is linked to many records in Table B?

• One-to-One

• One-to-Many

• Many-to-Many

• Many-to-One

Answer explanation

A One-to-Many relationship occurs when a single record in Table A can be associated with multiple records in Table B, making 'One-to-Many' the correct choice for this scenario.

Which database object is used to create a user-friendly interface for entering and viewing data?

• Query

• Table

• Form

• Report

Answer explanation

A Form is specifically designed to create a user-friendly interface for entering and viewing data, making it easier for users to interact with the database compared to Queries, Tables, or Reports.

Which feature in reports allows grouping and summarizing data?

• Sorting

• Grouping

• Filtering

• Formatting

Answer explanation

The correct choice is 'Grouping' because it allows you to organize data into categories and summarize it, making it easier to analyze. Sorting arranges data, filtering removes data, and formatting changes appearance but does not summarize.

Which of the following actions can be performed when modifying a table structure?

• Adding or deleting fields

• Changing field definitions

• Establishing a primary key

• All of the above

Answer explanation

The correct answer is All of the above because modifying a table structure in a database allows users to add or delete fields, ensuring the table stores relevant data; change field definitions, such as altering data types or setting validation rules; and establish a primary key, which uniquely identifies each record to maintain data integrity. These modifications help adapt the database to evolving needs while ensuring efficient data management.