Chapters 5 - 9

Chapter 5,6 review questions

1. Which of the following activities does a CIO perform? 
A. Oversees all uses of information technology.
B. Ensures the strategic alignment of IT with business goals.
C. Ensures the strategic alignment of IT with business objectives.
D. All of these.

2. Broad functions of a CIO include all of the following except: 
A. Ensuring the delivery of all IT projects, on time and within budget.
B. Ensuring that the strategic vision of IT is in line with the strategic vision of the organization.
C. Building and maintaining strong executive relationships.
D. Building and maintaining strong customer processes.

 3. Which issue concerns CIOs the most? 
A. Security.
B. Budgeting.
C. Enhancing customer satisfaction.
D. Marketing.

4. Who is responsible for ensuring the throughput, speed, accuracy, availability, and reliability of an organization's information technology? 
A. CIO
B. CPO
C. CTO
D. CSO

 5. Who is responsible for ensuring the security of IT systems and developing strategies and IT safeguards against attacks from hackers and viruses? 
A. CIO
B. CPO
C. CTO
D. CSO

6. What are the principles and standards that guide our behavior toward other people? 
A. Intellectual property
B. Copyright
C. Pirated software
D. Ethics

7. What is a broad term encompassing the protection of information from accidental or intentional misuse by persons inside or outside an organization? 
A. Ethics
B. Privacy
C. Copyright
D. Information security

8. Jeremy Bridges is an executive for Green Web Designs, where his primary role is to ensure the security of business systems and develop strategies to protect the company from online viruses and hackers. What is Jeremy's role within the company? 
A. Chief Executive Officer (CEO).
B. Chief Security Officer (CSO).
C. Chief Procurement Officer (CPO).
D. Chief Technology Officer (CTO).

9. Which role within a company is responsible for overseeing all uses of MIS and ensuring that MIS strategy aligns with business goals and objectives? 
A. Chief knowledge officer (CKO).
B. Chief privacy officer (CPO).
C. Chief information officer (CIO).
D. Chief security officer (CSO).

10. What are the different types of information? 
A. Levels, forms, granularities
B. Levels, forms, data
C. Levels, formats, granularities
D. Data, formats, granularities

 11. Which of the following represents the different information levels? 
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of these

12. Which of the following represents the different information formats? 
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of these

 13. Which of the following represents the different information granularities? 
A. Detail, summary, aggregate
B. Document, presentation, spreadsheet, database
C. Individual, department, enterprise
D. None of these

14. All of the following are characteristics of information except: 
A. Transactional
B. Analytical
C. Timeliness
D. Quantity

15. What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performance of daily operational tasks? 
A. Transactional information
B. Analytical information
C. Timeliness
D. Quality

 16. Which of the following is an example of transactional information? 
A. Withdrawing cash from an ATM
B. Making an airline reservation
C. Purchasing stock
D. All of these

17. What encompasses all organizational information and its primary purpose is to support the performance of managerial analysis tasks? 
A. Transactional information
B. Analytical information
C. Timeliness
D. Quality

 18. Which of the following is an example of transactional information? 
A. Trend projection
B. Sales projection
C. Purchasing stock
D. All of these

19. What is immediate, up-to-date information? 
A. Real-time information
B. Real-time systems
C. Information granularity
D. All of these

 20. Which of the following is not one of the five characteristics common to high-quality information? 
A. Accuracy
B. Completeness
C. Quantity
D. Consistency

21. Which of the following implies that aggregate or summary information is in agreement with detailed information? 
A. Uniqueness
B. Completeness
C. Consistency
D. Accuracy

22. Which of the following implies that information is current with respect to the business requirement? 
A. Uniqueness
B. Accuracy
C. Consistency
D. Timeliness

23. What is a real-time system? 
A. Provides immediate, up-to-date information.
B. Provides real-time information in feedback to query requests.
C. Encompasses all organization information, and its primary purpose is to support the performance of managerial analysis tasks.
D. Encompasses all of the information contained within a single business process or unit of work, and its primary purpose is to support the performance of daily operational tasks.

24. Organizational information comes at different levels and in different formats and granularities. 
True    False

 25. Reports for each salesperson, product, and part are examples of detailed, or fine, information granularities. 
True    False

26. Purchasing stocks is an example of analytical information. 
True    False

27. Transactional information is used when performing operational tasks and repetitive decisions, such as analyzing daily sales reports and production schedules to determine how much inventory to carry. 
True    False

28. Timely information must be up-to-the-second to be accurate. 
True    False

29. Organizational information comes in different ___Levels________, formats, and granularities. 
________________________________________

