MIS管理信息系统-课后练习答案2.doc

Software that organizes, manages, and processes business data concerned with inventory, customers, and vendors is called:a. system software.b. application software.c. data management software.d. network software.Answer: cPage Reference: 118Difficulty: ModerateSoftware that manages the resources of the computer is called:a. system software.b. application software.c. data management software.d. network software.Answer: aPage Reference: 118Difficulty: EasySoftware used to apply the computer to a specific task for an end user is called:a. system software.b. application software.c. data management software.d. network software.Answer: bPage Reference: 118Difficulty: ModerateAACSB: Reflective ThinkingLegacy systems are still in use today because:a.they can only be run on the older mainframe computers.b.they are too expensive to redesign.c.many integrate well using new Web services technologies.d.they contain valuable data that would be lost during redesign.Answer: bPage Reference: 119Difficulty: ModerateWhat would be a reason for using a workstation rather than a personal computer?A、When you need more powerful computational abilitiesB、When you need to access a networkC、 When you need to serve applications and data to client computersD、When you need to share resourcesAnswer: aPage Reference: 119Difficulty: ModerateThe use of multiple computers linked by a communications network for processing is called:a.grid computing.b.distributed processing.c.client/server computing.d.centralized processing.Answer: bPage Reference: 121Difficulty: ModerateWhich of the following storage technology stores data sequentially?a. CD-ROMb. RAIDc. Magnetic disksd. Magnetic tapeAnswer: dPage Reference: 123Difficulty: ModerateWhat type of device gathers data and converts them into electronic form for use by the computer?a. Output deviceb. Input devicec. Optical storaged. Magnetic storageAnswer: bPage Reference: 124Difficulty: ModerateWhich of the following is not a type of output device?a. Speakersb. Cathode ray tubec. Ink jet printerd. KeyboardAnswer: dPage Reference: 124Difficulty: EasyIn batch processing:a. transactions are processed immediately in batches.b. transactions are accumulated in batches until it is time to process them.c. transactions are processed by arrays of multiple, less expensive servers.d. transactions are processed by arrays of multiple, less expensive workstations.Answer: bPage Reference: 125Difficulty: ModerateWhat 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 databasec. Normalize the data before importing to a databased. Audit your data qualityAnswer: aPage Reference: 160, 165Difficulty: ModerateAn example of a pre-digital database is a:a.librarys card-catalog.b.cash register receipt.c. doctors office invoice.c.list of sales totals on a spreadsheet.Answer: aPage Reference: 160Difficulty: ModerateWhich 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 ADDRESSc.The entity PRODUCT with the attribute PURCHASEd.The entity PRODUCT with the attribute CUSTOMERAnswer: bPage Reference: 160Difficulty: ModerateWhat are the relationships that the relational database is named for?a.Relationship between rows and columnsb.Relationships between entitiesc.Relationships between fields and recordsd.Relationships between databasesAnswer: bPage Reference: 160Difficulty: ModerateA characteristic or quality describing an entity is called a(n): a.fieldb.tuplec.key fieldd.attributeAnswer: dPage Reference: 160Difficulty: EasyIn a table for customers, the information about a single customer would reside in a single:a.field.b.row.c.column.d.table.Answer: bPage Reference: 161Difficulty: ModerateA 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.foreign key.Answer: aPage Reference: 161Difficulty: ModerateA field identified in a record as holding the unique identifier for that record is called the:a.primary key.b.key field.c.primary field.d.foreign key.Answer: bPage Reference: 161Difficulty: ModerateA table that links two tables that have a many-to-many relationship is often called a(n):a.derived ersection relation.c.foreign table.d.entity-relationship table.Answer: bPage Reference: 163Difficulty: ModerateThe process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:a.normalization.b.data scrubbing.c.data cleansing.d.data administration.Answer: aPage Reference: 162Difficulty: ModerateThe logical view of a database: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 reports.d.presents data as they would be perceived by end users.Answer: dPage Reference: 165Difficulty: ModerateIn 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, from, and join.Answer: cPage Reference: 166Difficulty: ModerateThe 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.creates a subset consisting of all records in the file that meets stated criteria.Answer: dPage Reference: 166Difficulty: ModerateThe join operation:bines 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 anizes elements into segments.Answer: aPage Reference: 166Difficulty: Modera