1、mis12 信息系统复习参考6Management 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: 1 Page Ref: 210AACSB: Use of ITCASE: Co
2、ntentObjective: 6.32) Each characteristic or quality describing a particular entity is called an attribute.Answer: TRUEDiff: 1 Page 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 su
3、ch that changes in programs require changes to the data.Answer: TRUEDiff: 2 Page Ref: 211AACSB: Use of ITCASE: ContentObjective: 6.14) A DBMS separates the logical and physical views of data. Answer: TRUEDiff: 2 Page Ref: 212AACSB: Use of ITCASE: ContentObjective: 6.25) Every record in a file should
4、 contain at least one key field.Answer: TRUEDiff: 1 Page Ref: 214AACSB: Use of ITCASE: ContentObjective: 6.36) Many applications today require databases that can store and retrieve multimedia.Answer: TRUEDiff: 1 Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.27) One of the drawbacks to OODBM
5、S are that they cannot work with applets.Answer: FALSEDiff: 2 Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.28) OODBMS are slower than relational DBMS.Answer: TRUEDiff: 2 Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.29) A data dictionary is a language associated with a database ma
6、nagement system that end users and programmers use to manipulate data in the database.Answer: FALSEDiff: 1 Page 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: TRUED
7、iff: 1 Page Ref: 220AACSB: Use of ITCASE: ContentObjective: 6.311) A data warehouse may be updated by a legacy system.Answer: TRUEDiff: 1 Page Ref: 222AACSB: Use of ITCASE: ContentObjective: 6.412) A data warehouse is typically comprised of several smaller data marts.Answer: FALSEDiff: 2 Page Ref: 2
8、23AACSB: Use of ITCASE: ContentObjective: 6.413) OLAP is a key tool of BI.Answer: TRUEDiff: 2 Page 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 da
9、tabases.Answer: FALSEDiff: 2 Page Ref: 224AACSB: Use of ITCASE: ContentObjective: 6.415) Predictive analysis is synonymous with data mining.Answer: FALSEDiff: 3 Page Ref: 226AACSB: Use of ITCASE: ContentObjective: 6.416) In a Web-based database, middleware is used to transfer information from the or
10、ganizations internal database back to the Web server for delivery in the form of a Web page to the user.Answer: TRUEDiff: 2 Page 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 in
11、ternal database.Answer: FALSEDiff: 1 Page Ref: 229AACSB: Use of ITCASE: ContentObjective: 6.418) Common Gateway Interface is a specification for processing data on a Web server.Answer: TRUEDiff: 2 Page Ref: 2931AACSB: Use of ITCASE: ContentObjective: 6.419) Data administration is a special organizat
12、ional function that manages the policies and procedures through which data can be managed as an organizational resource.Answer: TRUEDiff: 2 Page Ref: 230AACSB: Use of ITCASE: ContentObjective: 6.520) Data cleansing is the same process as data scrubbing.Answer: TRUEDiff: 1 Page Ref: 231AACSB: Use of
13、ITCASE: ContentObjective: 6.521) Which 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
14、 attribute CUSTOMERAnswer: BDiff: 3 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
15、securityAnswer: BDiff: 2 Page Ref: 211AACSB: 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:
16、3 Page Ref: 213AACSB: Use of ITCASE: ContentObjective: 6.124) A characteristic or quality describing an entity is called a(n)A) field.B) tuple.C) key field.D) attribute.Answer: DDiff: 1 Page Ref: 210AACSB: Use of ITCASE: ContentObjective: 6.325) Which of the following non-digital data storage items
17、is most similar to a database?A) library card catalogB) cash register receiptC) doctors office invoiceD) list of sales totals on a spreadsheetAnswer: ADiff: 2 Page Ref: 210-211AACSB: Analytic SkillsCASE: AnalysisObjective: 6.126) The confusion created by _ makes it difficult for companies to create
18、customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.A) batch processingB) data redundancyC) data independenceD) online processingAnswer: BDiff: 1 Page Ref: 211AACSB: Use of ITCASE: ContentObjective: 6.127) Duplicate data in mult
19、iple data files is called data _.A) redundancyB) repetitionC) independenceD) partitionsAnswer: ADiff: 1 Page 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.
20、C) physical database available for different analytical views.D) logical database available for different physical views.Answer: ADiff: 2 Page 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 ent
21、ry screen to the user.C) allows the creation of supplementary reports.D) presents data as they would be perceived by end users.Answer: DDiff: 2 Page Ref: 212AACSB: Use of ITCASE: ContentObjective: 6.230) DBMS for midrange computers include all of the following EXCEPTA) DB2.B) Oracle.C) Microsoft SQL
22、 Server.D) Microsoft Access.Answer: DDiff: 3 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: 1 P
23、age Ref: 213AACSB: Use of ITCASE: ContentObjective: 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: 3 Page Ref: 213AACSB: Use of ITCASE: ContentObjective: 6.233) Microsoft SQL
24、Server is a(n)A) DBMS for small handheld computing devices.B) Internet DBMS.C) desktop relational DBMS.D) DBMS for midrange computers.Answer: DDiff: 3 Page Ref: 213AACSB: Use of ITCASE: ContentObjective: 6.234) In a table for customers, the information about a single customer would reside in a singl
25、eA) field.B) row.C) column.D) table.Answer: BDiff: 1 Page 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: 2 Page Ref: 214AACSB: Use of ITCASE: ContentObjective: 6.336
26、) A field identified in a table as holding the unique identifier of the tables records is called theA) primary key.B) key field.C) primary field.D) unique ID.Answer: ADiff: 2 Page Ref: 214AACSB: Use of ITCASE: ContentObjective: 6.337) A field identified in a record as holding the unique identifier f
27、or that record is called theA) primary key.B) key field.C) primary field.D) unique ID.Answer: BDiff: 2 Page 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
28、, and where.C) select, project, and join.D) select, from, and join.Answer: CDiff: 2 Page 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 co
29、lumns in a table.C) identifies the table from which the columns will be selected.D) creates a subset consisting of all records in the file that meet stated criteria.Answer: DDiff: 1 Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.340) The join operationA) combines relational tables to provide
30、 the user with more information than is otherwise available.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: 1 Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.341) The projec
31、t 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) organizes elements into segments.D) identifies the table from which the columns will be selected.Answer: BDiff: 1 Page Ref: 215AACSB: Use
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1