ESS7EtestbankCH05

1、chapter 5foundations of business intelligence: databases and information managementtrue-false questions1.each characteristic or quality describing a particular entity is called an attribute.answer:truedifficulty:easyreference:p. 1522.a grouping of characters into a word, a group of words, or a compl

2、ete number is called a record.answer:falsedifficulty:easyreference:p. 1533.every record in a file should contain at least one key field.answer:truedifficulty:easyreference:p. 1534.in a relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.

3、answer:truedifficulty:easyreference:p. 1555.dbms separate the logical and physical views of the data.answer:truedifficulty:mediumreference:p. 1576.many applications today require databases that can store and retrieve multimedia.answer:truedifficulty:easyreference:p. 1627.one of the drawbacks to oodb

4、ms is that they cannot work with applets.answer:falsedifficulty:mediumreference:p. 1628.oodbms are slower than relational dbms.answer:truedifficulty:mediumreference:p.1629.a data warehouse may include a legacy system.answer:truedifficulty:easyreference:p. 16210.a data warehouse is typically comprise

5、d of several smaller data marts.answer:falsedifficulty:easyreference:p. 16211.olap is a key tool of bi.answer:truedifficulty:easyreference:p. 16312.olap enables users to obtain online answers to ad hoc questions in a fairly rapid amount of time, except when the data are stored in very large database

6、s.answer:falsedifficulty:easyreference:p. 16413.data mining can be a challenge to individual privacy.answer:truedifficulty:easyreference:p. 16614.predictive analysis is a technique of data mining.answer:falsedifficulty:mediumreference: pp. 16615.middleware is used to transfer information from the or

7、ganizations internal database back to the web server for delivery in the form of a web page to the user.answer:truedifficulty:easyreference:p. 16816.a web interface requires changes to the internal database.answer:falsedifficulty:easyreference:p. 16817.common gateway interface is a specification for

8、 processing data on a web server.answer:truedifficulty:mediumreference:p. 16818.data administration is a very important organizational function, and is fairly easy to implement.answer:falsedifficulty:easyreference:p. 16919.a firms information policy lays out who is responsible for updating and maint

9、aining the information in a database system.answer:truedifficulty:easyreference: pp. 16920.data cleansing is the same process as data scrubbing.answer:truedifficulty:easyreference: pp. 172multiple-choice questions21.analyzewhich of the four generic strategies against competitive forces did 7-11 need

10、 to implement in order to manage the disadvantages it faced?a. customer and supplier intimacyb. product differentiationc. low-cost leadershipd. focus on market nicheanswer: cdifficulty:mediumreference: 150-151analyze in terms of categorize22.analyzefor which function was 7-11s new information system

11、 geared toward?a. supply chain managementb. sales and marketingc. production and manufacturingd. finance and accountinganswer: adifficulty:mediumreference: 150-151analyze in terms of categorize23.analyzewhat category best describes 7-11s new information system?a. tpsb. misc. kmsd. essanswer: bdiffic

12、ulty:mediumreference:p. 150-151analyze in terms of categorize24.analyze:an example of a pre-digital database is :a. a librarys card-catalog.b. a cash register receipt.c. a doctors office invoice.d. a list of sales totals on a spreadsheet.answer: adifficulty:mediumreference:p. 152analyze in terms of

13、categorize25.analyzewhich of the following best illustrates the relationship between entities and attributes?a. the entity customer with the attribute productb. the entity customer with the attribute purchasec. the entity product with the attribute purchased. the entity product with the attribute cu

14、stomeranswer: bdifficulty:hardreference:p. 152analyze in terms of categorize26.the type of logical database model that treats data as if they were stored in two-dimensional tables is the:a.oodbms.b.pre-digital dbms.c.relational dbms.d.hierarchical dbms.answer: cdifficulty:easyreference:p. 15227.anal

15、yzewhat are the relationships that the relational database is named for?a. relationship between rows and columnsb. relationships between entitiesc. relationships between tablesd. relationships between databasesanswer: bdifficulty:hardreference:p. 152-155analyze in terms of examine28.a characteristic

16、 or quality describing an entity is called a(n): a.field.b.tuple.c.key field.d.attribute.answer: ddifficulty:easyreference:p. 15229.the most basic business database is comprised of:a. three tables: a table for customers, a table for suppliers and parts, and a table for sales.b. four tables: a table

17、for customers, a table for suppliers, a table for parts, and a table for sales.c. four tables: a table for customers, a table for employees, a table for suppliers and parts, a table for sales.d. five tables: a table for customers, a table for employees, a table for suppliers, a table for parts, and

18、a table for sales.answer: ddifficulty:easyreference:p. 15330.in a table for customers, the information about a single customer would reside in a single:a. field.b. row.c. column.d. table.answer: bdifficulty:easyreference:p. 15331.in a relational database, a record is called a(n):a.tuple.b.row.c.enti

