Information Systems International Edition 10th Edition by Ralph M. Stair - Test Bank

Information Systems International Edition 10th Edition by Ralph M. Stair – Test Bank

 

Instant Download – Complete Test Bank With Answers

 

 

Sample Questions Are Posted Below

 

Chapter 05: Database Systems, Data Centers, and Business Intelligence

 

TRUE/FALSE

 

1. A database provides an essential foundation for an organization’s information and decision support systems.

 

ANS:  T                    PTS:   1

 

2. A DBMS provides one of many points of management and control over data resources.

 

ANS:  F                    PTS:   1

 

3. An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

 

ANS:  F                    PTS:   1

 

4. A collection of fields about a specific object is a record.

 

ANS:  T                    PTS:   1

 

5. Today, most organizations use the database approach to data management, where multiple information systems share a pool of related data.

 

ANS:  T                    PTS:   1

 

6. A database need not reflect the business processes of the organization.

 

ANS:  F                    PTS:   1

 

7. Due to their size, databases must be stored on mainframe computers or other large, powerful computers.

 

ANS:  F                    PTS:   1

 

8. Data centers are approaching the point of automation, where they can run and manage themselves while being monitored remotely in a “lights out” environment.

 

ANS:  T                    PTS:   1

 

9. Business and technology vendors are working to develop blue data centers that run more efficiently and require less energy for processing and cooling.

 

ANS:  F                    PTS:   1

 

10. Identification of who will have access to a database has little impact on organizing a database.

 

ANS:  F                    PTS:   1

11. Carrying summary totals in the data records is an example of planned data redundancy.

 

ANS:  T                    PTS:   1

 

12. Entity-relationships diagrams are a useful database design tool.

 

ANS:  T                    PTS:   1

 

13. The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

 

ANS:  F                    PTS:   1

 

14. Oracle is currently the market leader in general purpose databases, with about three-fourths of the multibillion dollar database market.

 

ANS:  F                    PTS:   1

 

15. In the relational model, each row of a table represents a data entity or reocrd and each column of the table represents an attribute or field.

 

ANS:  T                    PTS:   1

 

16. The domain for payrate would include both positive and negative numbers.

 

ANS:  F                    PTS:   1

 

17. Projecting involves eliminating columns in a table.

 

ANS:  T                    PTS:   1

 

18. One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically.

 

ANS:  T                    PTS:   1

 

19. Database management systems cost in excess of one thousand dollars.

 

ANS:  F                    PTS:   1

 

20. One of the first steps in installing and using a large database involves “telling” the DBMS the logical and physical structure of the data and the relationships among the data for each user.

 

ANS:  T                    PTS:   1

 

21. The DBMS serves as an interface between an application program and the database.

 

ANS:  T                    PTS:   1

 

 

22. The Database Administrator decides the contents of the database with little or no input from the users of the database.

 

ANS:  F                    PTS:   1

 

23. The raw data necessary to make sound business decisions is stored in a variety of locations and formats.

 

ANS:  T                    PTS:   1

 

24. A data warehouse stores historical data that has been extracted from operational systems and external sources.

 

ANS:  T                    PTS:   1

 

25. A data warehouse is used to support decision making while an OLTP database is used to support transaction processing.

 

ANS:  T                    PTS:   1

 

26. Data mining involves the automated discovery of patterns and relationships in a data warehouse.

 

ANS:  T                    PTS:   1

 

27. The analysis of data on user traffic through an organization’s Web site is an example of data mining.

 

ANS:  T                    PTS:   1

 

28. Business intelligence turns data into useful information that then is kept closely guarded to avoid this information from falling into the hands of the wrong employees.

 

ANS:  F                    PTS:   1

 

29. Competitive intelligence is gained through industrial espionage and the gathering of this information often includes illegal or unethical means.

 

ANS:  F                    PTS:   1

 

30. Online Analytical Processing and data mining are essentially the same thing.

 