30. Detail, summary, and ____aggregate_____ are the typical information granularities. 
________________________________________

---------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------

Chapter 7 – Review Questions

Student: ___________________________________________________________________________

1. Which of the following types of information can be found in a database? 
A. Inventory
B. Transactions
C. Employees
D. All of these

2. Which of the following database structures stores information in a treelike structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships? 
A. Hierarchical database
B. Network database
C. Relational database model
D. All of these

3. Which of the following database structures offers a flexible way of representing objects and their relationships? 
A. Hierarchical database
B. Network database
C. Relational database model
D. All of these

4. In the relational database model, what is a person, place, thing, transaction, or event about which information is stored? 
A. Entity
B. Logical view
C. Attribute
D. Physical view

5. In the relational database model, what is a characteristic or property of an entity? 
A. Entity
B. Logical view
C. Attribute
D. Physical view

6. What are characteristics or properties of an entity called? 
A. Attributes
B. Fields
C. Columns
D. All of these

7. Why do relational databases use primary keys and foreign keys? 
A. To create a database.
B. To create physical relationships.
C. To create logical relationships.
D. All of these.

8. What is a primary key? 
A. A field (or group of fields) that uniquely identifies a given entity in a table.
B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
C. Characteristics or properties of an entity.
D. A field (or group of fields) that uniquely identifies a given attribute in a table.

9. What is a foreign key? 
A. A field (or group of fields) that uniquely identifies a given entity in a table.
B. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
C. Characteristics or properties of an entity.
D. A field (or group of fields) that uniquely identifies a given attribute in a table.

10. All of the following are advantages of database-stored information except: 
A. Increased flexibility
B. Increased performance
C. Increased information redundancy
D. Increased information integrity

11. Which of the following is incorrect in reference to a database? 
A. Can be relational or network.
B. Information is accessed by logical structure.
C. Information is accessed by physical structure.
D. Users can access different views of information.

12. What is the physical view of information? 
A. Deals with the physical storage of information on a storage device such as a hard disk.
B. Deals with the logical storage of information on a storage device such as a hard disk.
C. Focuses on how users logically access information to meet their particular business needs.
D. Focuses on how users physically access information to meet their particular business needs.

13. Which of the following is correct in reference to a database? 
A. A database can support only one logical view.
B. A database can support many physical views.
C. A database can support many logical views.
D. A database can support up to three logical views.

14. What refers to how well a system can adapt to increased demands? 
A. Scalability
B. Performance
C. Redundancy
D. Information integrity

15. Which of the following measures how quickly a system performs a certain process or transaction? 
A. Scalability
B. Performance
C. Redundancy
D. Information integrity

16. What is information redundancy? 
A. Duplication of information.
B. Storing the same information in multiple places.
C. Storing duplicate information in multiple places.
D. All of these.

17. What is the primary problem with redundant information? 
A. It is difficult to determine which values are the most current.
B. It is often inconsistent.
C. It is difficult to determine which values are the most accurate.
D. All of these.

18. Which of the following is true in regard to eliminating redundant information? 
A. Uses additional hard disk space.
B. Makes performing information updates harder.
C. Improves information quality.
D. All of these.

19. What are the rules that help ensure the quality of information? 
A. Information integrity
B. Integrity constraints
C. Relational integrity constraints
D. Business-critical integrity constraints

20. Which of the following is a valid type of integrity constraint? 
A. Relational-critical integrity constraint
B. Business integrity constraint
C. Relational integrity constraint
D. Business-critical integrity constraint

21. What type of integrity constraint does not allow someone to create an order for a nonexistent customer? 
A. Relational integrity constraint
B. Business-critical integrity constraint
C. Information-critical integrity constraint
D. None of these

22. All of the following are business-critical integrity constraints except: 
A. The system will not allow an entry for an order for a nonexistent customer.
B. The system will not allow returns of fresh produce after 15 days past delivery.
C. The system will not allow shipping a product to a customer who does not have a valid address.
D. The system will not allow shipping a nonexistent product to a customer.

23. Which of the following uses a DBMS to interact with a database? 
A. Users of accounting programs
B. Users of human resource programs
C. Users of marketing programs
D. All of these

24. What type of website is best to build for a general informational website with static information? 
A. Data-driven website
B. Static website
C. Relational website
D. All of these

25. What type of website is best to build for a website with continually changing information, including press releases, new product information, and updated pricing? 
A. Data-driven website
B. Static website
C. Relational website
D. All of these

26. Which of the following is not an advantage of building a data-driven website? 
A. Minimizes human error.
B. Cuts production and update costs.
C. Improves or maximizes stability.
D. Minimizes or reduces efficiency.

