mis12-信息系统复习参考6

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: 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 in 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 one 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 cannot 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 end 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: 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: ContentObjective: 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: 2Page 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 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: FALSEDiff: 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 policies 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) 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 attribute CUSTOMERAnswer: BDiff: 3Page 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: 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: 3Page 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: 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) library 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 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) redundancyB) 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 different 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 creation 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: 3Page 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: 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: 3Page Ref: 213AACSB: Use of ITCASE: ContentObjective: 6.233) Microsoft SQL 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: 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: BDiff: 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 unique 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 field.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, 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 the 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 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: 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 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: 1Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.342) You are creating a video and animation sharing Web site whose content will be supplied by content, video, and applets stored in a database and you anticipate very high loads on the server. Which of the following DBMSs will most likely serve your needs?A) object-relational DBMSB) relational DBMSC) hierarchical DBMSD) OODBMSAnswer: ADiff: 2Page Ref: 215AACSB: Use of ITCASE: AnalysisObjective: 6.343) The type of database management approach that can handle multimedia is theA) hierarchical DBMS.B) relational DBMS.C) network DBMS.D) object-oriented DBMS.Answer: DDiff: 1Page Ref: 215AACSB: Use of ITCASE: ContentObjective: 6.344) The data dictionary serves as an important data management tool byA) assigning attributes to the data.B) creating an inventory of the data elements contained in the database.C) presenting data as end users or business specialists would perceive them.D) maintaining data in updated form.Answer: BDiff: 2Page Ref: 217AACSB: Use of ITCASE: ContentObjective: 6.245) An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is theA) data dictionary.B) data definition diagram.C) entity-relationship diagram.D) relationship dictionary.Answer: ADiff: 2Page Ref: 217AACSB: Use of ITCASE: ContentObjective: 6.246) The specialized language programmers use to add and change data in the database is calledA) a data access language.B) a data manipulation language.C) Structured Query Language.D) a data definition language.Answer: BDiff: 1Page Ref: 217AACSB: Use of ITCASE: ContentObjective: 6.247) The most prominent data manipulation language today isA) Access.B) DB2.C) SQL.D) Crystal Reports.Answer: CDiff: 2Page Ref: 217AACSB: Use of ITCASE: ContentObjective: 6.248) DBMSs typically include report-generating tools in order toA) retrieve and display data.B) display data in an easier-to-read format.C) display data in graphs.D) perform predictive analysis.Answer: BDiff: 2Page Ref: 219AACSB: Use of ITCASE: ContentObjective: 6.149) The process of streamlining data to minimize redundancy and awkward many-to-many relationships is calledA) normalization.B) data scrubbing.C) data cleansing.D) data defining.Answer: ADiff: 1Page Ref: 220AACSB: Use of ITCASE: ContentObjective: 6.350) A schematic of the entire database that describes the relationships in a database is called a(n)A) data dictionary.B) intersection relationship diagram.C) entity-relationship diagram.D) data definition diagram.Answer: CDiff: 2Page Ref: 221AACSB: Use of ITCASE: ContentObjective: 6.351) A one-to-one relationship between two entities is symbolized in a diagram by a line that ends withA) two short marks.B) one short mark.C) a crows foot.D) a crows foot topped by a short mark.Answer: ADiff: 3Page Ref: 221AACSB: Use of ITCASE: ContentObjective: 6.352) Which of the following is not one of the techniques used in Web mining?A) content miningB) structure miningC) usage miningD) user miningAnswer: DDiff: 2Page Ref: 228AACSB: Reflective ThinkingCASE: ContentObjective: 6.453) You work for a retail clothing chain whose primary outlets are in shopping malls and are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable ofA) identifying associations.B) identifying clusters.C) identifying sequences.D) classification.Answer: CDiff: 2Page Ref: 225AACSB: Analytic SkillsCASE: SynthesisObjective: 6.454) You work for an national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable ofA) identifying associations.B) identifying clusters.C) identifying sequences.D) classification.Answer: DDiff: 3Page Ref: 225AACSB: Analytic SkillsCASE: SynthesisObjective: 6.455) A data warehouse is composed ofA) historical data from legacy systems.B) current data.C) internal and external data sources.D) historic and current internal data.Answer: DDiff: 2Page Ref: 222AACSB: Use of ITCASE: ContentObjective: 6.456) A data mart usually can be constructed more rapidly and at lower cost than a data warehouse becauseA) 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 interface.D) all of the information belongs to a single company.Answer: ADiff: 1Page Ref: 223AACSB: Use of ITCASE: ContentObjective: 6.457) Tools for analyzing data to help users find patterns, relationships, and insights and make better business decisions are known asA) DSS.B) business intelligence.C) OLAP.D) data mining.Answer: BDiff: 2Page Ref: 224AACSB: Use of ITCASE: ContentObjective: 6.458) The tool that enables users to view the same data in different ways using multiple dimensions isA) predictive analysis.B) SQL.C) OLAP.D) data mining.Answer: CDiff: 3Page Ref: 224AACSB: Use of ITCASE: ContentObjective: 6.459) OLAP is a tool for enablingA) 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 normalize data.Answer: ADiff: 1Page Ref: 224AACSB: Use of ITCASE: ContentObjective: 6.460) Data mining is a tool for allowing users toA) 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 data into much smaller, traditional reports.Answer: BDiff: 2Page Ref: 224-225AACSB: Use of ITCASE: ContentObjective: 6.461) In terms of data relationships, associations refers toA) 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: CDiff: 3Page Ref: 225AACSB: Use of ITCASE: ContentObjective: 6.462) _ tools are used to analyze large unstructured data sets, such as e-mail, memos, survey responses, etc., to discover patterns and relationships. A) OLAPB) Text miningC) Web miningD) Web content miningAnswer: BDiff: 2Page Ref: 226AACSB: Use of ITCASE: ContentObjective: 6.463) An alternative to using application server software for interfacing between a Web server and back-end databases isA) CGI.B) HTML.C) Java.D) SQL.Answer: ADiff: 1Page Ref: 229AACSB: Use of ITCASE: ContentObjective: 6.464) The organizations rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n) A) information policy.B) data definition file.C) data quality audit.D) data governance policy.Answer: ADiff: 2Page Ref: 230AACSB: Use of ITCASE: ContentObjective: 6.565) The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called