Databases: Features, Uses, and Management for Public Services

Question 1

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

Accepted Answer

To uniquely identify each record in the table

Answer

To establish relationships between tables

Answer

To ensure data integrity by preventing duplicate values

Answer

To improve the performance of data retrieval queries

Question 2

Which SQL command is used to create a new database in MySQL?

Accepted Answer

CREATE DATABASE

Answer

CREATE TABLE

Answer

INSERT INTO

Answer

SELECT *

Question 3

What is the primary purpose of a report in a database management system?

Accepted Answer

To present data in a structured and printable format for data analysis and reporting.

Answer

To allow for complex data analysis and visualization using charts, graphs, and other visual representations.

Answer

To store data permanently and securely for long-term data retention.

Answer

To enable data manipulation and modification by end-users.

Question 4

What is the primary role of a database administrator (DBA) in a database system?

Accepted Answer

To design, implement, maintain, and manage databases, ensuring their availability, performance, and security.

Answer

To write and execute SQL queries to extract and analyze data from the database.

Answer

To provide user support and training on database usage and best practices.

Answer

To ensure data security and integrity by implementing appropriate security measures and data recovery procedures.

Question 5

What is the purpose of creating an index on a database table?

Accepted Answer

To speed up data retrieval by organizing data in a way that allows for faster searching and sorting.

Answer

To ensure data integrity by preventing duplicate values and maintaining data consistency.

Answer

To create relationships between tables by linking data based on common fields.

Answer

To store metadata about the database, including table structure and data types.

Question 6

In Microsoft Access, which data type is suitable for storing textual information?

Accepted Answer

Text

Answer

Numeric

Answer

Date

Answer

Currency

Question 7

The primary objective of a primary key within a database is to:

Accepted Answer

Uniquely identify each record

Answer

Store the most critical data in the table

Answer

Establish connections between tables

Answer

Maintain the integrity of the data

Question 8

Within SQL, which statement is employed to retrieve data from a database?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 9

In Microsoft Access, what is the fundamental distinction between a table and a query?

Accepted Answer

Tables store data while queries retrieve data

Answer

Queries store data while tables retrieve data

Answer

Both store and retrieve data

Answer

Neither stores nor retrieves data

Question 10

In a database, what is the primary purpose of a foreign key?

Accepted Answer

Establish relationships between tables

Answer

Ensure data integrity

Answer

Store the most significant data in a table

Answer

Uniquely identify individual records

Question 11

Which of the following is NOT a component found within Microsoft Access?

Accepted Answer

Spreadsheets

Answer

Tables

Answer

Queries

Answer

Forms

Question 12

What is the definition of a data dictionary?

Accepted Answer

A set of metadata describing a database

Answer

A table containing all data within a database

Answer

A software program used to create and manage databases

Answer

A tool designed to query data from a database

Question 13

In a database, what is the primary function of an index?

Accepted Answer

Enhance the speed of data retrieval

Answer

Ensure the integrity of data

Answer

Store metadata about the database

Answer

Create relationships between tables

Question 14

What is the primary purpose of using a query in a database?

Accepted Answer

To retrieve and manipulate specific data from the database

Answer

To create new records in the database

Answer

To modify the structure of the database

Answer

To delete records from the database

Question 15

What is the primary function of a foreign key in a database?

Accepted Answer

To enforce referential integrity between tables

Answer

To create a unique index on a column

Answer

To define the primary key of a table

Answer

To store additional information about a record

Question 16

In Microsoft Access, what is the purpose of a data validation rule?

Accepted Answer

To limit the type of data that can be entered into a field

Answer

To automatically generate default values for fields

Answer

To create relationships between tables

Answer

To format data for display purposes

Question 17

Which of the following data types is used to store dates and times in MySQL?

Accepted Answer

DATETIME

Answer

VARCHAR

Answer

INT

Answer

BOOLEAN

Question 18

What is a primary advantage of using a report in Microsoft Access?

Accepted Answer

To present data in a visually appealing and summarized format

Answer

To create new records in the database

Answer

To modify the structure of the database

Answer

To delete records from the database

Question 19

What are the key advantages of normalizing a database?

Accepted Answer

Improved data accuracy and integrity

Accepted Answer

Reduced data redundancy

Accepted Answer

Simplified data retrieval and maintenance

Answer

Increased data storage capacity

Question 20

Which database model is ideal for data organized in a hierarchical structure, similar to a family tree?

Accepted Answer

Hierarchical

Answer

Network

Answer

Relational

Answer

Object-oriented

Question 21

In Microsoft Access, which data type is specifically designed for storing values that represent currency?

Accepted Answer

Currency

Answer

Text

Answer

Number

Answer

Boolean

Question 22

Within a database table, which of the following serves as a unique identifier for each individual record?

Accepted Answer

A primary key

Answer

A foreign key

Answer

A unique constraint

Answer

An index

Question 23

Which type of query in Microsoft Access enables the creation of a new table or the addition of records to an existing table?

Accepted Answer

Append query

Answer

Select query

Answer

Update query

Answer

Delete query

Question 24

In Microsoft Access, what is the primary purpose of utilizing reports?

Accepted Answer

To visually present data in a user-friendly and informative manner

Answer

To establish new databases with specific structures

Answer

To modify existing data within the database

Answer

To perform advanced calculations and data analysis

Question 25

Which of the following is a type of constraint specifically designed to limit data input based on predefined rules?

Accepted Answer

