Chapter 8: Database Management System
MULTIPLE CHOICE
1.A(n) ____ is a collection of data organized in a manner that allows access, retrieval, and use of that data.
a. / Database / c. / spreadsheetb. / Server / d. / webbase
2.____ is a collection of unprocessed items, which can include text, numbers, images, audio, and video.
a. / Integrity / c. / Synthesisb. / Data / d. / Information
3.____ is processed data; that is, it is organized, meaningful, and useful.
a. / Validation / c. / Informationb. / An integer set / d. / Repository data
4.Data ____ identifies the quality of data in a database.
a. / resolution / c. / dimensionalityb. / Access / d. / integrity
5.In the database pictured in the accompanying figure, a(n) ____ is a combination of one or more related characters or bytes and is the smallest unit of data a user accesses.
a. / Field / c. / recordb. / Member / d. / identifier
6.In the database pictured in the accompanying figure, a field ____ uniquely identifies each field.
a. / Tag / c. / signalb. / Name / d. / basis
7. For the database pictured in the accompanying figure, the field ____ defines the maximum number of characters a field can contain.
a. / Medium / c. / sizeb. / Scope / d. / identifier
8.A data ____ is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard disk or optical disc.
a. / Validator / c. / setb. / Rubric / d. / file
9.File ____ refers to the procedures that keep data current.
a. / maintenance / c. / validationb. / Integrity / d. / checking
10. ____ is the process of comparing data with a set of rules or values to find out if the data is correct.
a. / Concatenation / c. / Digit checkingb. / Validation / d. / Integration
11.Many database programs perform a validity ____ that analyzes entered data to help ensure that it is correct.
a. / confirmation / c. / checkb. / integration / d. / valuation
12.Validation ____ reduce data entry errors.
a. / tags / c. / standardsb. / baselines / d. / rules
13.A(n) ____ digit is a number(s) or character(s) that is appended to or inserted into a primary key field.
a. / check / c. / insertionb. / index / d. / integer
14. A(n) ____ is a window on the screen that provides areas for entering or changing data in a database.
a. / form / c. / change screenb. / report / d. / recovery screen
15. A(n) ____ check is a validity check performed on data like that in the accompanying figure, which ensures users enter only numeric data into a field.
a. / range / c. / completenessb. / numeric / d. / consistency
16.A(n) ____ check is a validity check on data like that in the accompanying figure, which determines whether a number is within a specified group of numbers.
a. / group / c. / rangeb. / numeric / d. / integer
17.A major weakness of a lot of file processing systems is that ____.
a. / they have redundant data and they isolate datab. / they are much more complex than a database
c. / data is more vulnerable than data in a database
d. / all of the above
18.In a typical file ____ system, each department or area within an organization has its own set of files.
a. / synthesis / c. / analysisb. / processing / d. / integration
19.When a company uses the ____ approach, many programs and users share the data in a database.
a. / front-end / c. / databaseb. / concatenated / d. / memory-based
20.A(n) ____ program interacts with a DBMS, which in turn interacts with the database.
a. / before image / c. / after imageb. / front-end / d. / back-end
21.When compared with a file processing system, a database offers all of the following EXCEPT ____.
a. / reduced data redundancyb. / easier access and shared data
c. / reduced development time
d. / less required memory, storage, and processing power
22.A(n) ____ is a program with which users interact that generally has a more user-friendly interface than a DBMS.
a. / back end / c. / SQLb. / RDBMS / d. / front end
23.An application that supports a front-end program sometimes is called the ____.
a. / back end / c. / GUIb. / RDBMS / d. / collaborative database
24. In managing a company’s database, the database ____ requires a technical inside view of data.
a. / administrator / c. / modelerb. / manager / d. / leader
Page 1