Ch11 Test Bank Databases

Visualizing Technology Complete, 9e (Geoghan)

Chapter 11 Databases

1) A database is a collection of ________ that has been organized in a meaningful way.

A) spreadsheets

B) files

C) information

D) documents

Diff: 1

Objective: 11.1 Identify the Parts of a Database

2) In a database, a ________ stores data in rows and columns.

A) field

B) table

C) cell

D) matrix

Diff: 1

Objective: 11.1 Identify the Parts of a Database

3) A ________ contains the information for a single entity in the database.

A) table

B) record

C) field

D) cell

Diff: 1

Objective: 11.1 Identify the Parts of a Database

4) Which would make the best primary key in a table?

A) Last name

B) Student ID

C) First name

D) Street Address

Diff: 2

Objective: 11.1 Identify the Parts of a Database

5) In a database, title, author, publication date, and ISBN are examples of ________.

A) records

B) fields

C) tables

D) queries

Diff: 1

Objective: 11.1 Identify the Parts of a Database

6) ________ make data entry easier because they can be set up to match the layout of a paper document.

A) Reports

B) Records

C) Forms

D) Queries

Diff: 2

Objective: 11.1 Identify the Parts of a Database

7) A ________ could be used to retrieve all the phone numbers from a student database.

A) table

B) record

C) query

D) form

Diff: 2

Objective: 11.1 Identify the Parts of a Database

8) To print data or display it in an easy-to-read format, a ________ can be used.

A) report

B) table

C) record

D) form

Diff: 2

Objective: 11.1 Identify the Parts of a Database

9) An Excel spreadsheet is an example of a(n) ________ database.

A) object-oriented

B) flat

C) relational

D) hierarchical

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

10) In a relational database for vehicles, a ________ relationship occurs when each vehicle record may link to several repair records, but each repair can link to only one vehicle.

A) simple query

B) many-to-many

C) one-to-one

D) one-to-many

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

11) In a one-to-one relationship, both tables use the same ________ to link two records.

A) query

B) primary key

C) foreign key

D) form

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

12) What project was coordinated by the U.S. Department of Energy and the National Institutes of Health?

A) ARPANET

B) Integrated Automated Fingerprint Identification System

C) Combined DNA Index System

D) Human Genome Project

Diff: 3

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

13) Which is a type of data that can be stored in an object-oriented database?

A) Documents and spreadsheets

B) Documents

C) Spreadsheets

D) Images, audio, and video

Diff: 3

Objective: 11.2 Compare the Four Types of Databases

14) Data in a ________ database are stored in data cubes.

A) multidimensional

B) relational

C) hierarchical

D) flat

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

15) ________ allows the user to selectively extract data from different viewpoints.

A) An office support system (OSS)

B) A transaction-processing system (TPS)

C) Online analytical processing (OLAP)

D) A decision support system (DSS)

Diff: 3

Objective: 11.2 Compare the Four Types of Databases

16) The ________ database is the most popular type used by businesses.

A) hierarchical

B) relational

C) multidimensional

D) flat

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

17) The science and telecommunications industries would most likely use the ________ database type.

A) multidimensional

B) relational

C) flat

D) object-oriented

Diff: 3

Objective: 11.2 Compare the Four Types of Databases

18) Which is not an advantage of data normalization?

A) Makes it easier to update records

B) Increases query speed

C) Reduces the database size

D) Increases database development time

Diff: 3

Objective: 11.3 Explain Database Management Systems

19) A data ________ rule would prevent a user from entering text in a date/time field.

A) manipulation

B) validation

C) monitoring

D) redundancy

Diff: 2

Objective: 11.3 Explain Database Management Systems

20) A data ________ defines the fields in a database and the type of data that each field contains.

A) mine

B) dictionary

C) warehouse

D) reference

Diff: 2

Objective: 11.3 Explain Database Management Systems

21) To ensure that a person does not misspell Wednesday in a field, a(n) ________ list can be used.

