Mis Chapters 4 And 5

Front 1

Which of the following statements about managing data is true?

A) Reconciling inconsistent data can require a significant amount of time and money

B) Potential costs incurred by organizations for data loss are minimal.

C) Today's tools eliminate the need for data management positions.
D) There are no consequences associated with noncompliance of a law due to poor data management.

Back 1

A) Reconciling inconsistent data can require a significant amount of time and money

Front 2

2) Data that unambiguously describes other data for enterprise use are called:
A) attributes.
B) data models.
C) entities.
D) metadata

Back 2

D) Metadata

Front 3

3) In an ERD, a characteristic of a customer entity is diagrammed as a(n):
A) sub-entity.
B) attribute.
C) data relationship.
D) metadata.

Back 3

B) Attribute

Front 4

4) A top-down data modeling approach to describe the data structure and other requirements of an organization, independent of any particular reports or screens, is called:
A) corporate modeling.
B) enterprise modeling.
C) view integration.
D) data consolidation.

Back 4

B) Enterprise modeling

Front 5

5) A bottom-up approach to describe the data structure and other requirements of an organization, in which reports, screens, and relevant documents are analyzed, is called:
A) corporate modeling.
B) enterprise modeling.
C) view integration.
D) data consolidation.

Back 5

C) View integration

Front 6

6) The process of creating simple data structures from more complex ones, which yields a data model that is very stable and useful across many different requirements, is called:
A) standardization.
B) consistency.
C) normalization.
D) basic.

Back 6

C) Normalization

Front 7

7) All of the following are true about using a pre-existing (packaged) data model, except:
A) it cannot be customized to fit the terms and business rules of a specific organization.
B) the modeling projects require less time and money.
C) it may be easier to share data with other organizations in the industry.
D) it is likely to work well with other applications from the same vendor.

Back 7

A) It cannot be customize to fit the terms and business rules of a specific organization

Front 8

The data modeling guideline that specifies the functional, business division, and/or corporate coverage is called the:

Back 8

B) scope

Front 9

9) The data modeling guideline that captures the need that justified the data modeling effort is specified in the:
A) objective.
B) scope.
C) outcome.
D) timing.

Back 9

A) Objective

Front 10

10) An example of a query language used for posing queries to a database is:
A) SQL.
B) ASP.
C) XML.
D) PHP.

Back 10

A) SQL

Front 11

11) An example of a data exchange language to pass data between computers for e-business is:
A) SQL.
B) ASP.
C) XML.
D) PHP.

Back 11

C) XML

Front 12

12) Which of the following is not true about managing data in today's large organizations?
A) Application software is separate from the database software.
B) Data is captured more than once to ensure accuracy.
C) Data exists in databases for operational and managerial purposes.
D) The need to manage data is continuous.

Back 12

B) Data is captured more than once to ensure accuracy

Front 13

13) Databases for managerial control and other decision-making are often subsets, summaries, or aggregations of ________ with external data supplements.
A) personnel databases
B) strategic databases
C) geographic databases
D) operational databases

Back 13

D) Operational database

Front 14

14) Which of the following statements about information processing with application independence is not true?
A) Data are captured and stored in an operational database.
B) Data that is accessed from a database for application processing is automatically deleted from the database.
C) Subsets and aggregated operational data may be periodically transferred to a long-term data warehouse.
D) none of the above

Back 14

B) Data that is accessed from a database for application processing is automatically deleted from the database

Front 15

15) An application that moves data from one database to another and permits one source of data to serve many localized systems within an organization is called a:
A) data analysis and presentation application.
B) data capture application.
C) data transfer application.
D) disposable application.

Back 15

C) Data transfer application

Front 16

16) An application that distributes data to authorized users and manipulates data to create useful information from established data sources is called a:
A) data analysis and presentation application.
B) data capture application.
C) data transfer application.
D) disposable application.

Back 16

A) data analysis and presentation application

Front 17

17) An application that gathers data and populates databases is called a:
A) data capture application.
B) data transfer application.
C) data analysis and presentation application.
D) disposable application.

Back 17

A) data capture application

Front 18

18) Which of the following statements is true about the retention of data?
A) All organizational data should be retained indefinitely.
B) Some national laws require that certain types of data must be retained for certain periods of time.
C) Emails should be retained in the same database as transaction data.
D) none of the above

