CMIS 351 FINAL EXAM STUDY GUIDE 2026 |
MANAGEMENT INFORMATION SYSTEMS Q&A
| ATHABASCA UNIVERSITY
CMIS 351 FINAL EXAM STUDY GUIDE 2026
MANAGEMENT INFORMATION SYSTEMS Q&A | ATHABASCA UNIVERSITY
DOCUMENT OVERVIEW
• This comprehensive 200-question study guide is designed to reinforce your
understanding of core Management Information Systems concepts through
rigorous practice and detailed explanations for each correct answer.
• Use this material by working through questions systematically, testing your
knowledge before reviewing rationales, and focusing on areas where your
understanding is weakest to maximize exam readiness.
QUESTIONS
1. Which of the following best defines an information system (IS)?
A) A collection of hardware only used to store data
B) An integrated set of components for collecting, storing, processing, and
delivering information to support decision-making and operations in an
organization
C) A network of computers connected to the internet
D) Software programs installed on personal computers
E) A database management system used exclusively by IT departments
✓ CORRECT ANSWER: B) An integrated set of components for collecting,
storing, processing, and delivering information to support decision-making
and operations in an organization
,RATIONALE: An information system encompasses more than just technology—it
includes people, processes, and technology working together. It integrates
hardware, software, data, people, and processes to transform raw data into
actionable information that helps organizations achieve their strategic objectives.
While databases and networks are components of IS, they are not the complete
definition.
2. What is the primary role of strategic information systems planning?
A) To reduce IT department budgets
B) To align IS initiatives with organizational business strategy and competitive
advantage
C) To eliminate the need for IT staff
D) To focus solely on cost reduction without considering business outcomes
E) To replace all manual processes with automated systems
✓ CORRECT ANSWER: B) To align IS initiatives with organizational business
strategy and competitive advantage
RATIONALE: Strategic IS planning ensures that information technology investments
directly support the organization's business goals and create competitive
advantages. This alignment bridges the gap between IT and business objectives,
ensuring that technology spending translates to business value and improved
organizational performance.
3. Which of the following is NOT a typical characteristic of a transaction
processing system (TPS)?
A) Processes daily routine business transactions
B) Provides real-time data for strategic decision-making
C) Ensures accuracy and reliability in capturing transactions
D) Maintains audit trails for compliance
,E) Uses batch processing or online processing methods
✓ CORRECT ANSWER: B) Provides real-time data for strategic decision-making
RATIONALE: While TPSs record transactions in real-time, their primary purpose is to
efficiently process routine transactions rather than provide strategic insights.
Strategic decision-making typically relies on management information systems
(MIS) and executive information systems (EIS) that analyze and synthesize TPS data
into meaningful business intelligence, rather than raw transactional data.
4. What is the primary purpose of an Enterprise Resource Planning (ERP)
system?
A) To manage only the human resources department
B) To integrate and manage business processes across an entire organization
C) To replace all department-specific systems without improvement
D) To focus exclusively on financial accounting
E) To provide internet connectivity to all employees
✓ CORRECT ANSWER: B) To integrate and manage business processes across
an entire organization
RATIONALE: ERP systems are designed to unify all business functions—finance, HR,
procurement, supply chain, manufacturing, and sales—into a single integrated
platform. This integration reduces data silos, improves information flow, increases
operational efficiency, and provides real-time visibility into organizational
performance across all departments.
5. Which database model organizes data in a hierarchical tree structure?
A) Relational model
B) Network model
C) Hierarchical model
, D) Object-oriented model
E) Document model
✓ CORRECT ANSWER: C) Hierarchical model
RATIONALE: The hierarchical model organizes data in a tree-like structure with a
single parent-multiple children relationship. While this model was popular in early
mainframe systems (such as IBM's IMS), it has limitations in representing complex
relationships. The relational model has become the standard because it provides
greater flexibility and ease of query.
6. What is database normalization primarily designed to achieve?
A) To increase database size and storage requirements
B) To eliminate data redundancy and improve data integrity
C) To make queries run slower for better control
D) To reduce the number of users who can access the database
E) To complicate data relationships
✓ CORRECT ANSWER: B) To eliminate data redundancy and improve data
integrity
RATIONALE: Normalization is a systematic process of organizing database tables to
minimize data redundancy, eliminate anomalies in data modification, and ensure
data consistency. By breaking data into normalized forms (1NF, 2NF, 3NF, etc.),
databases become more efficient, maintainable, and reliable, reducing storage
waste and preventing update anomalies.
7. What does SQL (Structured Query Language) primarily do?
A) Designs network protocols for data transmission
B) Manages hardware configurations and device drivers
C) Defines, retrieves, and manipulates data in relational databases
MANAGEMENT INFORMATION SYSTEMS Q&A
| ATHABASCA UNIVERSITY
CMIS 351 FINAL EXAM STUDY GUIDE 2026
MANAGEMENT INFORMATION SYSTEMS Q&A | ATHABASCA UNIVERSITY
DOCUMENT OVERVIEW
• This comprehensive 200-question study guide is designed to reinforce your
understanding of core Management Information Systems concepts through
rigorous practice and detailed explanations for each correct answer.
• Use this material by working through questions systematically, testing your
knowledge before reviewing rationales, and focusing on areas where your
understanding is weakest to maximize exam readiness.
QUESTIONS
1. Which of the following best defines an information system (IS)?
A) A collection of hardware only used to store data
B) An integrated set of components for collecting, storing, processing, and
delivering information to support decision-making and operations in an
organization
C) A network of computers connected to the internet
D) Software programs installed on personal computers
E) A database management system used exclusively by IT departments
✓ CORRECT ANSWER: B) An integrated set of components for collecting,
storing, processing, and delivering information to support decision-making
and operations in an organization
,RATIONALE: An information system encompasses more than just technology—it
includes people, processes, and technology working together. It integrates
hardware, software, data, people, and processes to transform raw data into
actionable information that helps organizations achieve their strategic objectives.
While databases and networks are components of IS, they are not the complete
definition.
2. What is the primary role of strategic information systems planning?
A) To reduce IT department budgets
B) To align IS initiatives with organizational business strategy and competitive
advantage
C) To eliminate the need for IT staff
D) To focus solely on cost reduction without considering business outcomes
E) To replace all manual processes with automated systems
✓ CORRECT ANSWER: B) To align IS initiatives with organizational business
strategy and competitive advantage
RATIONALE: Strategic IS planning ensures that information technology investments
directly support the organization's business goals and create competitive
advantages. This alignment bridges the gap between IT and business objectives,
ensuring that technology spending translates to business value and improved
organizational performance.
3. Which of the following is NOT a typical characteristic of a transaction
processing system (TPS)?
A) Processes daily routine business transactions
B) Provides real-time data for strategic decision-making
C) Ensures accuracy and reliability in capturing transactions
D) Maintains audit trails for compliance
,E) Uses batch processing or online processing methods
✓ CORRECT ANSWER: B) Provides real-time data for strategic decision-making
RATIONALE: While TPSs record transactions in real-time, their primary purpose is to
efficiently process routine transactions rather than provide strategic insights.
Strategic decision-making typically relies on management information systems
(MIS) and executive information systems (EIS) that analyze and synthesize TPS data
into meaningful business intelligence, rather than raw transactional data.
4. What is the primary purpose of an Enterprise Resource Planning (ERP)
system?
A) To manage only the human resources department
B) To integrate and manage business processes across an entire organization
C) To replace all department-specific systems without improvement
D) To focus exclusively on financial accounting
E) To provide internet connectivity to all employees
✓ CORRECT ANSWER: B) To integrate and manage business processes across
an entire organization
RATIONALE: ERP systems are designed to unify all business functions—finance, HR,
procurement, supply chain, manufacturing, and sales—into a single integrated
platform. This integration reduces data silos, improves information flow, increases
operational efficiency, and provides real-time visibility into organizational
performance across all departments.
5. Which database model organizes data in a hierarchical tree structure?
A) Relational model
B) Network model
C) Hierarchical model
, D) Object-oriented model
E) Document model
✓ CORRECT ANSWER: C) Hierarchical model
RATIONALE: The hierarchical model organizes data in a tree-like structure with a
single parent-multiple children relationship. While this model was popular in early
mainframe systems (such as IBM's IMS), it has limitations in representing complex
relationships. The relational model has become the standard because it provides
greater flexibility and ease of query.
6. What is database normalization primarily designed to achieve?
A) To increase database size and storage requirements
B) To eliminate data redundancy and improve data integrity
C) To make queries run slower for better control
D) To reduce the number of users who can access the database
E) To complicate data relationships
✓ CORRECT ANSWER: B) To eliminate data redundancy and improve data
integrity
RATIONALE: Normalization is a systematic process of organizing database tables to
minimize data redundancy, eliminate anomalies in data modification, and ensure
data consistency. By breaking data into normalized forms (1NF, 2NF, 3NF, etc.),
databases become more efficient, maintainable, and reliable, reducing storage
waste and preventing update anomalies.
7. What does SQL (Structured Query Language) primarily do?
A) Designs network protocols for data transmission
B) Manages hardware configurations and device drivers
C) Defines, retrieves, and manipulates data in relational databases
