Deck 10: Database Management

Question 1

A database contains files, a file contains ____.

A) characters, a character contains fields, and a field is made up of records
B) fields, a field contains characters, and a character is made up of records
C) records, a record contains characters, and a character is made up of fields
D) records, a record contains fields, and a field is made up of characters

Answer 1

D

Question 2

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

Answer 2

C

Question 3

____, a user deletes it from a file.

A) To correct inaccurate data
B) When new data is obtained
C) To update old data with new data
D) When a record no longer is needed

Answer 3

D

Question 4

____ is a computer phrase that points out the accuracy of a computer's output depends on the accuracy of its input.

A) Nothing ventured, nothing gained (NVNG)
B) Bad data, bad info (BDBI)
C) Garbage in, garbage out (GIGO)
D) What you see is what you get (WYSIWYG)

Question 5

A(n) ____ tests the data in two or more associated fields to ensure that the relationship is logical.

A) range check
B) completeness check
C) consistency check
D) alphabetic/numeric check

Question 6

____ is a common data type that consists of Web addresses that link to a document or Web page.

A) Hyperlink
B) AutoNumber
C) Yes/No
D) Currency

Question 7

When a program flags a deleted record, the record ____ process it.

A) is deleted physically from the disk and is deleted logically because the program will not
B) is deleted physically from the disk but remains logically because the program will
C) remains physically on the disk but is deleted logically because the program will not
D) remains physically on the disk and remains logically because the program will

Question 8

Accurate information ____.

A) is error free
B) has meaning to the person who receives it
C) is available when a decision maker needs it
D) has an age suited to its use

Question 9

Verifiable information ____.

A) gives more value than it costs to produce
B) is arranged to suit the needs and requirements of a decision maker
C) has meaning to the person who receives it
D) can be proven as correct or incorrect

Question 10

Organized information ____.

A) is error free
B) is arranged to suit the needs and requirements of a decision maker
C) can be proven as correct or incorrect
D) has an age suited to its use

Question 11

Accessible information ____.

A) gives more value than it costs to produce
B) has meaning to the person who receives it
C) is available when a decision maker needs it
D) has an age suited to its use

Question 12

Deleting unneeded files ____ storage space.

A) increases the size of files and frees up
B) increases the size of files and takes up
C) reduces the size of files but takes up
D) reduces the size of files and frees up

Question 13

Timely information ____.

A) can be proven as correct or incorrect
B) has an age suited to its use
C) gives more value than it costs to produce
D) is error free

Question 14

A ____ is the smallest unit of data a computer can process.

A) bit
B) character
C) field
D) record

Question 15

Generally, users change records in a file ____.

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

Question 16

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

A) range check
B) completeness check
C) consistency check
D) alphabetic/numeric check

Question 17

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

A) Numeric
B) Memo
C) Object
D) Date

Question 18

Useful information ____.

A) is available when a decision maker needs it
B) has an age suited to its use
C) can be proven as correct or incorrect
D) has meaning to the person who receives it

Question 19

Cost-effective information ____.

A) gives more value than it costs to produce
B) is error free
C) is arranged to suit the needs and requirements of a decision maker
D) is available when a decision maker needs it

Question 20

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

A) AutoNumber
B) Text
C) Currency
D) Object

Question 21

In a log, a DBMS places ____.

A) a copy of a record prior to a change
B) the actual change to a record
C) a copy of a record after a change
D) all of the above

Question 22

A DBMS uses the ____ to perform validation checks.

A) data server
B) data mart
C) data warehouse
D) data dictionary

Question 23

Figure 10-1 A user of a relational database, such as that pictured in Figure 10-1, refers to a file as a ____.

A) table
B) column
C) row
D) relationship

Question 24

In a relational database, each row ____.

A) and each column has a primary key
B) has a unique name and each column has a primary key
C) has a primary key and each column has a unique name
D) and each column has a unique name

Question 25

Although a query language can be used for other purposes, most users only ____ data with a query language.

A) retrieve
B) add
C) change
D) delete

Question 26