ANS:  F                    PTS:   1

 

 

MULTIPLE CHOICE

 

1. A database ____.

a.	helps companies reduce costs, increase profits, track past business activities, and open new market opportunities
b.	provides an essential foundation for an organization’s knowledge management and artificial intelligence systems
c.	provides an interface between the database and computer hardware
d.	both a. and c.

 

 

ANS:  A                    PTS:   1

 

2. The smallest piece of data used by a computer is the ____.

a.	terrabyte	c.	character
b.	field	d.	bit

 

 

ANS:  D                    PTS:   1

 

3. A database is a collection of integrated and related ____.

a.	fields	c.	records
b.	files	d.	attributes

 

 

ANS:  B                    PTS:   1

 

4. A collection of fields about a specific object is a(n) ____.

a.	attribute	c.	record
b.	file	d.	primary key

 

 

ANS:  C                    PTS:   1

 

5. The DBMS organizes the data independently of the application program, so the application is not affected by the location or type of data.  This is an example of ____.

a.	improved data integrity	c.	data and program independence
b.	shared data and information resources	d.	better overall protection of the data

 

 

ANS:  C                    PTS:   1

 

6. A tool that database designers use to show the logical relationships among data is a(n) ____.

a.	data model	c.	relational model
b.	entity-relationship diagram	d.	all of the above

 

 

ANS:  D                    PTS:   1

 

7. Basic data manipulations include ____ which involves eliminating rows in a relational database.

a.	selecting	c.	projecting
b.	joining	d.	linking

 

 

ANS:  A                    PTS:   1

 

 

8. As long as the tables in a relational database share one common ____, the tables can be linked to provide useful information and reports.

a.	primary key	c.	characteristic
b.	file	d.	attribute

 

 

ANS:  D                    PTS:   1

 

9. The ____ is a description that involves “telling” the DBMS the logical and physical structure of the data and the relationships among the data for each user.

a.	entity relationship diagram	c.	data model
b.	schema	d.	data manipulation language

 

 

ANS:  B                    PTS:   1

 

10. ____ is a visual approach to developing database requests.

a.	Concurrency control	c.	Data definition language
b.	Query by example	d.	Data manipulation language

 

 

ANS:  B                    PTS:   1

 

11. ____ is a standardized data manipulation language developed in the 1970s that allows programmers to use one powerful language and use it on a variety of systems.

a.	Query by example	c.	DML
b.	Access	d.	SQL

 

 

ANS:  D                    PTS:   1

 

12. Someone responsible for planning, designing, creating, operating, securing, monitoring, and maintaining databases is called a ____.

a.	data administrator	c.	data owner
b.	data analyst	d.	database administrator

 

 

ANS:  D                    PTS:   1

 

13. The ____ position is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

a.	data analyst	c.	database administrator
b.	data administrator	d.	data owner

 

 

ANS:  B                    PTS:   1

 

14. With ____, the database is stored on a service provider’s server and accessed by the client over a network, typically the Internet.

a.	Internet access	c.	Software as a Service
b.	Database as a Service	d.	Oracle

 

 

ANS:  B                    PTS:   1

 

 

15. The process of selecting the best database management system for an organization considers ____.

a.	the ability to work seamlessly with other applications and databases
b.	the reputation and financial stability of the database vendor
c.	information needs of the organization
d.	all of the above

 

 

ANS:  D                    PTS:   1

 

16. Data warehouses allow managers to ____ to get increasing levels of detail about business conditions.

a.	roll up	c.	slice and dice
b.	drill down	d.	extract data

 

 

ANS:  B                    PTS:   1

 

17. A(n) ____ typically stores three to ten years of historical summary data records from many operational systems and external data sources so that it can be used for business analysis.

a.	organizational file	c.	data warehouse
b.	database	d.	knowledge base

 

 

ANS:  C                    PTS:   1

 

