Exam 10: Database Management

Whereas a relational database can store more than two dimensions, a multidimensional database is a two-dimensional table.

The developer of a relational database refers to a file as a(n) ____.

Object-oriented and object-relational databases often use a query language called ____ to manipulate and retrieve data.

Critical Thinking Questions Case 1 In your new role as a DBA, you have inherited a database that has a lot of problems. Your first task, you decide, is to identify the qualities of the information in your database, or, in some unfortunate cases, the absence of these qualities. The manager for the eastern division sales force is upset because she wants to determine which members of her sales force need awards for high monthly sales, and which employees need remediation because they have not sold enough product during the past month. However, all of the sales information has not yet been entered into the database. What kind of information is at issue in this instance?

Managing a company's database requires a great deal of coordination.

____ is a common data type that consists of lengthy text entries.

Often it is difficult to access data stored in separate files in different departments.

Figure 10-3 Most ____ database products for servers and mainframes include SQL, an example of which is shown in Figure 10-3.

One type of program that manages the sending and receiving of data between the front end and a database server is a(n) ____ script, which runs automatically as soon as users click a button to send or receive information.

Compared with relational databases, object-oriented databases ____.

Users add new records to a file ____.

____________________ is processed data; that is, it is organized, meaningful, and useful.

Each record in a data file contains different fields, but each field contains the same data.

Timely information ____.

A(n) ____________________ is a request for specific data from a database.

Figure 10-3 ____, as shown in Figure 10-3, is a query language that allows users to manage, update, and retrieve data.

A common reason to change a record is to update old data with new data.

____ is a common data type that consists of dollar and cent amounts or numbers containing decimal values.

It often is easier and faster to develop programs that use the database approach.

Figure 10-2 A(n) ____________________ is a collection of related records, as shown in Figure 10-2, stored on storage media such as a hard disk, CD, or DVD.