27. What is a forward integration? 
A. Takes information entered into a given system and sends it to the application-generation component.
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes.
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes.
D. Takes information entered into a given system and sends it to the DBMS.

28. What is a backward integration? 
A. Takes information entered into a given system and sends it to the application-generation component.
B. Takes information entered into a given system and sends it automatically to all downstream systems and processes.
C. Takes information entered into a given system and sends it automatically to all upstream systems and processes.
D. Takes information entered into a given system and sends it to the DBMS.

--------------------------------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------------------

 

Chapter 8 Review

Student: ___________________________________________________________________________

1. A data warehouse is a _________ collection of information-gathered from many different ___________ databases-that supports business-analysis activities and decision-making tasks. 
A. Physical, transactional
B. Physical, operational
C. Logical, transactional
D. Logical, operational

2. What do data warehouses support? 
A. OLAP
B. Analytical processing
C. OLTP
D. OLAP and analytical processing

3. Which of the following describes ETL? 
A. A process that extracts information from internal and external databases.
B. A process that transforms information using a common set of enterprise definitions.
C. A process that loads information into a data warehouse.
D. All of these.

4. What is data mining? 
A. The common term for the representation of multidimensional information.
B. A particular attribute of information.
C. Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making.
D. Process of analyzing data to extract information not offered by the raw data alone.

5. When does information cleansing occur in the data warehouse? 
A. During the ETL process.
B. On the information, once it is in the data warehouse.
C. During the ETL process and once it is in the data warehouse.
D. During the ETL process and before it is in the data warehouse.

6. Which of the following statements is true regarding customer information? 
A. Customer information can exist in several operational systems.
B. Customer information in each operational system could change.
C. Customer information in each operational system can be different.
D. All of these.

7. Which of the following occurs during data cleansing? 
A. Clean missing records.
B. Clean redundant records.
C. Clean inaccurate data.
D. All of these.

8. Which of the following statements is true? 
A. The more complete an organization wants to get its information, the less it costs.
B. The more accurate an organization wants to get its information, the less it costs.
C. The less accurate an organization wants to get its information, the more it costs.
D. The more complete and accurate an organization wants to get its information, the more it costs.

9. What is information that people use to support their decision-making efforts? 
A. Information cleansing and scrubbing
B. Data-mining tools
C. Data mining
D. Business intelligence

10. Why is Ben & Jerry's using business intelligence? 
A. To improve quality.
B. To create new flavors of ice cream.
C. To improve financials.
D. To manage distribution.

11. Why is Noodles & Company using business intelligence? 
A. To improve financial analysis.
B. To improve corporate processes.
C. To track store quality.
D. To change the corporate culture.

12. Why would a business use a data warehouse that offers strategic level, external, integrated, and historical information? 
A. Identify trends.
B. Make projections.
C. Decide key business issues.
D. All of these.

13. What is the primary purpose of a data warehouse? 
A. To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
B. To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
C. To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
D. To disaggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.

14. Lands' End created an organization-wide data warehouse so all its employees could access organizational information. Lands' End soon found out that there could be "too much of a good thing." Many of its employees would not use the data warehouse, because it was simply too big, too complicated, and had too much irrelevant information. Lands' End knew there was valuable information in its data warehouse, and it had to find a way for its employees to easily access the information. What was Lands' End's solution? 
A. Build a better, more efficient data warehouse.
B. Build a better, more efficient transactional database.
C. Build a data mart.
D. Build a data-driven website.

15. A relational database contains information in a series of two-dimensional tables. How is data contained in a data warehouse and data mart? 
A. Information is multidimensional, meaning it contains a single layer of data in a table format.
B. Information is two-dimensional, meaning it contains a single layer of data in a table format.
C. Information is two-dimensional, meaning it contains layers of columns and rows.
D. Information is multidimensional, meaning it contains layers of columns and rows.

16. What is a dimension? 
A. A particular attribute of information.
B. A particular entity of information.
C. A particular relational database.
D. A particular single repository.

17. A dimension is a particular attribute of information. Each layer in a data warehouse or data mart represents information according to an additional dimension. What is the common term for the representation of multidimensional information? 
A. Table
B. Block
C. Cube
D. All of these

18. Which of the following are the principle BI enablers? 
A. Technology, processes, and customer culture
B. Technology, people, and customer culture
C. Technology, processes, and corporate culture
D. Technology, people, and corporate culture

19. The primary purpose of a data warehouse is to perform transactional processes. 
True    False