A) lookup

B) Find feature

C) master

D) inference

Diff: 2

Objective: 11.3 Explain Database Management Systems

22) Microsoft Office is an example of a(n) ________.

A) geographic information system (GIS)

B) office support system (OSS)

C) transaction-processing system (TPS)

D) Structured Query Language (SQL)

Diff: 1

Objective: 11.4 Discuss Important Types of Information Systems

23) Which of the following is not an SQL relational keyword?

A) WHERE

B) QUIT

C) FROM

D) SELECT

Diff: 3

Objective: 11.3 Explain Database Management Systems

24) The test that a transaction processing system uses to make sure that transactions are fully completed or aren't undertaken at all is known as ________.

A) consistency

B) isolation

C) atomicity

D) durability

Diff: 3

Objective: 11.4 Discuss Important Types of Information Systems

25) An expert system is a computer programmed to ________.

A) use SQL statements to respond to requests

B) make decisions in real-life situations

C) search the web for experts

D) present possible decision outcomes

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

26) A(n) ________ is a set of rules that are used to apply a knowledge base to each situation.

A) difference engine

B) cognitive computing system

C) decision support system

D) inference engine

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

27) A(n) ________ improves over time by learning from its interactions.

A) knowledge base

B) cognitive computing system

C) decision support system

D) inference engine

Diff: 3

Objective: 11.4 Discuss Important Types of Information Systems

28) Which is not a CODIS index?

A) Arrestee

B) Forensic

C) Missing Persons

D) Victims

Diff: 3

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

29) ________ is the application of information technology to the field of biology.

A) Biofeedback

B) Biocenosis

C) Bioinformatics

D) Bioengineering

Diff: 2

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

30) A GIS is made up of datasets, also called ________, of geographically referenced information about Earth's surface.

A) sets

B) information

C) datacaches

D) layers

Diff: 2

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

31) A GIS can be used by local municipalities to ________.

A) capture criminals

B) budget for waste management facilities

C) warn citizens of weather-related events

D) design emergency routes

Diff: 3

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

32) In a transaction-processing system, ________ insures that transactions are either completed or not begun.

A) consistency

B) atomicity

C) isolation

D) durability

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

33) In a transaction-processing system, ________ insures that it follows it's own rules or integrity constraints.

A) consistency

B) atomicity

C) isolation

D) durability

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

34) In a transaction-processing system, ________ insures that each transaction is independent of every other transaction.

A) consistency

B) atomicity

C) durability

D) isolation

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

35) In a transaction-processing system, ________ insures that transactions, once completed, cannot be undone.

A) atomicity

B) durability

C) isolation

D) consistency

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

36) In blockchain, each block has a unique ________ that converts the data into an encrypted output of a fixed length.

A) block

B) chain

C) code

D) hash

Diff: 3

Objective: 11.4 Discuss Important Types of Information Systems

37) In September 2014, what replaced the existing fingerprint system?

A) Next Generation Identification

B) Combined DNA Index System

C) Human Genome Project

D) Bioinformatics

Diff: 3

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

38) The primary key field uniquely identifies a record in a table.

Diff: 1

Objective: 11.1 Identify the Parts of a Database

39) The test that a transaction processing system uses to make sure that each transaction is independent is known as durability.

Diff: 1

Objective: 11.4 Discuss Important Types of Information Systems

40) One way to display the data in a table is by creating a report.

Diff: 2

Objective: 11.1 Identify the Parts of a Database

41) Using a report to enter data into a database decreases the frequency of data entry errors.

Diff: 2

Objective: 11.1 Identify the Parts of a Database

42) When information is duplicated in multiple places, it is known as data redundancy.

Diff: 2

Objective: 11.3 Explain Database Management Systems

43) A datacenter is a facility designed to house a company's servers and other equipment in a secure and controlled environment.

Diff: 2

Objective: 11.1 Identify the Parts of a Database

