Exam 11: Databases

Describe the structure and functionality of a hierarchical database.

The data _____ or schema contains a description of the structure of data in the database.

In the object-oriented database model, this term is the equivalent to a field in a relational model.

The scenario wherein many files about the same person exist across different departments within an organization is called data _____.

Typically, one of the duties of a database administrator is to interact with the data administration subsystem.

What is the difference between the individual database and the company database?

The company database may be stored on a central database server and managed by a database administrator.

Data consists of only numbers, letters, and symbols.

Relational database tables require a common data item or key field.

In order to create, modify, and gain access to a database, special software called the database management system is required.

Access to these databases is offered to the public or selected outside individuals, for a fee.

A field that uniquely identifies each record.

In a(n) _____ database, a node may be reached through more than one path with the help of pointers.

In a network database, a node can be traced down through different branches.

A(n)_____ database, also called a microcomputer database, is a collection of integrated files primarily used by just one person.

A record is a collection of related tables.

Analysis tools that support viewing all or selected parts of data, querying the database, and generating reports include query-by-example as well as:

A(n) _____ database includes multiple dimensions, sometimes called a data cube.