Module 5 Theory Questions

1.

Which one of the following is responsible for providing users with access to the appropriate data.
- A.
  
  A database administrator.
- B.
  
  A database architect
- C.
  
  A database designer.
- D.
  
  A database user.
Correct Answer
A. A database administrator.

Explanation
A database administrator is responsible for providing users with access to the appropriate data. They manage and control the overall functioning of a database system, including granting permissions and setting up user accounts. They ensure that users have the necessary privileges to access and manipulate the data they need while also maintaining data security and integrity. A database architect is responsible for designing the overall structure and organization of a database system, while a database designer focuses on designing the specific tables, relationships, and attributes within the database. A database user is someone who interacts with the database to retrieve, input, or modify data.

Rate this question:

1
0
2.

Which one of the following outcomes is a result of adding an index?
- A.
  
  Records can be searched and sorted efficiently
- B.
  
  All records can be quickly deleted
- C.
  
  Tables in a database can be related
- D.
  
  Records can be entered into a database.
Correct Answer
A. Records can be searched and sorted efficiently

Explanation
Adding an index to a database allows for efficient searching and sorting of records. An index is a data structure that improves the speed of data retrieval operations by providing a quick lookup mechanism. It organizes the data in a specific order, allowing for faster searching and sorting based on the indexed field. Therefore, adding an index enables the database system to locate and retrieve the desired records more efficiently, resulting in improved performance when searching and sorting data.

Rate this question:
3.

What is a database
- A.
  
  A structured collection of records or data
- B.
  
  A data structure that improves search operations in a table
- C.
  
  A program for creating online forms
- D.
  
  A set of instruction used retrieving data from a table
Correct Answer
A. A structured collection of records or data

Explanation
A database is a structured collection of records or data. It is a system used to organize and store large amounts of information in a way that allows for efficient retrieval and manipulation of data. By organizing data into tables and defining relationships between them, a database ensures data integrity and provides a reliable and efficient method for storing and accessing information.

Rate this question:
4.

Which one of the following is the purpose of relating tables in a database?
- A.
  
  To permit external data only to be viewed
- B.
  
  To allow data to be sorted before printing to a report
- C.
  
  To enable mathematical calculations to be carried out more efficiently.
- D.
  
  To reduce duplication of data
Correct Answer
D. To reduce duplication of data

Explanation
Relating tables in a database allows for the reduction of duplication of data. By establishing relationships between tables, data can be stored in a more organized and efficient manner. This means that instead of repeating the same data in multiple places, it can be stored in one table and referenced in other tables through the use of keys. This not only saves storage space but also ensures data integrity and consistency throughout the database.

Rate this question:
5.

Which one of the following prevents you adding a record to a related table when there is no associated record in the primary table?
- A.
  
  A primary key.
- B.
  
  Relational integrity
- C.
  
  A validation rule.
Correct Answer
B. Relational integrity

Explanation
Relational integrity refers to the consistency and accuracy of data in a relational database. It ensures that relationships between tables are maintained and that data remains consistent across the database. In this context, relational integrity prevents adding a record to a related table when there is no associated record in the primary table. This ensures that the relationship between the two tables is maintained and that data remains accurate and consistent.

Rate this question:
6.

Each field in a table should contain …
- A.
  
  More than one data element
- B.
  
  No data elements
- C.
  
  Only one data element
- D.
  
  Any number of data elements
Correct Answer
C. Only one data element

Explanation
In a table, each field should contain only one data element. This means that each field should hold a single value or piece of information. This ensures that the data in the table is organized and structured properly. Having only one data element per field allows for efficient data retrieval and manipulation, as well as maintaining the integrity and consistency of the table.

Rate this question:
7.

Which one of the following can result from reducing the size of a field in a table?
- A.
  
  Loss or corruption of data in the table.
- B.
  
  Changes to reports which access the table.
- C.
  
  An increase in the number of records in the table.
- D.
  
  A decrease in the number of records in the table.
Correct Answer
A. Loss or corruption of data in the table.

Explanation
Reducing the size of a field in a table can result in loss or corruption of data in the table because if the field size is decreased, it may not be able to accommodate all the data that was previously stored in it. This can lead to data being truncated or overwritten, resulting in loss or corruption of the data.

Rate this question:
8.

Which one of the following is used to assign a unique identity to a record?
- A.
  
  A validation rule.
- B.
  
  A form.
- C.
  
  A primary key.
- D.
  
  A filter.
Correct Answer
C. A primary key.

Explanation
A primary key is used to assign a unique identity to a record in a database. It is a column or a combination of columns that uniquely identifies each record in a table. The primary key ensures that there are no duplicate records in the table and is used as a reference point for establishing relationships between tables. It is an essential component of database design and is used for data integrity and efficient data retrieval.

Rate this question:
9.

Which one of the following is the purpose of a primary key
- A.
  
  To select a field size.
- B.
  
  To select a date type.
- C.
  
  To assign each record a unique identity.
- D.
  
  To save all records in a table.
Correct Answer
C. To assign each record a unique identity.

Explanation
The purpose of a primary key is to assign each record in a table a unique identity. This ensures that each record can be uniquely identified and accessed, allowing for efficient data retrieval and manipulation. The primary key also enforces data integrity by preventing duplicate records from being entered into the table.

Rate this question:
10.

Which of the following is an appropriate data type for a field containing decimal values
- A.
  
  AutoNumber
- B.
  
  Number
- C.
  
  Text
- D.
  
  Memo
Correct Answer
B. Number

Explanation
The appropriate data type for a field containing decimal values is "Number". This data type allows for the storage of numeric values, including both whole numbers and decimal numbers. The AutoNumber data type is used for automatically generated unique identifiers, Text is used for storing text values, and Memo is used for storing large amounts of text.

Rate this question:

Module 5 Theory Questions

Which one of the following is responsible for providing users with access to the appropriate data.

Which one of the following outcomes is a result of adding an index?

What is a database

Which one of the following is the purpose of relating tables in a database?

Which one of the following prevents you adding a record to a related table when there is no associated record in the primary table?

Each field in a table should contain …

Which one of the following can result from reducing the size of a field in a table?

Which one of the following is used to assign a unique identity to a record?

Which one of the following is the purpose of a primary key

Which of the following is an appropriate data type for a field containing decimal values