Popular data models in use today include all of the following except ____.

A) relational
B) hierarchical
C) object-oriented
D) multidimensional

Question 27

When compared with a file processing system, a database offers all of the following except ____.

A) reduced data redundancy
B) easier access and shared data
C) reduced development time
D) less required memory, storage, and processing power

Question 28

Figure 10-1 A user of a relational database, such as that pictured in Figure 10-1, refers to a field as a ____.

A) table
B) column
C) row
D) relationship

Question 29

Commonly used methods to retrieve and maintain data include all of the following except ____.

A) report generators and forms
B) query languages
C) validation rules
D) query by example

Question 30

Figure 10-1 A user of a relational database, such as that pictured in Figure 10-1, refers to a record as a ____.

A) table
B) column
C) row
D) relationship

Question 31

Figure 10-1 In a relational database, such as that pictured in Figure 10-1, a ____ is a connection within the data.

A) table
B) column
C) row
D) relationship

Question 32

A(n) ____ program interacts with a DBMS, which in turn interacts with the database.

A) before image
B) front-end
C) after image
D) back-end

Question 33

Occasionally, a database can be damaged or destroyed because of ____.

A) hardware or software failure
B) human error
C) a catastrophe, such as a fire or flood
D) all of the above

Question 34

A manager would have ____ privileges to member data in a discount warehouse database.

A) read-only
B) write-only
C) full-update
D) no access

Question 35

A(n) ____ verifies that a required field contains data.

A) range check
B) completeness check
C) consistency check
D) alphabetic/numeric check

Question 36

A major weakness of a lot of file processing systems is that ____.

A) they have redundant data and they isolate data
B) they are much more complex than a database
C) data is more vulnerable than data in a database
D) all of the above

Question 37

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

A) relational
B) object-oriented
C) multidimensional
D) all of the above

Question 38

A program determines the ____ by applying a formula to the numbers in the primary key value.

A) data type
B) check digit
C) field size
D) default value

Question 39

Figure 10-1 In a relational database, such as that pictured in Figure 10-1, users can set up a relationship between tables at any time, but the tables must have a common ____.

A) record
B) row
C) column
D) key

Question 40

A checkout clerk with ____ privileges to the e-mail addresses in a discount warehouse database could view the addresses but not change them.

A) read-only
B) write-only
C) full-update
D) no access

Question 41

Yes/No (also called ____), is a common data type that includes only the values Yes or No (or True or False).

A) Boolean
B) Integer
C) Variable
D) Text

Question 42

In the ASCII and EBCDIC coding schemes, each byte represents a single ____, which can be a number, letter, punctuation mark, or other symbol.

A) unit
B) character
C) index
D) bit

Question 43

With a(n) ____, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

A) DBMS
B) RMS
C) QBE
D) XML

Question 44

In a database, the data ____ specifies the kind of data a field can contain and how the field is used.

A) model
B) mode
C) type
D) variant

Question 45

The DBA does all of the following except ____.

A) manage security of the database
B) monitor the performance of the database
C) check backup and recovery procedures
D) decide on the proper placement of fields

Question 46

To access data in a ____, users fill in a form on a Web page.

A) hypertext database
B) multimedia database
C) Web database
D) groupware database

Question 47

Object (also called ____) is a common data type that includes photograph, audio, video, or a document created in other applications.

A) Number
B) BLOB
C) Integer
D) Binary

Question 48

Compared with relational databases, object-oriented databases ____.

A) can store more types of data
B) access data faster
C) allow programmers to reuse objects
D) all of the above

Question 49

In a database, a(n) ____ is a group of related fields.

A) table
B) key
C) record
D) primary field

Question 50

The advantage of a multidimensional database is that ____.

A) there is a common query language
B) the content of all dimensions is the same regardless of the subject
C) it can consolidate data much faster than a relational database
D) all of the above

Question 51

Figure 10-5 A(n) ____ check is a validity check performed on data like that in Figure 10-5, which ensures users enter only alphabetic data into a field.

A) alphabetic
B) binary
C) text
D) ASCII