19、ty.d.field.answer: adifficulty:mediumreference:p. 15332.a field identified in a table as holding the unique identifier of the tables records is called the:a. primary key.b. key field.c. primary field.d. unique id.answer: adifficulty:easyreference:p. 15333.a field identified in a record as holding th

20、e unique identifier for that record is called the:a. primary key.b. key field.c. primary field.d. unique id.answer: bdifficulty:easyreference:p. 15334.duplicate data in multiple data files is:a.data redundancy.b.data multiplication.c.data independence.d.typical of a relational model.answer: adifficu

21、lty:easyreference:p. 15435.a schematic of the entire database that describes the relationships in a database is called a: a.data ersection relationship diagram.c.entity-relationship diagram.d.data definition diagram.answer: cdifficulty:mediumreference:p. 15436.a one-to-one relationsh

22、ip between two entities is symbolized in a diagram by a:a. line that ends in two short marks.b. line that ends in one short mark.c. line that ends with a crows foot.d. line that ends with a crows foot topped by a short mark.answer: adifficulty:hardreference:p. 15537.a one-to-many relationship betwee

23、n two entities is symbolized in a diagram by a:a. line that ends in two short marks.b. line that ends in one short mark.c. line that ends with a crows foot.d. line that ends with a crows foot topped by a short mark.answer: ddifficulty:hardreference:p. 15538.a table that links two tables that have a

24、many-to-many relationship is called a:a. derived table.b. intersection relation.c. foreign table.d. entity-relationship table.answer: bdifficulty:hardreference:p. 15539.the process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:a. normalization.b. data s

25、crubbing.c. data cleansing.d. data administration.answer: adifficulty:easyreference: p. 155-740.a dbms:a. makes the physical database available for different logical views.b. makes the logical database available for different analytical views.c. makes the physical database available for different an

26、alytical views.d. makes the relational database available for different analytical views.answer: adifficulty:mediumreference: p. 15741.the logical view:a.shows how data are organized and structured on the storage media.b.presents an entry screen to the user.c.allows the creation of supplementary rep

27、orts.d.presents data as they would be perceived by end users.answer: ddifficulty:mediumreference:p. 15742.dbms for midrange computers include all of the following except:a.db2.b.oracle.c.microsoft sql server.d.microsoft access.answer: ddifficulty:mediumreference:p. 15743.oracle database lite is a(n)

28、:a.dbms for small handheld computing devices.b.internet dbms.c.mainframe relational dbms.d.dbms for midrange computers.answer: adifficulty:mediumreference:p. 15744.access is a:a.dbms for small handheld computing devices.b.mainframe relational dbms.c.dbms for midrange computers.d.desktop relational d

29、bms.answer: ddifficulty:mediumreference:p. 15745.db2 is a(n):a.dbms for small handheld computing devices.b.internet dbms.c.mainframe relational dbms.d.dbms for desktop computers.answer: cdifficulty:mediumreference:p. 15746.microsoft sql server is a(n):a.dbms for small handheld computing devices.b.in

30、ternet dbms.c.desktop relational dbms.d.dbms for midrange computers.answer: ddifficulty:mediumreference:p. 15747.in a relational database, the three basic operations used to develop useful sets of data are:a.select, project, and where.b.select, join, and where.c.select, project, and join.d.select, f

31、rom, and join.answer: cdifficulty:mediumreference:p. 15848.the select operation:bines relational tables to provide the user with more information than is otherwise available.b.creates a subset consisting of columns in a table.c.identifies the table from which the columns will be selected.d.crea

32、tes a subset consisting of all records in the file that meets stated criteria.answer: ddifficulty:easyreference:p. 15849.the join operation:a.combines relational tables to provide the user with more information than is otherwise available.b.identifies the table from which the columns will be selecte

33、d.c.creates a subset consisting of columns in a table.d.organizes elements into segments.answer: adifficulty:easyreference:p. 15850.the project operation:a.combines relational tables to provide the user with more information than is otherwise available.b.creates a subset consisting of columns in a t

34、able.c.organizes elements into segments.d.identifies the table from which the columns will be selected.answer: bdifficulty:easyreference:p. 15851.the specialized language programmers use to add and change data in the database is called : a.data dictionary language.b.data manipulation language.c.stru

35、ctured query language.d.data definition language.answer: bdifficulty:easyreference:p. 16052.the most prominent data manipulation language today is:a.access.b.db2c.sql.d.crystal reportsanswer: cdifficulty:mediumreference:p. 16053.the data dictionary serves as an important data management tool by:a.as