20. A dimension is a particular attribute of information. 
True    False

 --------------------------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------------------------------

 

Chapter 9 review

Student: ___________________________________________________________________________

1. Which of the following is not a reason for the growth of decision-making information systems? 
A. People need to analyze large amounts of information.
B. People must make decisions quickly.
C. People must apply sophisticated analysis techniques to make good decisions.
D. People no longer have to worry about protecting the corporate asset of organizational information.

2. What can a model accomplish? 
A. Calculate risks
B. Understand uncertainty
C. Manipulate time
D. All of these

3. Which of the following is a quantitative model typically used by a DSS? 
A. Sensitivity analysis
B. What-if analysis
C. Goal-seeking analysis
D. All of these

4. What is the study of the effect that changes in one (or more) part of the model has on other parts of the model? 
A. Drill-down
B. Sensitivity analysis
C. Statistical analysis
D. Goal-seeking analysis

5. What finds the inputs necessary to achieve a goal, such as a desired level of output? 
A. Drill-down
B. Sensitivity analysis
C. What-if analysis
D. Goal-seeking analysis

6. What is consolidation? 
A. Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information.
B. The ability to look at information from different perspectives.
C. Enables users to get details, and details of details, of information.
D. Finds the inputs necessary to achieve a goal, such as a desired level of output.

7. What is drill-down capability? 
A. Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information.
B. The ability to look at information from different perspectives.
C. Enables users to get details, and details of details, of information.
D. Finds the inputs necessary to achieve a goal, such as a desired level of output.

8. What is slice-and-dice capability? 
A. Involves the aggregation of information and features simple roll-ups to complex groupings of interrelated information.
B. The ability to look at information from different perspectives.
C. Enables users to get details, and details of details, of information.
D. Finds the inputs necessary to achieve a goal, such as a desired level of output.

9. What integrates information from multiple components and tailors the information to individual preferences? 
A. Drill-down
B. Sensitivity analysis
C. What-if analysis
D. Digital dashboard

10. What are various commercial applications of artificial intelligence? 
A. Drill-down
B. Sensitivity analysis
C. Digital dashboard
D. Intelligent systems

11. What is a category of AI that attempts to emulate the way the human brain works? 
A. Intelligent system
B. Artificial intelligence
C. Expert systems
D. Neural network

12. Which of the following is the most commonly used form of AI in the business arena? 
A. Intelligent system
B. Artificial intelligence
C. Expert system
D. Neural network

13. What is a special-purpose, knowledge-based information system that accomplishes specific tasks on behalf of its users? 
A. Intelligent system
B. Artificial intelligence
C. Neural network
D. Intelligent agent

14. What is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem? 
A. Intelligent system
B. Artificial intelligence
C. Neural network
D. Genetic algorithm

15. Which of the following represents the top-down (executives to analysts) organizational levels of information technology systems? 
A. TPS, DSS, EIS.
B. DSS, TPS, EIS.
C. EIS, DSS, TPS.
D. None of these. It varies from organization to organization.

16. Which of the following is a type of transaction-processing system? 
A. Order processing
B. Sales
C. Manufacturing
D. Transportation

17. Which of the following is a type of decision-support system? 
A. Order processing
B. Inventory tracking
C. Manufacturing
D. All of these

18. A genetic algorithm is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem. 
True    False

19. The ultimate goal of AI is to build a system that can mimic human intelligence. 
True    False

20. Sensitivity analysis, what-if analysis, and market-basket analysis are the three quantitative models typically used by a DSS. 
True    False

21. Consolidation, drill-down, and slice-and-dice are the three most common capabilities offered in an EIS. 
True    False

22. A(n) ___________ is a simplified representation or abstraction of reality. 
________________________________________

23. ___________ analysis occurs when users change the value of one variable repeatedly and observe the resulting changes in other variables.

Answer: Sensitivity 

24. __________ analysis checks the impact of a change in an assumption on the proposed solution.

Answer: What-if  

25. _________ analysis could answer the question "How many customers are required to purchase our new product line to increase gross profits to $5 million?"

Answer: Goal-seeking  

26. Fuzzy Logic __ is a mathematical method of handling imprecise or subjective information. 
________________________________________

27. Intelligent system ___ are various commercial applications of artificial intelligence. 
________________________________________

28. Artificial intelligence simulates ______________ intelligence, such as the ability to reason and learn. 
________________________________________

29. Expert Systems __ are computerized advisory programs that imitate the reasoning processes of experts in solving difficult problems. 
________________________________________

30. A(n) _________ agent is a special-purpose knowledge-based information system that accomplishes specific tasks on behalf of its users. 
________________________________________