Check constraint

Answer

Primary key

Answer

Foreign key

Answer

Unique constraint

Question 26

In Microsoft Access, what is the primary function of a form?

Accepted Answer

To provide a user interface for entering, editing, and viewing data

Answer

To generate reports based on existing data

Answer

To execute queries and retrieve specific data

Answer

To manage user permissions and access levels

Question 27

What is the primary benefit of utilizing an index in a database?

Accepted Answer

Significantly improving the speed and efficiency of data retrieval

Answer

Ensuring the accuracy and integrity of data within the database

Answer

Establishing relationships between different tables in the database

Answer

Providing a secure and encrypted storage mechanism for sensitive data

Question 28

In a database, primary keys and foreign keys are essential for maintaining data integrity. Explain their relationship and provide an example to illustrate how they work.

Accepted Answer

A primary key uniquely identifies each record in a table, while a foreign key references the primary key of another table, linking the records.

Answer

A primary key groups related records within a table, while a foreign key is used to sort data.

Answer

A foreign key is the primary key of a table, while a primary key is a field that references another table.

Answer

Both primary keys and foreign keys are used to create indexes for faster data retrieval.

Question 29

Which of the following is NOT a data type in Microsoft Access?

Accepted Answer

Array

Answer

Text

Answer

Number

Answer

Boolean

Question 30

What is the main purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each record

Answer

To store the most important data

Answer

To link the table to other tables

Question 31

Which type of query is used to retrieve specific data from a database?

Accepted Answer

Select query

Answer

Update query

Answer

Delete query

Question 32

What is the main difference between a report and a form in Microsoft Access?

Accepted Answer

Reports are for displaying and printing data, while forms are for entering and editing data

Answer

Forms are for displaying and printing data, while reports are for entering and editing data

Answer

Reports and forms are the same

Question 33

What is database normalization?

Accepted Answer

Organizing data to reduce redundancy and improve data integrity

Answer

Converting data from one format to another

Answer

Creating a new database

Question 34

Which SQL command is used to create a new database in MySQL?

Accepted Answer

CREATE DATABASE

Answer

NEW DATABASE

Answer

MAKE DATABASE

Question 35

What is database normalization? Explain its benefits and how it helps in organizing data and reducing redundancy.

Accepted Answer

Normalization structures data into tables to minimize redundancy and maintain data integrity.

Answer

Normalization involves duplicating data across tables to improve accessibility.

Answer

Normalization is only applicable to relational database models.

Question 36

Which database query type is used to add new data to an existing table?

Accepted Answer

Insert

Answer

Select

Answer

Update

Answer

Delete

Question 37

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

Accepted Answer

To uniquely identify each row

Answer

To index the data for faster searching

Answer

To store the most important data

Answer

To link to other tables

Question 38

Which SQL statement is used to retrieve data from a database?

Accepted Answer

SELECT

Answer

UPDATE

Answer

INSERT

Question 39

What is the role of a database management system (DBMS)?

Accepted Answer

To manage and control access to data

Answer

To design database schemas

Answer

To develop database applications

Answer

To analyze and report on data

Question 40

What is the purpose of a data dictionary in a database?

Accepted Answer

To store information about the database structure

Answer

To define user permissions

Answer

To store actual data

Answer

To optimize query performance

Question 41

Which of the following is a function of a transaction in a database?

Accepted Answer

To ensure data consistency

Answer

To provide data security

Answer

To improve performance

Answer

To facilitate data replication

Question 42

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

Accepted Answer

To enforce relationships between tables

Answer

To store additional information about a row

Answer

To index data for faster searching

Answer

To define unique values within a table

Question 43

What is the purpose of a report in a database?

Accepted Answer

To present data in a structured and formatted way

Answer

To store data permanently

Answer

To facilitate data entry

Answer

To perform data analysis

Question 44

Which of the following is not a common type of database management system (DBMS)?

Accepted Answer

Spreadsheet

Answer

Relational

Answer

Network

Answer

Object-oriented

Question 45

What is the primary key in a database?

Accepted Answer

A field that uniquely identifies each record.

Answer

A field that is used to link records together.

Answer

A field that contains the most important data.

Answer

A field that is used to sort the data in descending order.

Question 46

Which of the following is a benefit of using a database management system?

Accepted Answer

Improved data accuracy and integrity

Answer

Increased data redundancy

Answer

Difficulty in data sharing

Answer

Slow data retrieval

Question 47

What is the primary purpose of a query in a database?

Accepted Answer

To retrieve specific data from the database.

Answer

To delete data from the database.

Answer

To update the data in the database.

Answer

To create a new database.

Question 48

What is the main difference between a flat-file database and a relational database?

Accepted Answer

Relational databases store data in tables with relationships, while flat-file databases store data in a single table.

Answer

Flat-file databases are faster and more efficient than relational databases.

Question 49

Which of the following is a potential disadvantage of using a database management system?

Accepted Answer

Increased cost and complexity

Answer

Enhanced data sharing

Answer

Simplified data maintenance

Answer

Improved data accuracy

Question 50

What is the primary purpose of a report in a database?

Accepted Answer

To display data in a user-friendly and meaningful format.

Answer

To create a new database.

Answer

To update the data in the database.

Question 51

What is the primary benefit of using an index in a database?

Accepted Answer

To improve the speed of data retrieval.

Answer

To enforce data integrity.

Answer

To delete duplicate data.

Answer

To create a new database.