Exam 1: Database Systems

The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.

When a database storesthe majority of data in RAM rather than in hard disks, itis referred to as a(n) _____ database.

Structure is based on the type of processing to be performed on the data.

An advantage of database systems is that you needn't perform frequent updates and apply latest patches.

What are the advantages of having the DBMS between the end user's applications and the database?

A desktop database is a _____ database.

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

_____ is the result of processing raw data to reveal its meaning.

Raw data must be properly _____ for storage, processing and presentation.

A data warehouse can store data derived from many sources.

_____ is a special language used to represent and manipulate data elements in a textual format.

_____ data exist in the format in which they were collected.

Data is said to be verifiable if:

A workgroup database is a(n) _____ database.

_____ provide a description of the data characteristics and the set of relationships that link the data found within the database.

Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.

_____ is the body of information and facts about a specific subject.

One advantage of a database system over previous data management approaches is that the database system is considerably less complex.

To reveal meaning, information requires _____.

A data warehouse contains historical data obtained from the _____.