18. A(n) ____ contains a subset of data for a single aspect of a company’s business and are used by smaller groups who want to access detailed data for business analysis.

a.	OLTP database	c.	data mart
b.	data warehouse	d.	data mine

 

 

ANS:  C                    PTS:   1

 

19. ____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.

a.	Data mining	c.	Competitive intelligence
b.	DBMS	d.	Data loss prevention

 

 

ANS:  A                    PTS:   1

 

20. ____ is an application of data mining that identifies the products and services most commonly purchased at the same time.

a.	Customer churn	c.	Market basket analysis
b.	Direct marketing	d.	None of the above

 

 

ANS:  C                    PTS:   1

 

21. ____ describes the steps an organization takes to protect information sought by “hostile” intelligence gathers.

a.	Data loss prevention	c.	Counterintelligence
b.	Trade secret	d.	Competitive intelligence

 

 

ANS:  C                    PTS:   1

 

 

22. A database in which data can be spread across several smaller databases connected through telecommunications devices is called a(n) ____.

a.	data mart	c.	replicated database
b.	distributed database	d.	data synchronization

 

 

ANS:  B                    PTS:   1

 

23. ____ employs multidimensional databases and analytics to store and deliver data warehouse information efficiently.

a.	Distributed databases	c.	Data marts
b.	OLAP	d.	Data mining

 

 

ANS:  B                    PTS:   1

 

24. Companies such as IBM have developed ____ database systems to allow different databases to work together as a unified database system.

a.	Relational	c.	Replicated
b.	Distributed	d.	Virtual

 

 

ANS:  D                    PTS:   1

 

25. ____ involves using a database to store and access data according to the locations it describes and to permit spatial queries and analysis.

a.	Data mining	c.	Virtual database system
b.	Federated database system	d.	Spatial data technology

 

 

ANS:  D                    PTS:   1

 

COMPLETION

 

1. Without a well-designed, accurate database, executives, managers, and others do not have access to the ____________________ they need to make good decisions.

 

ANS:  information

 

PTS:   1

 

2. A report from IDC estimates that the amount of information humanity creates will grow by a factor of ____________________ between 2009 and 2020.

 

ANS:  44

 

PTS:   1

 

3. A(n) ____________________ is typically a name, number, or combination of characters that describes an aspect of a business object.

 

ANS:

field

attribute

 

PTS:   1

4. A collection of related records is called a(n) ____________________.

 

ANS:  file

 

PTS:   1

 

5. A(n) ____________________ is a field or set of fields that uniquely identifies a record.

 

ANS:  primary key

 

PTS:   1

 

6. Better access to data and information and improved data integrity are two advantages of the ____________________ approach.

 

ANS:  database

 

PTS:   1

 

7. A(n) ____________________ is a climate controlled building that house database servers and systems that deliver mission critical information and services.

 

ANS:  data center

 

PTS:   1

 

8. A data center that is fully automated to the extend that they can run and manage themselves while being monitored remotely are said to operate in a(n) ____________________ environment.

 

ANS:  lights out

 

PTS:   1

 

9. A database design where certain data entities are combined, summary totals are carried in the data records rather than calculated, and some data attributes are repeated in more that one data entity exhibits what is called planned ____________________.

 

ANS:  data redundancy

 

PTS:   1

 

10. The ____________________ data model has become the most popular database model.

 

ANS:  relational

 

PTS:   1

 

 

11. In the relational data model, each column of a table represents a(n) ____________________.

 

ANS:

attribute

field

 

PTS:   1

 

12. The allowable values for an attribute are called its ____________________.

 

ANS:  domain

 

PTS:   1

 

13. ____________________ involves combining two or more tables in a relational database.

 

ANS:  Joining

 

PTS:   1

 

14. The purpose of ____________________ is to develop data that is accurate, complete, economical, flexible, reliable, relevant, simple, timely, verifiable, accessible, and secure.

 