36、signing attributes to the data.b.creating an inventory of data contained in the database.c.presenting data as end users or business specialists would perceive them.d.maintaining data in updated form.answer: bdifficulty:mediumreference:p. 16054.an automated or manual file that stores information abou

37、t data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:a.data dictionary.b.data definition diagramc.entity-relationship diagramd.relationship dictionaryanswer: adifficulty:mediumreference:p. 16055.dbmss typically include report-

38、generating tools in order to:a. retrieve and display data.b. display data in an easier-to-read format.c. display data in graphs.d. perform predictive analysis.answer: bdifficulty:mediumreference:p. 16156.the type of database management approach that can handle multimedia is the:a.hierarchical dbms.b

39、.relational dbms.work dbms.d.object-oriented dbms.answer: ddifficulty:easyreference:p. 16257.which of the following database types is useful for storing java applets as well as typical business data?a.relational dbmsb.hierarchical dbmsc.object-relational dbmsd.oodbmsanswer: cdifficulty:mediumre

40、ference:p. 16258.a data warehouse is composed of:a.historical datab.current datac.internal and external data sources.d.historic and current internal dataanswer: ddifficulty:mediumreference:p. 16359.a data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:a.

41、a data mart typically focuses on a single subject area or line of business.b.all the information is historical.c.a data mart uses a web interfaced.all of the information belongs to a single company.answer: adifficulty:easyreference:p. 16360.tools for consolidating, analyzing, and providing access to

42、 vast amounts of data to help users make better business decisions are known as:a. dssb. business intelligencec. olpd. data mininganswer: bdifficulty:mediumreference:p. 16361.the tool that enables users to view the same data in different ways using multiple dimensions is:a.predictive analysisb.sqlc.

43、olapd.data mininganswer: cdifficulty:hardreference:p. 16462.olap is a tool for enabling:a. users to obtain online answers to ad hoc questions in a rapid amount of time.b. users to view both logical and physical views of data.c. programmers to quickly diagram data relationships.d. programmers to norm

44、alize data.answer: adifficulty:easyreference:p. 16463.data mining is a tool for allowing users to:a. quickly compare transaction data gathered over many years.b. find hidden relationships in data.c. obtain online answers to ad hoc questions in a rapid amount of time.d. summarize massive amounts of d

45、ata into much smaller, traditional reports.answer: bdifficulty:easyreference:p. 16564.in terms of data relationships, associations refers to:a. events linked over time.b. patterns that describe a group to which an item belongs.c. occurrences linked to a single event.d. undiscovered groupings.answer:

46、 cdifficulty:mediumreference: p. 165-6 65.analyzeas described in the chapter text, which competitive force was banco de credito peru facing?a. substitute productsb. customers bargaining powerc. suppliers bargaining powerd. threat of new entrantsanswer: ddifficulty:hardreference: p. 167analyze in ter

47、ms of categorize66.analyzeas described in the chapter text, which of the following strategies best describes banco de credito perus tactics in overcoming the competitive forces it was facing?a. low-cost leadershipb. product differentiationc. focus on market niched. strengthen customer and supplier i

48、ntimacyanswer: ddifficulty:hardreference: p. 167analyze in terms of categorize67.an alternative to using application server software for interfacing between a web server and back-end databases is:a.cgi.b.html.c.java.d.sql.answer: adifficulty:easyreference:p. 16868.the confusion created by _ makes it

49、 difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.a.batch processingb.data redundancyc.data independenced.online processinganswer: bdifficulty:easyreference:p. 17069.which common database cha

50、llenge is illustrated by the texts discussion of downloading digital music?a. data normalizationb. data accuracyc. connecting to legacy systemsd. poor data analysisanswer: bdifficulty:easyreference:p. 17170.detecting and correcting data in a database or file that are incorrect, incomplete, improperl

51、y formatted, or redundant is called:a.data auditing.b.defragmentationc.data scrubbingd.data optimizationanswer: cdifficulty:easyreference:p. 17271.evaluatewhich was the greater challenge of the four facing the fbi in its drive to create a unified information system?a. data definitionb. data redundan

52、cyc. outdated legacy systemsd. poor information policiesanswer: ddifficulty:hardreference: p. 175-77evaluate in terms of assess72.synthesiswhat is the first step you should take in managing data for a firm?a. identify the data needed to run the businessb. cleanse the data before importing it to any

53、databasec. normalize the data before importing to a databased. audit your data qualityanswer: adifficulty:mediumreference:p. 172synthesis in terms of assemble, planfill in the blanks73.databases record information about general categories of information referred to as entities.difficulty: easyreference:p. 15274.relational databases organize data into two-dimensional tables with columns and rows.difficulty: easyreference:p. 15275.a(n) attribute is a piece of information describing a particular entity.difficulty: easyreference:p