Back 18

B) Some national laws require that certain types of data must be retained for certain periods of time

Front 19

19) An unambiguous description of each type of data that applies to all business circumstances and users is called a(n):
A) name.
B) descriptor.
C) identifier.
D) definition.

Back 19

D) definition

Front 20

20) A characteristic of a business entity that uniquely distinguishes it from other instances of the entity for the long term is called a(n):
A) name.
B) definition.
C) identifier.
D) integrity rule

Back 20

C) Identifier

Front 21

21) Which of the following prescribes who can do what and when to each kind of data?
A) ranges
B) integrity rules
C) edit rules
D) usage rights

Back 21

D) usage rights

Front 22

22) A data dictionary/directory, or DD/D, contains each of the following, except:
A) entity definitions.
B) data element definitions.
C) database server definitions.
D) data standards.

Back 22

C) Database server definitions

Front 23

23) ________ refers to the disciplines, technologies, and methods to ensure the currency, meaning and quality of reference data within and across various subject areas.
A) DD/D
B) MDM
C) DBMS
D) ERP

Back 23

B) MDM

Front 24

24) What organizational role or unit is responsible for functions such as physical database design, database interfaces with other technologies, and database recovery methods?
A) data steward
B) database administrator
C) CIO
D) data administration group

Back 24

B) Database administrator

Front 25

25) Determining the physical arrangement of data based on the data currently required by the business and expected to be required in the future is part of which of the following data resource management functions?
A) organize and make accessible
B) define/describe and inventory
C) control quality and integrity
D) accounting for usage

Back 25

A) Organize and make accessible

Front 26

26) What organizational role or unit is responsible for functions such as maintaining metadata, reducing redundant data, and improving data quality across an organization?
A) data steward
B) database administrator
C) CIO
D) data administration

Back 26

D) Data administration

Front 27

27) What organizational role or unit is responsible for the quality of the data in a particular subject database or departmental area?
A) data steward
B) database administrator
C) CIO
D) data administration

Back 27

A) Data steward

Front 28

28) Each of the following is a critical step in a data quality initiative, except:
A) cleaning up existing data errors.
B) avoiding the usage of advanced data cleansing tools.
C) establishing procedures to prevent errors.
D) verifying that third-party vendors provide clean data.

Back 28

B) avoiding the usage of advanced data cleansing tools

Front 29

29) Which of the following is a rationale for data ownership?
A) the need to protect the privacy of personal data
B) the need to protect trade secrets
C) the need to share data with those who "need to know"
D) all of the above

Back 29

D) All of the above

Front 30

30) Which of the following is a justification given for laws that control data flows across national borders?
A) promote economic imperialism
B) protect a domestic industry
C) protect individual privacy
D) both B and C

Back 30

D) both B and C

Front 31

T/F: 31) If an organization maintains application independence, then application software can more easily be abandoned or replaced.

Back 31

True

Front 32

T/F

32) Data warehouses provide a method for making historical and current data accessible for queries by many people throughout an organization.

Back 32

True

Front 33

T/F

33) For legal reasons, all data should be stored indefinitely.

Back 33

False

Front 34

T/F

34) The permissible range or set of values for each data element is defined by integrity rules.

Back 34

True

Front 35

1) Which of the following is an intraorganizational system?
A) B2B
B) EDI
C) B2C
D) ERP

Back 35

D) ERP

Front 36

2) What is a characteristic of a system with batch processing?
A) transactions are processed in real time
B) enables interactive decision support
C) processing costs are typically lower than for online processing
D) none of the above

Back 36

C) Processing costs are typically lower than for online processing

Front 37

3) At Around-the-World-Warehouses, a shipping clerk or sales clerk enters the receipt or sale of a product into a desktop computer. As soon as the entry is completed, a master file is updated within a fraction of a second. This order entry system is an example of a(n):
A) online processing system.
B) batch processing system.
C) in-line system.
D) personal system

Back 37

A) Online processing system

Front 38

4) An information system that supports a particular area of an organization, such as production or marketing, is called a:
A) group support system.
B) functional information system.
C) vertically integrated information system.
D) transaction-processing system.

Back 38

B) Functional info system

