Exam 5: Data Resource Management

A database with a(n) _______________ data structure can easily handle a many-to-many data relationship.

A record represents a collection of _______________ that describe an entity.

Data warehouses may be subdivided into _______________, which hold subsets of data from the warehouse that focus on specific aspects of a company, such as a department or a business process.

Automobiles contain very little useful business information about consumers.

Variable-length records contain a variable number of fields with fixed field lengths.

_______________ contain both a fixed number of fields and fixed field lengths.

_______________ is the most commonly used database application for the PC.

The basic form of a SQL query is SELECT.....ROM........ _______________.

Database development involves defining and organizing the _______________ of the data needed to build a database.

Relational databases are more difficult for programmers to work with and more difficult to maintain than the hierarchical and network models.

The tables in a relational database are flat files which have rows and columns. Each row represents a _______________ in the file.

A central source of data that have been cleaned, transformed, and cataloged so that they can be used for business analysis, market research, and decision support is called a _______________.

One drawback to the database duplication process is that no changes can ever be made to any database other than the master. Otherwise, local changes will be overwritten during the duplication process.

Which of the following statements concerning the replication and duplication process for updating distributed databases is correct?

A DBMS query language is designed to:

Entity Relationship Diagrams are _______________ of the various files and their relationships within a database system.

According to the text, most data warehouses will run _______________ in a column format.

From a logical point of view, a(n) _______________ is the smallest data element that can be observed and manipulated.

Boolean logic deals with three logical operators:

The Internet is nothing more than the world's largest database.