mis12-信息系统复习参考6.doc

1、Management Information Systems, 12e (Laudon)Chapter 6 Foundations of Business Intelligence: Databases and Information Management1) A grouping of characters into a word, a group of words, or a complete number is called a record.Answer: FALSEDiff: 1Page Ref: 210AACSB: Use of ITCASE: ContentObjective:

2、6.32) Each characteristic or quality describing a particular entity is called an attribute.Answer: TRUEDiff: 1Page Ref: 210AACSB: Use of ITCASE: ContentObjective: 6.33) Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes i

3、n programs require changes to the data.Answer: TRUEDiff: 2Page Ref: 211AACSB: Use of ITCASE: ContentObjective: 6.14) A DBMS separates the logical and physical views of data. Answer: TRUEDiff: 2Page Ref: 212AACSB: Use of ITCASE: ContentObjective: 6.25) Every record in a file should contain at least o

4、ne key field.Answer: TRUEDiff: 1Page Ref: 214AACSB: Use of ITCASE: ContentObjective: 6.36) Many applications today require databases that can store and retrieve multimedia.Answer: TRUEDiff: 1Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.27) One of the drawbacks to OODBMS are that they canno

5、t work with applets.Answer: FALSEDiff: 2Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.28) OODBMS are slower than relational DBMS.Answer: TRUEDiff: 2Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.29) A data dictionary is a language associated with a database management system that en

6、d users and programmers use to manipulate data in the database.Answer: FALSEDiff: 1Page Ref: 217AACSB: Use of ITCASE: ContentObjective: 6.210) In a relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships.Answer: TRUEDiff: 1Page Ref: 220AACSB

7、: Use of ITCASE: ContentObjective: 6.311) A data warehouse may be updated by a legacy system.Answer: TRUEDiff: 1Page Ref: 222AACSB: Use of ITCASE: ContentObjective: 6.412) A data warehouse is typically comprised of several smaller data marts.Answer: FALSEDiff: 2Page Ref: 223AACSB: Use of ITCASE: Con

8、tentObjective: 6.413) OLAP is a key tool of BI.Answer: TRUEDiff: 2Page Ref: 224AACSB: Use of ITCASE: ContentObjective: 6.414) 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 databases.Answer: FALSEDiff: 2

9、Page Ref: 224AACSB: Use of ITCASE: ContentObjective: 6.415) Predictive analysis is synonymous with data mining.Answer: FALSEDiff: 3Page Ref: 226AACSB: Use of ITCASE: ContentObjective: 6.416) In a Web-based database, middleware is used to transfer information from the organizations internal database

10、back to the Web server for delivery in the form of a Web page to the user.Answer: TRUEDiff: 2Page Ref: 229AACSB: Use of ITCASE: ContentObjective: 6.417) The disadvantage of using a Web interface for a database is that it typically requires substantial changes to the internal database.Answer: FALSEDi

11、ff: 1Page Ref: 229AACSB: Use of ITCASE: ContentObjective: 6.418) Common Gateway Interface is a specification for processing data on a Web server.Answer: TRUEDiff: 2Page Ref: 2931AACSB: Use of ITCASE: ContentObjective: 6.419) Data administration is a special organizational function that manages the p

12、olicies and procedures through which data can be managed as an organizational resource.Answer: TRUEDiff: 2Page Ref: 230AACSB: Use of ITCASE: ContentObjective: 6.520) Data cleansing is the same process as data scrubbing.Answer: TRUEDiff: 1Page Ref: 231AACSB: Use of ITCASE: ContentObjective: 6.521) Wh

13、ich 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 CUSTOMERAnswer: BDiff: 3

14、Page Ref: 210AACSB: Analytic SkillsCASE: AnalysisObjective: 6.322) Which of the following is not one of the main problems with a traditional file environment?A) data inconsistencyB) program-data independenceC) lack of flexibility in creating ad-hoc reportsD) poor securityAnswer: BDiff: 2Page Ref: 21

15、1AACSB: Use of ITCASE: AnalysisObjective: 6.123) A DBMS reduces data redundancy and inconsistency by A) enforcing referential integrity. B) uncoupling program and data.C) utilizing a data dictionary. D) minimizing isolated files with repeated data.Answer: DDiff: 3Page Ref: 213AACSB: Use of ITCASE: C