ANS:  data cleanup

 

PTS:   1

 

15. A(n) ____________________ is a simple database program whose records have no relationship to one another and are often used to store a single table or file.

 

ANS:  flat file

 

PTS:   1

 

16. The ____________________ is a collection of instructions and commands used to describe the logical and physical structure of the data and the relationships among the data for each user.

 

ANS:  data definition language

 

PTS:   1

 

17. The data ____________________ is a detailed description of all data used in the database.

 

ANS:  dictionary

 

PTS:   1

 

18. ____________________ control can be used to avoid potential problems when two or more users attempt to access the same record at the same time.

 

ANS:  Concurrency

 

PTS:   1

 

19. The commands that are used to manipulate the database are part of the ____________________ language.

 

ANS:  data manipulation

 

PTS:   1

 

20. ____________________ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest mainframe computers.

 

ANS:  SQL

 

PTS:   1

 

21. Public clouds are accessible to the ____________________ over the Internet.

 

ANS:  public

 

PTS:   1

 

22. The reputation and financial stability of the database ____________________ is important in selecting the proper DBMS.

 

ANS:  vendor

 

PTS:   1

 

23. Developing a seamless integration of databases with the Internet is sometimes called a ____________________.

 

ANS:  semantic Web

 

PTS:   1

 

24. A(n) ____________________ is a subset of a data warehouse.

 

ANS:  data mart

 

PTS:   1

 

25. ____________________ is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.

 

ANS:  Predictive analysis

 

PTS:   1

 

 

ESSAY

 

1. Briefly describe the hierarchy of data.

 

ANS:

Together bits, characters, fields, records, files, and databases form the hierarchy of data.  A bit is the smallest piece of data used by a computer and represents a zero or one.  Bits can be organized into units called bytes, typically eight bits.  Each byte represents a character.  Characters are put together to form a field, a combination of characters that describes an aspect of a business object.  A collection of data fields all related to one object, activity, or individual is called a record.  A collection of related records is called a file. At the highest level in the data hierarchy is a database, a collection of integrated and related files.

 

PTS:   1

 

2. Differentiate between the traditional and database approach to data management.

 

ANS:

At one time, information systems referenced specific files containing relevant data.  Each distinct operational system used data files dedicated to that system.  For example, the payroll system used the payroll file and it was the only system to use that file.  Today, most organizations use the database approach to data management, where multiple information systems share a pool of related data.  For example, the Human Resources database contains lots of data about employees and it is accessed for use by many different functions including payroll, personnel, training, etc.

 

PTS:   1

 

3. Identify ten advantages of the database approach to data management.

 

ANS:

Use of the database approach to data management provides the following advantages:

1. Improved strategic use of corporate data
2. Reduced data redundancy
3. Improved data integrity
4. Easier modification and updating
5. Data and program independence
6. Better access to data and information
7. Standardization of data access
8. A framework for program development
9. Better overall protection of the data
10. Shared data and information resources

 

PTS:   1

 

 

4. Briefly describe the relational data model.

 

ANS:

The relational data model describes data using a standard tabular format; all data elements are placed in two-dimensional tables called relations, which are the logical equivalent of files.  The tables in relational databases organize data in rows and columns, simplifying data access and manipulation.  In the relational model, each row of a table represents a data entity or record.  Each column represents an attribute or field.  After entering data into a relational database, users can make inquiries and analyze data through use of the selection, projection, and joining functions.  Selection involves removing rows according to certain criteria.  Projection involves eliminating columns in a table.  Joining involves combining two or more tables.

 

PTS:   1

 

5. Define the term data mining and identify its objectives.

 

ANS:

Data mining is an information analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.  It sifts through mountains of data to find a few nuggets of valuable information.  Its objective is to extract patterns, trends, and rules from data warehouses to evaluate proposed business strategies, which will improve competitiveness, increase profits, and transform business processes.

 

PTS:   1