Module 5 Theory Questions

10 Questions | By Jackie_mac | Updated: Mar 17, 2022 | Attempts: 2245

Questions

Settings

Create your own Quiz

Questions and Answers

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