16、ontentObjective: 6.124) A characteristic or quality describing an entity is called a(n)A) field.B) tuple.C) key field.D) attribute.Answer: DDiff: 1Page Ref: 210AACSB: Use of ITCASE: ContentObjective: 6.325) Which of the following non-digital data storage items is most similar to a database?A) librar

17、y card catalogB) cash register receiptC) doctors office invoiceD) list of sales totals on a spreadsheetAnswer: ADiff: 2Page Ref: 210-211AACSB: Analytic SkillsCASE: AnalysisObjective: 6.126) The confusion created by _ makes it difficult for companies to create customer relationship management, supply

18、 chain management, or enterprise systems that integrate data from different sources.A) batch processingB) data redundancyC) data independenceD) online processingAnswer: BDiff: 1Page Ref: 211AACSB: Use of ITCASE: ContentObjective: 6.127) Duplicate data in multiple data files is called data _.A) redun

19、dancyB) repetitionC) independenceD) partitionsAnswer: ADiff: 1Page Ref: 211AACSB: Use of ITCASE: ContentObjective: 6.128) A DBMS makes theA) physical database available for different logical views.B) logical database available for different analytical views.C) physical database available for differe

20、nt analytical views.D) logical database available for different physical views.Answer: ADiff: 2Page Ref: 212AACSB: Use of ITCASE: ContentObjective: 6.229) The logical viewA) shows how data are organized and structured on the storage media.B) presents an entry screen to the user.C) allows the creatio

21、n of supplementary reports.D) presents data as they would be perceived by end users.Answer: DDiff: 2Page Ref: 212AACSB: Use of ITCASE: ContentObjective: 6.230) DBMS for midrange computers include all of the following EXCEPTA) DB2.B) Oracle.C) Microsoft SQL Server.D) Microsoft Access.Answer: DDiff: 3

22、Page Ref: 213AACSB: Use of ITCASE: ContentObjective: 6.231) The type of logical database model that treats data as if they were stored in two-dimensional tables is theA) OODBMS.B) pre-digital DBMS.C) relational DBMS.D) hierarchical DBMS.Answer: CDiff: 1Page Ref: 213AACSB: Use of ITCASE: ContentObjec

23、tive: 6.232) Oracle Database Lite is a(n)A) DBMS for small handheld computing devices.B) Internet DBMS.C) mainframe relational DBMS.D) DBMS for midrange computers.Answer: ADiff: 3Page Ref: 213AACSB: Use of ITCASE: ContentObjective: 6.233) Microsoft SQL Server is a(n)A) DBMS for small handheld comput

24、ing devices.B) Internet DBMS.C) desktop relational DBMS.D) DBMS for midrange computers.Answer: DDiff: 3Page Ref: 213AACSB: Use of ITCASE: ContentObjective: 6.234) In a table for customers, the information about a single customer would reside in a singleA) field.B) row.C) column.D) table.Answer: BDif

25、f: 1Page Ref: 214AACSB: Use of ITCASE: AnalysisObjective: 6.335) In a relational database, a record is referred to in technical terms as a(n)A) tuple.B) row.C) entity.D) field.Answer: ADiff: 2Page Ref: 214AACSB: Use of ITCASE: ContentObjective: 6.336) A field identified in a table as holding the uni

26、que identifier of the tables records is called theA) primary key.B) key field.C) primary field.D) unique ID.Answer: ADiff: 2Page Ref: 214AACSB: Use of ITCASE: ContentObjective: 6.337) A field identified in a record as holding the unique identifier for that record is called theA) primary key.B) key f

27、ield.C) primary field.D) unique ID.Answer: BDiff: 2Page Ref: 214AACSB: Use of ITCASE: ContentObjective: 6.338) In a relational database, the three basic operations used to develop useful sets of data areA) select, project, and where.B) select, join, and where.C) select, project, and join.D) select,

28、from, and join.Answer: CDiff: 2Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.339) The select operationA) combines 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 t

29、he columns will be selected.D) creates a subset consisting of all records in the file that meet stated criteria.Answer: DDiff: 1Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.340) The join operationA) combines relational tables to provide the user with more information than is otherwise avai

30、lable.B) identifies the table from which the columns will be selected.C) creates a subset consisting of columns in a table.D) organizes elements into segments.Answer: ADiff: 1Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.341) The project operationA) combines relational tables to provide the user with more information than is otherwise available.B) creates a