Chapter 11 Checkpoint

Question 1

True or False: the more errors data contains, the higher its integrity

Answer 1

False

Question 2

True or False: in a data hierarchy, each higher level of data contains one or more items from the lower level

Answer 2

True

Question 3

True or False: a field size determines the maximum number of characters a field can contain

Answer 3

True

Question 4

True or False: validity checks reduce data entry errors and thus enhance the data’s integrity

Answer 4

True

Question 5

True or False: a check digit often confirms the accuracy of a primary key value

Answer 5

True

Question 6

True or False: file processing systems require more memory, storage, and processing power than a database

Answer 6

False

Question 7

True or False: in a rollforward, the DBMS uses the log to undo any changes made to the database during a certain period

Answer 7

False

Question 8

True or False: in a file processing system, you can set up a relationship between tables at any time

Answer 8

False

Question 9

True or False: a relational database processes and summarizes large number of records efficiently and can do so much faster than a multidimensional database

Answer 9

False

Question 10

True or False: a database administrator (DBA) focuses on the meaning and usage of data

Answer 10

False

Question 11

True or False: an ERP allows for storage and management of a company’s documents

Answer 11

False

Question 12

True or False: with batch processing, the computer collects data over time and processes all transactions later, as a group

Answer 12

True

Question 13

A(n) ___________ check tests data in two or more associated fields to ensure that the relationship is logical and their data is in the correct format.

Answer 13

consistency

Question 14

Which of the following is not an advantage of a database approach?

a. improved data integrity
b. reduced data redundancy
c. shared data
d. requires less memory, storage, and processing power than file processing systems

Answer 14

d. requires less memory, storage, and processing power than file processing systems

Question 15

A _____ ________ contains data about each file in the database and each field in those files.

Answer 15

data dictionary

Question 16

A developer of a relational database refers to a file as a ________.

Answer 16

relation

Question 17

A(n) ______-_________ database stores data in objects.

Answer 17

object-oriented

Question 18

With ________ __________ _________, the computer processes each transaction as it is entered.

Answer 18

online transaction processing

Question 19

A(n) _________ report usually lists just transactions.

Answer 19

detailed

Question 20

In an expert system, the __________ ______ is the combined subject knowledge and experiences of the human experts.

Answer 20

knowledge base

Question 21

combination of one or more related characters or bytes and is the smallest unit of data a user accesses

Answer 21

field

Question 22

specifies the kind of data a field can contain and how the field is used

Answer 22

data type

Question 23

field that uniquely identifies each record in a file

Answer 23

primary key

Question 24

procedures that keep data current

Answer 24

file maintenance

Question 25

process of comparing data with a set of rules or values to determine if the data is correct

Answer 25

validation

Question 26

request for specific data from a database

Answer 26

query

Question 27

defines how users view the organization of the data

Answer 27

data model

Question 28

item that contains data, as well as the actions that read or process the data

Answer 28

object

Question 29

huge database that stores and manages the data required to analyze historical and current transactions

Answer 29

data warehouse

Question 30

term used to describe the widespread growth of data, the variety of formats in which the data is available, and the processing required to make the data accessible in a timely manner

Answer 30

Big Data

Question 31

What is function creep?

Answer 31

Function creep occurs when a company uses the technology intended for one purpose for another.

Question 32

If you use a browser, what are some techniques you can use to protect your data?

Answer 32

1) using settings in the browser that will allow you to limit data tracking
2) read privacy policies before you purchase an item from an online vendor
3) use a social networking site that informs you of potential ways your data may be used

Question 33

List reasons for backing up data.

Answer 33

1) before modifying or deleting data

2) before performing any maintenance operations on the database

Question 34

List some ways to back up database.

Answer 34

1) If your computer already has a backup program running, it might be backing up your database. If not, configure the backup program to back up the database
2) Copy the database to another storage device
3) Copy the database to a different folder on the same storage medium as the original database

Question 35

What are the responsibilities of database analysts and administrators?

Answer 35

The database analysts and administrators are responsible for managing and coordinating all database activities.

Question 36

How do their jobs differ?

Answer 36

The database analysts, focuses on the meaning and usage of data.

• decide the proper placement of fields
• defines the relationships among data
• identifies users
• access privileges

The database administrator

• creates and maintains the data dictionary
• manages security of the database
• monitors the performance of the database
• checks backup and recovery procedures

Question 37

What is database design?

Answer 37

the process of determining the organization of a database

Question 38

In designing a database, what must the database analyst or administrator identify?

Answer 38

1) the entities in the database

2) the entities’ attributes, primary keys, and relationships

Question 39

What is a decision support system?

Answer 39

helps users analyze information and make decisions

Question 40

What is an expert system?

Answer 40

an information system that captures and stores the knowledge of human experts and then imitates human reasoning and decision making