Module 5 Theory Questions
Settings
- 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.
- 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.
- 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
- 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
- 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.
- 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
- 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.
- 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.
- 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.
- 10.Which of the following is an appropriate data type for a field containing decimal values
- A.
AutoNumber
- B.
Number
- C.
Text
- D.
Memo
Back to top