44) A many-to-many relationship exists when a book has multiple authors and the authors have written many different books.

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

45) A data warehouse is used to discover relationships among data items.

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

46) Microsoft Excel is an example of a DBMS.

Diff: 1

Objective: 11.3 Explain Database Management Systems

47) When designing a database, you should have separate fields for a person's first and last names.

Diff: 1

Objective: 11.3 Explain Database Management Systems

48) A DBMS will define a data type for you by evaluating the data currently entered into the fields.

Diff: 1

Objective: 11.3 Explain Database Management Systems

49) Durability, as related to transaction processing, means that once a transaction has been completed, it cannot be undone.

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

50) A decision support system is made up of a knowledge base and an inference engine.

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

51) The National Missing Person DNA database is part of the CODIS system.

Diff: 2

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

52) The Integrated Automated Fingerprint Identification System is considered to be a biometric database.

Diff: 1

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

53) The Integrated Automated Fingerprint Identification System database contains fingerprints of those who have served in the armed forces or work in the federal government and law enforcement.

Diff: 1

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

54) The geographic information system combines layers of geographically referenced information about Earth's surface.

Diff: 2

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

55) A record is the combination of all the fields for a single entity.

Diff: 1

Objective: 11.1 Identify the Parts of a Database

56) A one-to-one relationship is the most common type of relationship.

Diff: 1

Objective: 11.2 Compare the Four Types of Databases

57) In a database, a(n) ________ represents a specific piece of information such as an email address.

Diff: 1

Objective: 11.1 Identify the Parts of a Database

58) The principle of ________ ensures that each transaction in a transaction-processing system is independent of all other transactions.

Diff: 1

Objective: 11.4 Discuss Important Types of Information Systems

59) A(n) ________ normally displays a single record and makes data entry easier.

Diff: 2

Objective: 11.1 Identify the Parts of a Database

60) A(n) ________ is used to retrieve specific data from one or more tables.

Diff: 1

Objective: 11.1 Identify the Parts of a Database

61) ________ is a decentralized electronic database of digital currency transactions.

Diff: 3

Objective: 11.4 Discuss Important Types of Information Systems

62) In a(n) ________ relationship, a record in one table is linked to a single record in another table.

Diff: 3

Objective: 11.2 Compare the Four Types of Databases

63) You would use a(n) ________ as a central repository for all the data that an organization uses.

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

64) ________ is used to discover relationships among data items to help predict sales.

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

65) In a(n) ________ relationship, multiple records from one table can link to multiple records in another table.

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

66) A(n) ________ table may be used to break a many-to-many relationship up into two one-to-many relationships.

Diff: 2

Objective: 11.2 Compare the Four Types of Databases

67) SQL stands for ________.

Diff: 3

Objective: 11.3 Explain Database Management Systems

68) Text, numbers, dates, images, and hyperlinks are examples of data ________.

Diff: 1

Objective: 11.3 Explain Database Management Systems

69) The process of reducing data redundancy is called data ________.

Diff: 2

Objective: 11.3 Explain Database Management Systems

70) OODB stands for ________.

Diff: 3

Objective: 11.3 Explain Database Management Systems

71) A(n) ________ defines the fields and the type of data each field contains.

Diff: 2

Objective: 11.3 Explain Database Management Systems

72) ________ include software and hardware that improve the productivity of employees by automating common tasks.

Diff: 1

Objective: 11.4 Discuss Important Types of Information Systems

73) A(n) ________ helps to automate tasks that employees perform, which increases productivity.

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

74) An expert system consists of a(n) ________ and an inference engine.

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

75) ________ is a type of data mining that analyzes the links that customers follow when they visit a website.

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

76) ________ refers to the collection of large amounts of data from multiple sources that are used for analysis and decision making.

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

77) ________ is a branch of science that attempts to make computers act like humans.

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

78) ________ is a national fingerprint and criminal history system maintained by the FBI.

