ITM 100 M/C Examples 1 2025/2026 Midterm Review

Q1. Identify the key term based on a definition
The technical term for a row in a relational database table is a(n):
a) Record
b) Primary key
c) Element
d) Key field
e) Attribute

a) Record

Q2. Fill in the blanks in the form of multiple choice
A(n) ______ centralizes data from various key business processes and stores the data in a single, comprehensive data repository, and usable by all units of the organization.
a) Transaction processing system
b) Enterprise system
c) Automatic reporting system
d) Management information system
e) Operational management system

b) Enterprise system

Q3. If Netflix uses viewing history to recommend a new show, what kind of system capability is being used?
A. Transactional processing
B. Predictive analytics
C. Diagnostic analytics
D. Prescriptive reporting

b) Predictive analytics

Q4. What’s the relationship between IS and IT?
A. IS = IT + People + Processes
B. IT = IS + Data Governance
C. IS and IT are identical
D. IT excludes data storage

a) IS = IT + People + Processes

Q5. Which improvement in business process would most directly streamline a process?
A. Adding new checkpoints to minimize potential errors
B. Removing redundant data entry
C. Segmenting tasks to ensure specialization of every role
D. Documenting every possible exception

b) Removing redundant data entry

Q6. Which BPMN symbol represents a decision point?
A. Circle
B. Rectangle
C. Diamond
D. Arrow

c) Diamond (Gateway)

Q7. A manager maps “As-Is” and “To-Be” models. What is their goal?
A. To enforce automation immediately
B. To understand current Business Process and design a better one
C. To visualize IT infrastructure
D. To determine database structure

b) To understand current business process and design a better one

Q8. Which type of process is most likely customer-facing?
A. Training employees
B. Handling online purchases
C. Conducting internal audits
D. Managing payroll

b) Handling online purchases

Q9. Which of the following best demonstrates scalability in an organization?
A. The system can add more users without crashing
B. The system uses multiple plots in dashboards
C. The company increases their hardware assets each year
D. The database have a back up every 24 hours

a) The system can add more users without crashing

Q10. Why might a hospital prefer a “hot site” disaster recovery setup?
A. It is the least expensive option
B. It provides instant system backup and minimal downtime
C. It eliminates all data duplication
D. It delays recovery until low-demand periods

b) It provides instant system backup and minimal downtime

Q11. A retail system works flawlessly but crashes when demand spikes on Black Friday. What’s the main issue?
A. Poor portability
B. Low scalability
C. High maintainability
D. Weak security

b) Low scalability

Q12. A company that integrates order processing, inventory, and accounting systems is most likely implementing:
A. EAI (Enterprise Application Integration)
B. ERP (Enterprise Resource Planning)
C. CRM (Customer Relationship Management)
D. SCM (Supply Chain Management)

b) ERP (Enterprise Resource Planning)

Q13. A retail chain uses data analytics to predict what customers will buy next. This functionality belongs primarily to:
A. SCM
B. CRM
C. ERP
D. EAI

c) CRM (Customer Relationship Management)

Q14. If a Billing system updates a store’s order entry system, what kind of integration is happening?
A. Forward integration
B. Backward integration
C. Upward integration
D. Lateral integration

b) Backward integration

Q15. Which system ensures that raw materials arrive just in time for production?
A. ERP
B. SCM
C. CRM
D. OLAP

b) SCM (Supply Chain Management)

Q16. A company comparing ERP options decides they prefer not to manage hardware or software maintenance internally. Which ERP deployment model fits best?
A. On-premise ERP
B. Hybrid ERP
C. Cloud ERP
D. Legacy ERP

c) Cloud ERP

Q17. Which phase of the ETL process cleans and formats data?
A. Extract
B. Transform
C. Load
D. Validate

b) Transform