Front 39

5) In describing a client/server system, the software needed to support the interactions between the clients and the server is called:
A) clientware.
B) middleware.
C) expert system.
D) telecommunications interface software.

Back 39

B) middleware

Front 40

6) A vertically integrated information system may perform which of the following?
A) capture the initial sales data and produce invoices (acting as a transaction processing system)
B) summarize these data on a weekly basis for use by middle managers in tracking slow- and fast-selling items as well as productive and unproductive salespeople (acting as a decision support system)
C) analyze data for long-term trends for use by top managers (acting as an executive information system)
D) all of the above

Back 40

D) All of the above

Front 41

7) Which statement about virtualization is not true?
A) In server virtualization, a single server operates as if it were multiple servers.
B) In desktop virtualization, the user can be using a thin client or mobile device with limited storage because the applications and data are actually stored on a server accessed by the client.
C) In server virtualization, all of the virtual servers on a single physical server must employ the same operating system.
D) Benefits from virtualization include lower costs, ease of management, and flexibility.

Back 41

C) In server virtualization, all of the virtual servers on a single physical server must employ the same operating system

Front 42

8) Which of the following is a distinct characteristic of distributed systems?
A) less required coordination across sites
B) decreased security risks
C) dependence on high-quality telecommunications lines
D) communication and support costs are lower

Back 42

C) dependence on high-quality telecommunications lines

Front 43

9) In a client/server environment, Web servers and groupware servers are usually:
A) thin servers.
B) three-tier servers.
C) fat servers.
D) medium servers.

Back 43

C) fat servers

Front 44

10) Which of the following benefits is associated with data warehousing?
A) historical data on business operations can be used to support decision making
B) large database machines can be kept in a single warehouse location
C) archival data is stored on magnetic data at a secure warehouse site
D) none of the above

Back 44

A) Historical data on business operations can be used to support decision making

Front 45

11) The components of a three-tier client/server system include:
A) server, middleware, and client.
B) client, applications server, and database server.
C) database server, client, and middleware.
D) applications server, middleware, and client.

Back 45

B) Client, applications server, and database server

Front 46

12) Which of the following statements about service-oriented architecture (SOA) is false?
A) Services can be developed internally to the organization or purchased externally.
B) Once a service is created, it can be used over and over again.
C) Services can communicate or be connected with one another.

Back 46

D) None of the above

Front 47

13) A type of transaction processing system that consists of a set of integrated business applications, or modules, to carry out most common business functions (such as inventory control, general ledger accounting, accounts payable, order processing, etc.) is called a(n):
A) distributed system.
B) client/server system.
C) enterprise resource planning system.
D) group support system.

Back 47

C) Enterprise resource planning system

Front 48

14) All of the following statements about enterprise resource planning (ERP) systems are true except:
A) the modules of an ERP system are integrated through common definitions and a common database.
B) ERP systems are designed to support business processes that involve multiple functional units.
C) the modules of an ERP system are typically designed for companies operating in the U.S. only.
D) ERP systems are typically purchased from a software vendor.

Back 48

C) the modules of an ERP system are typically designed for companies operating in the US only

Front 49

15) Establishing a data warehouse requires software tools to do all of the following except:
A) operate the warehouse.
B) access and analyze data.
C) construct the warehouse.
D) process transactions (such as a sales order).

Back 49

D) process transactions (such as a sales order)

Front 50

16) Which of the following CRM enterprise vendors offers only a hosted or on-demand solution?
A) Oracle
B) Microsoft
C) Salesforce.com
D) SAP

Back 50

C) Salesforce.com

Front 51

17) Which of the following are potential disadvantages of electronic mail systems?
A) can result in information overload
B) can result in the usage of offensive words by a sender who would not use them face-to-face
C) can be electronically monitored by supervisor
D) all of the above

Back 51

D) all of the above

Front 52

18) Which statement about portals is not true?
A) A portal may be accessible to organizational employees only.
B) Portal software increases the cost of providing an intranet to employees.
C) A portal is equivalent to a firewall.
D) Portal software is used to improve a user's access to internal information via a Web browser.

Back 52

C) a portal is equivalent to a firewall

Front 53