Diff: 2

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

79) Business ________ tools are applications that are used to analyze data in information systems to help make decisions.

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

80) Applying information technology to the field of biology is called ________.

Diff: 2

Objective: 11.5 List Examples of Databases Used in Law Enforcement and Research

81) Vehicles that do not rely on any human intervention are known as ________ cars.

Diff: 2

Objective: 11.4 Discuss Important Types of Information Systems

82) Setting up rules for data entry which reduce entry errors is called data ________.

Diff: 2

Objective: 11.3 Explain Database Management Systems

83) A database ________ is a person who manages database systems.

Diff: 2

Objective: 11.3 Explain Database Management Systems

84) A(n) ________ system is the people, hardware, and software that support data-intensive applications.

Diff: 3

Objective: 11.4 Discuss Important Types of Information Systems

85) A(n) ________ information system is used by managers to organize, evaluate, and efficiently run their departments.

Diff: 3

Objective: 11.4 Discuss Important Types of Information Systems

86) Using a(n) ________ language allows a user to ask questions of a database.

Diff: 2

Objective: 11.3 Explain Database Management Systems

87) SELECT, FROM, WHERE, and AND are examples of ________ keywords.

Diff: 2

Objective: 11.3 Explain Database Management Systems

88) In a database, a(n) ________ stores records.

Diff: 1

Objective: 11.1 Identify the Parts of a Database

89) ________ databases are ideal for use with data warehouses and online analytical processing applications.

Diff: 3

Objective: 11.2 Compare the Four Types of Databases

90) Match each of the following parts of a database to its description:

I. form

II. report

III. query

IV. record

V. table

A. retrieves specific data from tables in a database

B. simplifies data entry

C. contains the information for a single entity

D. database object in which data is stored in rows and columns

E. displays data in an easy-to-read format and in print

Diff: 3

Objective: 11.1 Identify the Parts of a Database

91) Match each of the following terms to its description:

I. flat database

II. relational database

III. object-oriented database

IV. multidimensional database

V. data warehouse

A. simplest form of a database

B. information is structured into data cubes

C. data are stored as objects

D. consists of multiple tables that are related by common information

E. central repository for all enterprise data

Diff: 3

Objective: 11.2 Compare the Four Types of Databases

92) Match each of the following terms to its description:

I. data dictionary

II. data validation

III. data normalization

IV. SQL

V. DBMS

A. the process of reducing data redundancy

B. defines all the fields and the type of data contained in each field

C. language designed to create queries

D. reduces data-entry errors using prescribed rules

E. software used to create and manage data in a database

Diff: 3

Objective: 11.3 Explain Database Management Systems

93) Match each of the following terms to its description:

I. transaction-processing system (TPS)

II. office support system (OSS)

III. management information system (MIS)

IV. CODIS

V. IAFIS

A. provides information on daily operations

B. responds to user requests related to the exchange of goods, services, or money

C. improves productivity of employees by automating common tasks

D. national fingerprint and criminal history system

E. used by law enforcement to link cases and identify suspects

Diff: 3

Objective: Multiple objectives in the chapter

94) Match each of the following terms to its description:

I. primary key

II. clickstream

III. inference engine

IV. bioinformatics

V. artificial intelligence

A. set of rules for applying a knowledge base to each specific situation

B. branch of science concerned with making computers act like humans

C. data mining that analyzes the paths customers follow when they visit a website

D. field that uniquely identifies a record in a table

E. application of information technology to the science of biology

Diff: 3

Objective: Multiple objectives in the chapter

95) Match each of the following terms to its description:

I. big data

II. data mining

III. knowledge base

IV. query language

V. datacenter

A. contains expert knowledge and accumulated experience in a specific field

B. also known as a server farm

C. used to ask a question

D. collection of large amounts of data from multiple sources that is used for analysis and decision making

E. discovering relationships between data items

Diff: 3

Objective: Multiple objectives in the chapter