MIST 4630 MIDTERH EXAM PREPARATION 2025”2026 LATEST
VERSION 150 QUESTIONS AND CORRECT ANSWERS WITH RATIONALES
COVERING MOST TESTED QUESTIONS GUARANTEE OVER 80%
PASSMARK
1. Which of the following best describes the role of a database management system
(DBMS)?
☐ A. It only stores files for applications.
☑ B. It provides an interface for users and applications to interact with databases.
☐ C. It functions as a programming language.
☐ D. It is a type of hardware for storing data.
Rationale: A DBMS is software that allows users to create, manage, and interact with databases
efficiently, providing querying, security, and management functions.
2. In the context of network security, what is the main purpose of a firewall?
☐ A. To encrypt files on a hard drive.
☑ B. To monitor and control incoming and outgoing network traffic based on security rules.
☐ C. To store backup data securely.
☐ D. To host web applications.
Rationale: Firewalls protect networks by filtering traffic based on predefined security rules,
preventing unauthorized access.
3. Which algorithm is commonly used for sorting large datasets efficiently?
☐ A. Linear search
☑ B. Merge sort
☐ C. Binary search
☐ D. Hashing
Rationale: Merge sort uses a divide-and-conquer approach, making it efficient (O(n log n)) for
large datasets compared to simpler sorts like bubble or selection sort.
4. What is the primary purpose of normalization in database design?
☐ A. To improve database security
☑ B. To reduce redundancy and improve data integrity
,☐ C. To speed up network traffic
☐ D. To create reports automatically
Rationale: Normalization organizes data into tables to minimize redundancy and ensure
consistency.
5. Which type of cloud service provides virtualized computing resources over the internet?
☑ A. Infrastructure as a Service (IaaS)
☐ B. Platform as a Service (PaaS)
☐ C. Software as a Service (SaaS)
☐ D. Database as a Service (DBaaS)
Rationale: IaaS offers virtual machines, storage, and networking resources for users to deploy
and manage operating systems and applications.
6. In agile project management, what is a "sprint"?
☐ A. The entire project timeline
☑ B. A short, time-boxed period in which a team completes a set of tasks
☐ C. A project milestone review
☐ D. The documentation phase
Rationale: Sprints are short iterations (typically 2–4 weeks) in Agile where teams deliver
incremental features or improvements.
7. Which type of software testing involves checking individual components in isolation?
☑ A. Unit testing
☐ B. System testing
☐ C. Integration testing
☐ D. Acceptance testing
Rationale: Unit testing focuses on individual functions or modules to ensure each part works
correctly before integrating into a larger system.
8. What is the main advantage of using object-oriented programming (OOP)?
☐ A. Faster compilation times
☑ B. Encapsulation, modularity, and reusability
,☐ C. Requires less memory
☐ D. Simplifies network configurations
Rationale: OOP organizes code into objects, promoting modularity, encapsulation, inheritance,
and code reuse.
9. Which network topology connects all devices in a single line?
☐ A. Star
☑ B. Bus
☐ C. Ring
☐ D. Mesh
Rationale: In a bus topology, all devices share a single communication line. If the line fails, the
network can fail.
10. What is the primary function of an API (Application Programming Interface)?
☑ A. To allow different software systems to communicate with each other
☐ B. To store data on a server
☐ C. To protect networks from malware
☐ D. To compile source code
Rationale: APIs define how software components interact, allowing integration between
applications.
11. In cybersecurity, what is phishing?
☑ A. Fraudulent attempts to obtain sensitive information through deceptive emails or messages
☐ B. Encrypting files for security
☐ C. A type of firewall
☐ D. Software that monitors network traffic
Rationale: Phishing tricks users into revealing credentials or personal information via deceptive
communication.
12. Which database model uses tables with rows and columns to store data?
☐ A. Hierarchical
☑ B. Relational
, ☐ C. Network
☐ D. Object-oriented
Rationale: Relational databases organize data in tables, with relationships established via
primary and foreign keys.
13. What is the difference between symmetric and asymmetric encryption?
☑ A. Symmetric uses the same key for encryption/decryption; asymmetric uses public/private
keys
☐ B. Symmetric is slower than asymmetric
☐ C. Asymmetric does not encrypt data
☐ D. Symmetric requires no keys
Rationale: Symmetric encryption is faster but requires a shared secret key, while asymmetric
uses key pairs for secure communication.
14. In project management, what is the critical path?
☐ A. The shortest sequence of tasks
☑ B. The longest sequence of dependent tasks that determines the minimum project duration
☐ C. A backup plan for delays
☐ D. Tasks that can be ignored
Rationale: The critical path defines the project’s timeline; any delay in critical tasks delays the
entire project.
15. Which of the following is an example of a NoSQL database?
☐ A. MySQL
☑ B. MongoDB
☐ C. Oracle
☐ D. PostgreSQL
Rationale: MongoDB stores data in flexible, document-based formats, unlike traditional
relational databases.
16. What is RAID 1 primarily used for?
☐ A. Speed
VERSION 150 QUESTIONS AND CORRECT ANSWERS WITH RATIONALES
COVERING MOST TESTED QUESTIONS GUARANTEE OVER 80%
PASSMARK
1. Which of the following best describes the role of a database management system
(DBMS)?
☐ A. It only stores files for applications.
☑ B. It provides an interface for users and applications to interact with databases.
☐ C. It functions as a programming language.
☐ D. It is a type of hardware for storing data.
Rationale: A DBMS is software that allows users to create, manage, and interact with databases
efficiently, providing querying, security, and management functions.
2. In the context of network security, what is the main purpose of a firewall?
☐ A. To encrypt files on a hard drive.
☑ B. To monitor and control incoming and outgoing network traffic based on security rules.
☐ C. To store backup data securely.
☐ D. To host web applications.
Rationale: Firewalls protect networks by filtering traffic based on predefined security rules,
preventing unauthorized access.
3. Which algorithm is commonly used for sorting large datasets efficiently?
☐ A. Linear search
☑ B. Merge sort
☐ C. Binary search
☐ D. Hashing
Rationale: Merge sort uses a divide-and-conquer approach, making it efficient (O(n log n)) for
large datasets compared to simpler sorts like bubble or selection sort.
4. What is the primary purpose of normalization in database design?
☐ A. To improve database security
☑ B. To reduce redundancy and improve data integrity
,☐ C. To speed up network traffic
☐ D. To create reports automatically
Rationale: Normalization organizes data into tables to minimize redundancy and ensure
consistency.
5. Which type of cloud service provides virtualized computing resources over the internet?
☑ A. Infrastructure as a Service (IaaS)
☐ B. Platform as a Service (PaaS)
☐ C. Software as a Service (SaaS)
☐ D. Database as a Service (DBaaS)
Rationale: IaaS offers virtual machines, storage, and networking resources for users to deploy
and manage operating systems and applications.
6. In agile project management, what is a "sprint"?
☐ A. The entire project timeline
☑ B. A short, time-boxed period in which a team completes a set of tasks
☐ C. A project milestone review
☐ D. The documentation phase
Rationale: Sprints are short iterations (typically 2–4 weeks) in Agile where teams deliver
incremental features or improvements.
7. Which type of software testing involves checking individual components in isolation?
☑ A. Unit testing
☐ B. System testing
☐ C. Integration testing
☐ D. Acceptance testing
Rationale: Unit testing focuses on individual functions or modules to ensure each part works
correctly before integrating into a larger system.
8. What is the main advantage of using object-oriented programming (OOP)?
☐ A. Faster compilation times
☑ B. Encapsulation, modularity, and reusability
,☐ C. Requires less memory
☐ D. Simplifies network configurations
Rationale: OOP organizes code into objects, promoting modularity, encapsulation, inheritance,
and code reuse.
9. Which network topology connects all devices in a single line?
☐ A. Star
☑ B. Bus
☐ C. Ring
☐ D. Mesh
Rationale: In a bus topology, all devices share a single communication line. If the line fails, the
network can fail.
10. What is the primary function of an API (Application Programming Interface)?
☑ A. To allow different software systems to communicate with each other
☐ B. To store data on a server
☐ C. To protect networks from malware
☐ D. To compile source code
Rationale: APIs define how software components interact, allowing integration between
applications.
11. In cybersecurity, what is phishing?
☑ A. Fraudulent attempts to obtain sensitive information through deceptive emails or messages
☐ B. Encrypting files for security
☐ C. A type of firewall
☐ D. Software that monitors network traffic
Rationale: Phishing tricks users into revealing credentials or personal information via deceptive
communication.
12. Which database model uses tables with rows and columns to store data?
☐ A. Hierarchical
☑ B. Relational
, ☐ C. Network
☐ D. Object-oriented
Rationale: Relational databases organize data in tables, with relationships established via
primary and foreign keys.
13. What is the difference between symmetric and asymmetric encryption?
☑ A. Symmetric uses the same key for encryption/decryption; asymmetric uses public/private
keys
☐ B. Symmetric is slower than asymmetric
☐ C. Asymmetric does not encrypt data
☐ D. Symmetric requires no keys
Rationale: Symmetric encryption is faster but requires a shared secret key, while asymmetric
uses key pairs for secure communication.
14. In project management, what is the critical path?
☐ A. The shortest sequence of tasks
☑ B. The longest sequence of dependent tasks that determines the minimum project duration
☐ C. A backup plan for delays
☐ D. Tasks that can be ignored
Rationale: The critical path defines the project’s timeline; any delay in critical tasks delays the
entire project.
15. Which of the following is an example of a NoSQL database?
☐ A. MySQL
☑ B. MongoDB
☐ C. Oracle
☐ D. PostgreSQL
Rationale: MongoDB stores data in flexible, document-based formats, unlike traditional
relational databases.
16. What is RAID 1 primarily used for?
☐ A. Speed
