Exam 5: Data Resource Management

Databases contain data elements that describe both entities and the _______________ among entities.

The primary challenge of a distributed database is:

Variable-length records contain:

When independent of any other files related to it, a single table is referred to as a(n):

Databases contain data elements that describe both entities and the _______________ among entities.

The _______________ stage of database development translates the conceptual models into the data model of a DBMS.

_______________, data that define the data in the data warehouse, are stored in a metadata repository and cataloged by a metadata directory.

Database management packages based on the relational model can link data elements from various tables to provide information to users.

All of the following contribute to problems when using a file management approach except:

When independent of any other files related to it, a single table is referred to as a compressed file.

In a distributed database system, each location gains control of its local data, but loses access to data in other locations.

Which database model allows many-to-many relationships among records so that a data element can be accessed by following one of several paths?

Large organizations usually place control of enterprise-wide database development in the hands of database administrators (DBAs) and other database specialists.

An _______________ consists of data values describing the attributes of an entity, plus the operations that can be performed upon the data.

A database with a(n) _______________ data structure can easily handle ad hoc requests for information.

_______________ database design takes a physical view of the data that describes how data are to be physically stored and accessed on the storage devices of a computer system.

Database administrators and designers work with corporate and end user management to develop an _______________ model that defines the basic business process of the enterprise.

Which database structure works effectively with complex data types, such as video clips, audio segments, and other subsets of Web pages, and is considered one of the key technologies of Web-based applications?

All of the relationships between the data elements in a relationally organized database need to be specified when the database is created.