INFORMATION-SYSTEMS/DATA-MANAGEMENT
EXAM QUESTIONS AND ANSWERS
1. Which concept best describes the purpose of an information system in an
organization?
A. Eliminating all human decision-making
B. Collecting, processing, storing, and distributing information to support
organizational activities
C. Replacing organizational policies
D. Preventing access to business data
2. What is the primary purpose of a database management system (DBMS)?
A. Design computer hardware
B. Manage, organize, retrieve, and maintain data in databases
C. Replace an operating system
D. Encrypt every file on a computer
3. Which characteristic of data refers to how recently the data was collected or
updated?
A. Accuracy
B. Completeness
C. Timeliness
D. Consistency
4. A company wants to ensure that only authorized employees can access
confidential customer records. Which security principle is most directly involved?
A. Availability
B. Confidentiality
C. Redundancy
D. Scalability
5. Which type of system is primarily designed to support routine, day-to-day
business transactions?
A. Decision support system
B. Transaction processing system
C. Executive support system
D. Expert system
6. What is a key advantage of using a relational database?
A. It eliminates the need for data validation
B. It stores all information in a single unstructured file
C. It organizes data into related tables using defined relationships
D. It prevents multiple users from accessing data
7. Which database key uniquely identifies each record in a table?
A. Foreign key
,B. Composite attribute
C. Primary key
D. Secondary value
8. What is the main purpose of a foreign key?
A. Encrypt database records
B. Identify the database administrator
C. Establish a relationship between records in different tables
D. Prevent duplicate databases
9. Which process involves examining data to identify patterns, relationships, and
useful insights?
A. Data entry
B. Data storage
C. Data analysis
D. Data deletion
10. Which statement best describes data integrity?
A. Data is always publicly available
B. Data remains accurate, consistent, and reliable throughout its lifecycle
C. Data is stored exclusively in the cloud
D. Data cannot be changed under any circumstances
11. What is the purpose of normalization in a relational database?
A. Increase unnecessary duplication
B. Convert databases into spreadsheets
C. Reduce data redundancy and improve data integrity
D. Eliminate relationships between tables
12. An organization uses dashboards containing charts, graphs, and key
performance indicators to monitor operations. This is an example of:
A. Batch processing
B. Business intelligence
C. Data destruction
D. Physical security
13. Which type of analytics focuses on determining what is likely to happen in the
future?
A. Descriptive analytics
B. Diagnostic analytics
C. Predictive analytics
D. Transactional analytics
14. Which analytics approach answers the question, “What happened?”
A. Descriptive analytics
B. Predictive analytics
C. Prescriptive analytics
D. Preventive analytics
, 15. Which analytics approach recommends actions based on predicted outcomes?
A. Descriptive analytics
B. Diagnostic analytics
C. Predictive analytics
D. Prescriptive analytics
16. What is a major benefit of cloud computing for organizations?
A. It guarantees zero security risks
B. It can provide scalable computing resources without requiring all infrastructure
to be owned locally
C. It eliminates the need for cybersecurity
D. It prevents remote access
17. Which cloud service model provides users with applications managed by the
cloud provider?
A. IaaS
B. PaaS
C. SaaS
D. LAN
18. Which cloud service model provides virtualized computing infrastructure such as
servers and storage?
A. IaaS
B. SaaS
C. CRM
D. ERP
19. Why is data governance important to an organization?
A. It eliminates all organizational data
B. It allows employees unrestricted access to every record
C. It establishes policies, responsibilities, and standards for managing
organizational data
D. It guarantees that data never changes
20. An organization requires employees to use strong passwords and multi-factor
authentication. These controls primarily help to:
A. Increase database redundancy
B. Improve data visualization
C. Protect systems and data from unauthorized access
D. Increase transaction processing speed
21. Which component of an information system includes the people who use and
manage the system?
A. Hardware
B. Software
C. People
EXAM QUESTIONS AND ANSWERS
1. Which concept best describes the purpose of an information system in an
organization?
A. Eliminating all human decision-making
B. Collecting, processing, storing, and distributing information to support
organizational activities
C. Replacing organizational policies
D. Preventing access to business data
2. What is the primary purpose of a database management system (DBMS)?
A. Design computer hardware
B. Manage, organize, retrieve, and maintain data in databases
C. Replace an operating system
D. Encrypt every file on a computer
3. Which characteristic of data refers to how recently the data was collected or
updated?
A. Accuracy
B. Completeness
C. Timeliness
D. Consistency
4. A company wants to ensure that only authorized employees can access
confidential customer records. Which security principle is most directly involved?
A. Availability
B. Confidentiality
C. Redundancy
D. Scalability
5. Which type of system is primarily designed to support routine, day-to-day
business transactions?
A. Decision support system
B. Transaction processing system
C. Executive support system
D. Expert system
6. What is a key advantage of using a relational database?
A. It eliminates the need for data validation
B. It stores all information in a single unstructured file
C. It organizes data into related tables using defined relationships
D. It prevents multiple users from accessing data
7. Which database key uniquely identifies each record in a table?
A. Foreign key
,B. Composite attribute
C. Primary key
D. Secondary value
8. What is the main purpose of a foreign key?
A. Encrypt database records
B. Identify the database administrator
C. Establish a relationship between records in different tables
D. Prevent duplicate databases
9. Which process involves examining data to identify patterns, relationships, and
useful insights?
A. Data entry
B. Data storage
C. Data analysis
D. Data deletion
10. Which statement best describes data integrity?
A. Data is always publicly available
B. Data remains accurate, consistent, and reliable throughout its lifecycle
C. Data is stored exclusively in the cloud
D. Data cannot be changed under any circumstances
11. What is the purpose of normalization in a relational database?
A. Increase unnecessary duplication
B. Convert databases into spreadsheets
C. Reduce data redundancy and improve data integrity
D. Eliminate relationships between tables
12. An organization uses dashboards containing charts, graphs, and key
performance indicators to monitor operations. This is an example of:
A. Batch processing
B. Business intelligence
C. Data destruction
D. Physical security
13. Which type of analytics focuses on determining what is likely to happen in the
future?
A. Descriptive analytics
B. Diagnostic analytics
C. Predictive analytics
D. Transactional analytics
14. Which analytics approach answers the question, “What happened?”
A. Descriptive analytics
B. Predictive analytics
C. Prescriptive analytics
D. Preventive analytics
, 15. Which analytics approach recommends actions based on predicted outcomes?
A. Descriptive analytics
B. Diagnostic analytics
C. Predictive analytics
D. Prescriptive analytics
16. What is a major benefit of cloud computing for organizations?
A. It guarantees zero security risks
B. It can provide scalable computing resources without requiring all infrastructure
to be owned locally
C. It eliminates the need for cybersecurity
D. It prevents remote access
17. Which cloud service model provides users with applications managed by the
cloud provider?
A. IaaS
B. PaaS
C. SaaS
D. LAN
18. Which cloud service model provides virtualized computing infrastructure such as
servers and storage?
A. IaaS
B. SaaS
C. CRM
D. ERP
19. Why is data governance important to an organization?
A. It eliminates all organizational data
B. It allows employees unrestricted access to every record
C. It establishes policies, responsibilities, and standards for managing
organizational data
D. It guarantees that data never changes
20. An organization requires employees to use strong passwords and multi-factor
authentication. These controls primarily help to:
A. Increase database redundancy
B. Improve data visualization
C. Protect systems and data from unauthorized access
D. Increase transaction processing speed
21. Which component of an information system includes the people who use and
manage the system?
A. Hardware
B. Software
C. People
