Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
69 Cards in this Set
- Front
- Back
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.
|
A) Reconciling inconsistent data can require a significant amount of time and money |
|
2) Data that unambiguously describes other data for enterprise use are called:
|
D) Metadata |
|
3) In an ERD, a characteristic of a customer entity is diagrammed as a(n):
|
B) Attribute |
|
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:
|
B) Enterprise modeling |
|
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:
|
C) View integration |
|
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:
|
C) Normalization |
|
7) All of the following are true about using a pre-existing (packaged) data model, except:
|
A) It cannot be customize to fit the terms and business rules of a specific organization |
|
The data modeling guideline that specifies the functional, business division, and/or corporate coverage is called the: |
B) scope |
|
9) The data modeling guideline that captures the need that justified the data modeling effort is specified in the:
|
A) Objective |
|
10) An example of a query language used for posing queries to a database is:
|
A) SQL |
|
11) An example of a data exchange language to pass data between computers for e-business is:
|
C) XML |
|
12) Which of the following is not true about managing data in today's large organizations?
|
B) Data is captured more than once to ensure accuracy |
|
13) Databases for managerial control and other decision-making are often subsets, summaries, or aggregations of ________ with external data supplements.
|
D) Operational database |
|
14) Which of the following statements about information processing with application independence is not true?
|
B) Data that is accessed from a database for application processing is automatically deleted from the database |
|
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:
|
C) Data transfer application |
|
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 |
|
17) An application that gathers data and populates databases is called a:
|
A) data capture application |
|
18) Which of the following statements is true about the retention of data?
|
B) Some national laws require that certain types of data must be retained for certain periods of time |
|
19) An unambiguous description of each type of data that applies to all business circumstances and users is called a(n):
|
D) definition |
|
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):
|
C) Identifier |
|
21) Which of the following prescribes who can do what and when to each kind of data?
|
D) usage rights |
|
22) A data dictionary/directory, or DD/D, contains each of the following, except:
|
C) Database server definitions |
|
23) ________ refers to the disciplines, technologies, and methods to ensure the currency, meaning and quality of reference data within and across various subject areas.
|
B) MDM |
|
24) What organizational role or unit is responsible for functions such as physical database design, database interfaces with other technologies, and database recovery methods?
|
B) Database administrator |
|
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 |
|
26) What organizational role or unit is responsible for functions such as maintaining metadata, reducing redundant data, and improving data quality across an organization?
|
D) Data administration |
|
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 |
|
28) Each of the following is a critical step in a data quality initiative, except:
|
B) avoiding the usage of advanced data cleansing tools |
|
29) Which of the following is a rationale for data ownership?
|
D) All of the above |
|
30) Which of the following is a justification given for laws that control data flows across national borders?
|
D) both B and C |
|
T/F: 31) If an organization maintains application independence, then application software can more easily be abandoned or replaced. |
True |
|
T/F 32) Data warehouses provide a method for making historical and current data accessible for queries by many people throughout an organization. |
True |
|
T/F 33) For legal reasons, all data should be stored indefinitely. |
False |
|
T/F 34) The permissible range or set of values for each data element is defined by integrity rules. |
True |
|
1) Which of the following is an intraorganizational system?
|
D) ERP |
|
2) What is a characteristic of a system with batch processing?
|
C) Processing costs are typically lower than for online processing |
|
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 |
|
4) An information system that supports a particular area of an organization, such as production or marketing, is called a:
|
B) Functional info system |
|
5) In describing a client/server system, the software needed to support the interactions between the clients and the server is called:
|
B) middleware |
|
6) A vertically integrated information system may perform which of the following?
|
D) All of the above |
|
7) Which statement about virtualization is not true?
|
C) In server virtualization, all of the virtual servers on a single physical server must employ the same operating system |
|
8) Which of the following is a distinct characteristic of distributed systems?
|
C) dependence on high-quality telecommunications lines |
|
9) In a client/server environment, Web servers and groupware servers are usually:
|
C) fat servers |
|
10) Which of the following benefits is associated with data warehousing?
|
A) Historical data on business operations can be used to support decision making |
|
11) The components of a three-tier client/server system include:
|
B) Client, applications server, and database server |
|
12) Which of the following statements about service-oriented architecture (SOA) is false?
|
D) None of the above |
|
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):
|
C) Enterprise resource planning system |
|
14) All of the following statements about enterprise resource planning (ERP) systems are true except:
|
C) the modules of an ERP system are typically designed for companies operating in the US only |
|
15) Establishing a data warehouse requires software tools to do all of the following except:
|
D) process transactions (such as a sales order) |
|
16) Which of the following CRM enterprise vendors offers only a hosted or on-demand solution?
|
C) Salesforce.com |
|
17) Which of the following are potential disadvantages of electronic mail systems?
|
D) all of the above |
|
18) Which statement about portals is not true?
|
C) a portal is equivalent to a firewall |
|
19) Which of the following is a potential business benefit from implementing an ERP system?
|
D) all of the above |
|
20) Lotus Notes (an IBM product) is an example of which of the following types of application software?
|
C) Groupware |
|
21) Which of the following is not a capability associated with groupware products?
|
A) data modeling |
|
22) According to the textbook, which of the following is not true when a firm is considering the implementation of an intranet?
|
B) little planning is required to design web pages and contnets |
|
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?
|
D) material requirements planning (MRP) |
|
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?
|
B) Group technolog (GT) |
|
25) Which one of the following answers consists of systems all of which have been defined in this textbook as enterprise systems?
|
D) intranet, customer relationship management, groupware |
|
26) What are the three major categories of computer-integrated manufacturing (CIM) systems?
|
D) engineering systems, manufacturing administration, and factory operations |
|
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?
|
C) more accurate accounting records |
|
28) MRP II is a computer-based manufacturing administration system that usually has which of the following components?
|
B) master production schedule, material requirements planning and shop floor control |
|
29) An engineering system that uses computer graphics to create and modify engineering designs is what type of system?
|
B) computer-aiding design (CAD) |
|
30) What are the 5 basic components of a supply chain management (SCM) system?
|
C) plan, source, make, deliver, return |
|
T/F 31) Intraorganizational systems are systems that span organizational boundaries. |
False |
|
T/F 32) A client/server system is a particular type of distributed system. |
True |
|
T/F 33) Payroll and order entry systems are examples of transaction processing systems. |
True |
|
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.
|
True |
|
T/F 35) Groupware systems attempt to provide an integrated approach to all aspects of interaction a company has with its customers. |
False |