Exam 1: Database Systems

Data and information are essentially the same thing.

A(n) _____ database is used by an organization and supports many users across many departments.

Field refers to a collection of related records.

_____ is data about data through which the end-user data are integrated and managed.

_____ relates to activities that make a database operate more efficiently in terms of storage and access speed.

A(n) _____ might be written by a programmer or it might be created through a DBMS utility program.

An operational database is sometimes referred to as an enterprise database.

A(n) _____ is a collection of programs that manages the database structure and controls access to the data stored in the database.

Describe what metadata are and what value they provide to the database system.

_____ data exist in a format that does not lend itself to processing that yields information.

Data constitute the building blocks of information.

_____ exists when different versions of the same data appear in different places.

What are the problems associated with file systems? How do they challenge the types of information that can be created from the data as well as the accuracy of the information?

Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

_____ databases focus primarily on storing data used to generate information required to make tactical or strategic decisions.

A _____ is a character or group of characters that has a specific meaning.

A(n) _____ is a spur-of-the-moment question.

Which of the following is true of spreadsheet applications?

A database that is created and maintained using services such as Microsoft Azure or Amazon AWS is called a(n) _____ database.

_____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.