Multiple-Choice Questions

1. The data attributes that a particular user has permission to access are defined by the
a. Operating system view.
b. Systems design view.
c. Database schema.
d. User view.
e. Application program.

2. The database approach has several unique characteristics not found in traditional (flat-file) systems. Which of the following statements does not apply to the database model?
a. Database systems have data independence; that is, the data and the programs are maintained separately except during processing.
b. Database systems contain a data-definition language that helps describe each schema and subschema.
c. The database administrator is the part of the software package that instructs the operating aspects of the program when data are retrieved.
d. A primary goal of database systems is to minimize data redundancy.
e. Database systems provide increased accessibility to data and flexibility in its usage.

3. One of the first steps in the creation of a relational database is to
a. Integrate accounting and nonfinancial data.
b. Plan for increased secondary storage capacity.
c, Order data-mining software that will facilitate data retrieval.
d. Create a data model of the key entities in the system.
e. Construct the physical user view using SQL.

4. Database currency is achieved by
a. Implementing partitioned databases at remote sites.
b. Employing data-cleansing techniques.
c. Ensuring that the database is secure from accidental entry.
d. An external auditor’s reconciliation of reports from multiple sites.
e. A database lockout that prevents multiple simultaneous access.

5. The installation of a database management system is likely to have the least impact on
a. Data redundancy.
b. Entity-wide sharing of common data.
c. Exclusive ownership of data.
d. The logic needed to solve a problem in an application program.
e. The internal controls over data access.

6. The functions of a database administrator are
a. Database planning, data input preparation, and database design.
b. Data input preparation, database design, and database operation.
c. Database design, database operation, and equipment operations.
d. Database design, database implementation, and database planning.
e. Database operations, database maintenance, and data input preparation.

7. A relational database system contains the following inventory data: part number, description, quantity- on-hand, and reorder point. These individual items are called
a. Attributes.
b. Relations.
c. Associations.
d. Occurrences.

8. Which of the following is a characteristic of a relational database system?
a. All data within the system are shared by all users to facilitate integration.
b. Database processing follows explicit links that are contained within the records.
c. User views limit access to the database.
d. Transaction processing and data warehousing systems share a common database.