Question 52

In a database, a(n) ____ field is a field that uniquely identifies each record in a file.

A) main
B) identifying
C) master
D) key

Question 53

Many e-commerce sites use ____ to determine customer preferences.

A) data checking
B) data mining
C) data sorting
D) data serving

Question 54

A ____ stores data about engineering, architectural, and scientific designs.

A) multimedia database
B) groupware database
C) computer-aided design (CAD) database
D) hypertext database

Question 55

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

A) XML
B) DBMS
C) SQL
D) QBE

Question 56

A ____ stores images, audio clips, and/or video clips.

A) multimedia database
B) groupware database
C) computer-aided design (CAD) database
D) hypertext database

Question 57

A ____ stores documents such as schedules, calendars, manuals, memos, and reports.

A) multimedia database
B) groupware database
C) computer-aided design (CAD) database
D) hypertext database

Question 58

____ is a common data type that includes letters, numbers, or special characters.

A) Alpha
B) Character
C) Metric
D) Text

Question 59

A Web database usually resides on a(n) ____.

A) intranet
B) extranet
C) database server
D) object-oriented server

Question 60

The DA does all of the following except ____.

A) decide on the proper placement of fields
B) define the relationships among data
C) identify users' access privileges
D) create and maintain the data dictionary

Question 61

Data warehouses often use a process called data ____ to find patterns and relationships among data.

A) warehousing
B) analysis
C) serving
D) mining

Question 62

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

A) tuple
B) field
C) attribute
D) relation

Question 63

A DBMS that creates a log usually provides a(n) ____ utility that uses the logs and/or backups to restore a database when it becomes damaged or destroyed.

A) recovery
B) restoration
C) resumption
D) baseline

Question 64

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

A) tuple
B) attribute
C) key
D) relation

Question 65

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.

A) SQL
B) XML
C) CGI
D) schema

Question 66

An application that supports a front-end program sometimes is called the ____.

A) back end
B) RDBMS
C) GUI
D) collaborative database

Question 67

The data in a(n) ____ database exists in many separate locations throughout a network or the Internet.

A) dynamic
B) remastered
C) distributed
D) indexed

Question 68

____ backup is a backup plan in which all data is backed up whenever a change is made.

A) Integrated
B) Continuous
C) Dynamic
D) Automated

Question 69

A database ____ is a computer that stores and provides access to a database.

A) mart
B) server
C) station
D) client

Question 70

Figure 10-5 A(n) ____ check is a validity check performed on data like that in Figure 10-5, which ensures users enter only numeric data into a field.

A) range
B) numeric
C) integer
D) value

Question 71

A(n) ____ check is a validity check that determines whether a number is within a specified group of numbers.

A) group
B) numeric
C) range
D) integer

Question 72

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

A) OQL
B) SQL
C) TQL
D) AQL

Question 73

Figure 10-4 Most DBMSs include a(n) ____ feature, like the one in Figure 10-4, which has a graphical user interface to assist users with retrieving data.

A) QBA
B) SQL
C) QBE
D) schema

Question 74

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

A) attribute
B) record
C) relation
D) tuple

Question 75

A(n) ____ is a program with which users interact that generally has a more user-friendly interface than a DBMS.

A) back end
B) RDBMS
C) SQL
D) front end

Question 76

More complex DBMSs maintain a(n) ____, which is a listing of activities that change the contents of a database.

A) recovery utility
B) roster
C) backup plan
D) log

Question 77

A data ____ contains a database that helps a specific group or department make decisions.

A) mart
B) warehouse
C) market
D) station

Question 78

A(n) ____ contains data about each file in a database and each field in those files.

A) glossary
B) repository
C) index
D) table of contents

Question 79

A data ____ is a huge database that stores and manages the data required to analyze historical and current transactions.

A) stockyard
B) warehouse
C) storehouse
D) storage unit

Question 80

____ is a process designed to ensure the data within the relations (tables) contains the least amount of duplication.

A) Concatenation
B) Rasterization
C) Dithering
D) Normalization