FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Database Management

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

Users add new records to a file ____.

A) when a record no longer is needed
B) to correct inaccurate data
C) when they obtain new data
D) to update old data with new data

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

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

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?

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.

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

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

Compared with relational databases, object-oriented databases ____.

Timely information ____.

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

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

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

____ 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.

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

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

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

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

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.

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