19) Which of the following is a potential business benefit from implementing an ERP system?
A) improved financial process controls
B) lower costs for inventory warehousing
C) re-engineered business processes
D) all of the above

Back 53

D) all of the above

Front 54

20) Lotus Notes (an IBM product) is an example of which of the following types of application software?
A) enterprise resource planning (ERP) system
B) transaction processing system
C) groupware
D) physician documentation for patient records

Back 54

C) Groupware

Front 55

21) Which of the following is not a capability associated with groupware products?
A) data modeling
B) electronic bulletin boards
C) document sharing
D) instant messaging

Back 55

A) data modeling

Front 56

22) According to the textbook, which of the following is not true when a firm is considering the implementation of an intranet?
A) If the basic infrastructure is already in place (e.g., Web browsers and Web server), implementation requires relatively little effort.
B) Little planning is required to design Web pages and contents.
C) The per-user costs are generally low.
D) Minimal user training is required.

Back 56

B) little planning is required to design web pages and contnets

Front 57

23) A computer system that relies on extensive data input to produce a production schedule for the factory and a schedule of needed raw materials is what kind of system?
A) computer-aided manufacturing (CAM)
B) shop floor control (SFC)
C) computer-aided process planning (CAPP)
D) material requirements planning (MRP)

Back 57

D) material requirements planning (MRP)

Front 58

24) A manufacturing computer system that logically groups parts according to physical characteristics, machine routings through a factory, and similar machine operations is what kind of system?
A) computer-aided process planning (CAPP)
B) group technology (GT)
C) computer-aided manufacturing (CAM)
D) computer-aided design (CAD)

Back 58

B) Group technolog (GT)

Front 59

25) Which one of the following answers consists of systems all of which have been defined in this textbook as enterprise systems?
A) expert system, data mining, neural networks
B) groupware, intranet, group support systems
C) data warehousing, data mining, business intelligence systems
D) intranet, customer relationship management, groupware

Back 59

D) intranet, customer relationship management, groupware

Front 60

26) What are the three major categories of computer-integrated manufacturing (CIM) systems?
A) robotics, engineering systems, and manufacturing administration
B) design, factory operations, and engineering systems
C) manufacturing administration, factory operations, and design
D) engineering systems, manufacturing administration, and factory operations

Back 60

D) engineering systems, manufacturing administration, and factory operations

Front 61

27) Which of the following is not an example of an outcome that would be expected from the implementation of a supply chain management (SCM) system?
A) reduction in time for getting a new product designed and at a retail store
B) reducing out-of-stock items in warehouses
C) more accurate accounting records
D) delivering the right number of products to the right customers at the right time

Back 61

C) more accurate accounting records

Front 62

28) MRP II is a computer-based manufacturing administration system that usually has which of the following components?
A) computer-aided design, master production schedule, and group technology
B) master production schedule, material requirements planning, and shop floor control
C) material requirements planning, computer-aided engineering, and master production schedule
D) shop floor control, manufacturing automation protocol, and material requirements planning

Back 62

B) master production schedule, material requirements planning and shop floor control

Front 63

29) An engineering system that uses computer graphics to create and modify engineering designs is what type of system?
A) computer-aided engineering (CAE)
B) computer-aided design (CAD)
C) graphic user design (GUD)
D) computer-aided process planning (CAPP)

Back 63

B) computer-aiding design (CAD)

Front 64

30) What are the 5 basic components of a supply chain management (SCM) system?
A) market, source, make, sell, deliver
B) plan, source, buy, sell, deliver
C) plan, source, make, deliver, return
D) procure, make, market, sell, deliver

Back 64

C) plan, source, make, deliver, return

Front 65

T/F

31) Intraorganizational systems are systems that span organizational boundaries.

Back 65

False

Front 66

T/F

32) A client/server system is a particular type of distributed system.

Back 66

True

Front 67

T/F

33) Payroll and order entry systems are examples of transaction processing systems.

Back 67

True

Front 68

T/F

34) In a survey of IT leaders, CIO magazine found that the companies represented were completely dependent on their ERP systems, but they also had major concerns including complex system integration, high cost of ownership, and systems that are difficult to use.

Back 68

True

Front 69

T/F

35) Groupware systems attempt to provide an integrated approach to all aspects of interaction a company has with its customers.

Back 69

False