Question 1. Data mining complements online analytical processing in that it:
A. finds associations or correlations among sets of items.
B. provides capabilities for discovering "hidden" predictive relationships in the data.
C. extracts textual information from Web documents.
D. groups related records together on the basis of having similar values for attributes.
Question 2. Which of the following is a role of data mining agents?
A. Tracking inventory levels
B. Sending a report at the first of the month automatically
C. Assembling customized news
D. Analyzing data warehouses to detect changes deemed important by a user
Question 3. Which of the following statements is true about an online analytical processing server?
A. It is a data structure allowing for multiple dimensions to be added to a traditional two-dimensional table.
B. It groups related records together on the basis of having similar values for attributes.
C. It understands how data are organized in the database and has special functions for analyzing the data.
D. It uses reasoning methods based on knowledge about a specific problem domain in order to provide advice.
Question 4. Which of the following statements is true about business intelligence?
A. It is the act of outsourcing tasks, traditionally performed by an employee or contractor, to an undefined, large group of people or community, through the use of information technology.
B. It is the process by which a customer-owned mutual organization or co-operative changes legal form to a joint stock company.
C. It is the use of information systems to gather and analyze information from internal and external sources in order to make better business decisions.
D. It is an organization's process of defining its strategy, or direction, and making decisions on allocating its resources to pursue this strategy, including its capital and people.
Question 5. When we consider entities as tables, each column is a(n):
A. attribute.
B. record.
C. form.
D. bot.
Question 6. In DBMS, data are kept separate from the application's programming code. This means that a(n):
A. application cannot be changed without making changes to the database.
B. application's programming code needs to be updated continuously to keep up with the database.
C. application needs to be changed when database is changed.
D. database does not need to be changed if a change is made to an application.
Question 7. When we consider entities as tables, each row is a(n):
A. field.
B. record.
C. attribute.
D. form.
Question 8. The purpose of a data warehouse is to:
A. standardize the format of data retrieved from different systems.
B. allow managers to run queries and reports themselves without having to know query languages or the structure of the underlying data.
C. provide capabilities for discovering "hidden" predictive relationships in the data.
D. put key business information into the hands of more decision makers.
Question 9. One of the advantages of the database approach is program-data independence, which means that it is:
A. easier to deploy and control data access using a centralized system.
B. easier to evolve and alter software to changing business needs when data and programs are independent.
C. a centralized system, making it easier to enforce access restrictions.
D. a centralized system, making it much easier to enforce standards and rules for data creation, modification, naming, and deletion.
Question 10. Bringes, a retail chain, has retail stores across three states. With its current legacy system, Bringes is having problems tracking the inventory levels for its stores. It is planning to implement an Oracle database system to replace this legacy system. Which of the following, if true, most supports Bringes' decision to replace its legacy system with an Oracle database system?
A. Implementing an Oracle database system will require hiring additional specialized personnel to manage it.
B. Partial implementation of the Oracle database system can create more problems than it is likely to solve.
C. Conversion cost required for the implementation of an Oracle database system is not supported by the IT budget.
D. Bringes' channel partners use a database system that supports the Oracle database system.
Question 11. Which of the following statements is true about an information system?
A. Its primary purpose is to run the business on a current basis.
B. Its design goal is to enhance ease of access and use.
C. It consists of narrow and simple updates and queries.
D. Its design goal is to enhance performance.
Question 12. While using digital dashboards, pull reporting is conducted to:
A. alert the user of any items that require immediate attention.
B. provide the decision makers with a quick overview of key performance indicators.
C. discover "hidden" predictive relationships in the data.
D. analyze the root causes of an exception.
Question 13. __________ involves standardizing the format of data retrieved from different systems.
A. Data cleansing
B. Data mining
C. Normalization
D. Content mining
Question 14. __________ integrates data from various operational systems.
A. A data warehouse
B. A metadata repository
C. Data modeling
D. Master data
Question 15. A query is used to:
A. organize and sort the data in a database.
B. allocate storage space for a database.
C. eliminate data duplication.
D. retrieve data from a database.
Question 16. When the database approach makes it easier to deploy and control data access, which of the following advantages is being referred to?
A. Improved data accessibility
B. Improved data consistency
C. Improved data quality
D. Improved data sharing
Question 17. Responding to threats and opportunities and continuous planning are based on analyzing internal data primarily from the __________ level of the organization.
A. operational
B. executive
C. tactical
D. business
Question 18. Which of the following statements is true about a data mart?
A. It standardizes the format of data retrieved from different systems.
B. It contains selected data from the data warehouse.
C. It stores master data only.
D. It is a compilation of data from the database that is organized and produced in printed format.
Question 19. Which of the following statements is true about an operational system?
A. Its primary purpose is to support managerial decision making.
B. It consists of historical or point-in-time data.
C. Its goal is to enhance ease of access and use.
D. It consists of narrow and simple updates and queries.
Question 20. Which of the following is used for Web content mining?
A. Clustering
B. Online analytical processing
C. Neural networks
D. Web crawler
Question 21. Which of the following statements is true with regards to packaged and custom software?
A. Packaged software is applications that are designed and developed exclusively for a specific organization.
B. The development costs of custom software are much higher than for packaged software because of the time, money, and resources that are required to design and develop them.
C. Packaged software is well suited for tasks that are unique to a particular business.
D. Custom software is cost effective since the vendor that builds the application can spread out development costs through selling to a large number of users.
Question 22. Which of the following software is cost effective since the vendor that builds the application spreads out the development costs by selling copies to a large number of users?
A. Packaged software
B. Bespoke software
C. Adapted software
D. Corrected software
Question 23. Which of the following is a support activity?
A. Outbound logistics activities
B. Operations and manufacturing activities
C. Technology development activities
D. Customer service activities
Question 24. Financial management, operations management, human resource management, and other important internal activities require the support of __________ components.
A. ERP essence
B. ERP exterior
C. ERP core
D. ERP extended
Question 25. Which of the following types of software is best suited for tasks that are unique to a particular business?
A. Collaborative
B. Custom
C. Groupware
D. Packaged
Question 26. __________ immediately after the purchase order is issued in the procure-to-pay process.
A. Payment is settled
B. Price and terms are negotiated
C. Credit is checked
D. Goods are received
Question 27. For most businesses, the __________ process entails several subprocesses including creating a customer record, checking the customer's creditworthiness, creating an order, checking and allocating stock, and shipping.
A. order-to-cash
B. make-to-order
C. procure-to-pay
D. make-to-stock
Question 28. Which of the following is a core activity?
A. Human resource activities
B. Technology development
C. Operations and manufacturing
D. Administrative activities
Question 29. According to the order-to-cash process, what would the next step be for an online retailer after creating an order for a customer?
A. Collect payment
B. Create customer record
C. Check and allocate stock
D. Pick, pack, and ship
Question 30. A(n) __________ system coordinates business processes with customers, suppliers, and business partners of an organization.
A. internally focused
B. legacy
C. stand-alone
D. externally focused
Question 31. A system that communicates across organizational boundaries is sometimes referred to as a(n) __________ system.
A. legacy
B. interorganizational
C. intraorganizational
D. internally focused
Question 32. Which of the following is the first step in the procure-to-pay process?
A. Negotiate price and terms
B. Issue purchase order
C. Receive goods
D. Receive invoice
Question 33. A __________ information flow relates to the information that is produced by a company and sent along to another organization.
A. stand-alone
B. downstream
C. packaged
D. custom
Question 34. __________ components support the primary external activities of the organization for dealing with suppliers and customers.
A. ERP essence
B. ERP aggrandized
C. ERP abridged
D. ERP extended
Question 35. Designing and developing applications that support the primary business activities are a part of the __________ activities.
A. operations and manufacturing
B. outbound logistics
C. technology development
D. procurement
Question 36. Which of the following uses a pull-based approach?
A. Make-to-order
B. Make-to-stock
C. Plan-to-produce
D. Account-to-report
Question 37. Specifically, ERP extended components focus primarily on:
A. customer relationship management and product lifecycle management.
B. product lifecycle management and supply chain management.
C. customer relationship management and human capital management.
D. customer relationship management and supply chain management.
Question 38. Which of the following is true regarding the formula for success of an enterprise system?
A. Enterprise systems implementations should include personnel from different departments.
B. The success of an enterprise system depends directly on the support received from middle-management.
C. Enterprise systems are simple to understand and implement when compared to stand-alone systems.
D. Using outside consultants tends to complicate the implementation of an enterprise system.
Question 39. In service-oriented architecture, business processes:
A. are broken down into individual components or services.
B. of an organization are standardized.
C. of an organization are carried out by a large, comprehensive system.
D. are shared with channel partners.
Question 40. Which of the following is a core business process?
A. Time-to-purchase
B. Make-to-stock
C. Plan-to-produce
D. Account-to-report