CAIE 9701 PAPER 3 2024 COMPLETE QUESTIONS AND
ANSWERS WITH VERIFIED SOLUTION
1. What is the main benefit of using normalization in a relational
database?
A. It minimizes data redundancy and improves data integrity.
B. It speeds up the querying process.
C. It allows faster sorting of records.
D. It simplifies the data model.
Answer: A) It minimizes data redundancy and improves data integrity.
Rationale: Normalization helps eliminate redundant data and ensures
that the database structure is optimized for data integrity.
2. What is the time complexity of the bubble sort algorithm?
A. O(n)
B. O(n^2)
C. O(log n)
D. O(n log n)
Answer: B) O(n^2)
Rationale: The bubble sort algorithm has a time complexity of O(n^2)
because it requires multiple passes through the data, with each pass
involving comparisons of adjacent elements.
3. What does the term 'polymorphism' in object-oriented programming
refer to?
A. The ability of a class to inherit properties from another class
B. The ability to define multiple constructors in a class
C. The ability to use a method or operator in different ways
D. The ability to create objects of multiple classes
Answer: C) The ability to use a method or operator in different ways
Rationale: Polymorphism allows a method or function to behave
,differently based on the object it is applied to, enabling one interface to
be used for different data types.
4. Which of the following is the primary function of a database
management system (DBMS)?
A. To store and retrieve data
B. To provide user interfaces
C. To perform mathematical calculations
D. To manage network security
Answer: A) To store and retrieve data
Rationale: A DBMS is primarily responsible for storing, retrieving, and
managing data in a database.
5. Which of the following is NOT a characteristic of a class in object-
oriented programming?
A. It encapsulates data and behavior.
B. It can inherit from other classes.
C. It must be instantiated before use.
D. It cannot be extended by other classes.
Answer: D) It cannot be extended by other classes.
Rationale: Classes in OOP can be extended (through inheritance),
which is a key feature of OOP.
6. What is a key difference between a relational database and a non-
relational database?
A. Relational databases store data in tables, whereas non-relational
databases do not.
B. Non-relational databases are more rigid in data structure.
C. Relational databases use JSON format, while non-relational
databases do not.
D. Non-relational databases require SQL queries.
, Answer: A) Relational databases store data in tables, whereas non-
relational databases do not.
Rationale: Relational databases store data in tables with predefined
schemas, while non-relational databases use more flexible data formats
like key-value pairs, documents, or graphs.
7. Which of the following describes a linked list data structure?
A. A collection of elements that can be accessed directly by their index.
B. A linear structure with nodes where each node points to the next
one.
C. A collection of elements stored in a sorted order.
D. A static data structure with fixed size.
Answer: B) A linear structure with nodes where each node points to the
next one.
Rationale: A linked list consists of nodes, where each node points to the
next node in the sequence, allowing for dynamic size.
8. Which of the following best describes a "full outer join" in SQL?
A. It returns rows when there is a match in one of the tables.
B. It returns only rows where there is a match in both tables.
C. It returns all rows from both tables, with NULLs where there is no
match.
D. It returns only rows that do not match in either table.
Answer: C) It returns all rows from both tables, with NULLs where
there is no match.
Rationale: A full outer join returns all rows from both tables, including
unmatched rows, where NULL values are used for missing data.
9. Which of the following is the primary purpose of an algorithm?
A. To solve problems
B. To write a computer program
ANSWERS WITH VERIFIED SOLUTION
1. What is the main benefit of using normalization in a relational
database?
A. It minimizes data redundancy and improves data integrity.
B. It speeds up the querying process.
C. It allows faster sorting of records.
D. It simplifies the data model.
Answer: A) It minimizes data redundancy and improves data integrity.
Rationale: Normalization helps eliminate redundant data and ensures
that the database structure is optimized for data integrity.
2. What is the time complexity of the bubble sort algorithm?
A. O(n)
B. O(n^2)
C. O(log n)
D. O(n log n)
Answer: B) O(n^2)
Rationale: The bubble sort algorithm has a time complexity of O(n^2)
because it requires multiple passes through the data, with each pass
involving comparisons of adjacent elements.
3. What does the term 'polymorphism' in object-oriented programming
refer to?
A. The ability of a class to inherit properties from another class
B. The ability to define multiple constructors in a class
C. The ability to use a method or operator in different ways
D. The ability to create objects of multiple classes
Answer: C) The ability to use a method or operator in different ways
Rationale: Polymorphism allows a method or function to behave
,differently based on the object it is applied to, enabling one interface to
be used for different data types.
4. Which of the following is the primary function of a database
management system (DBMS)?
A. To store and retrieve data
B. To provide user interfaces
C. To perform mathematical calculations
D. To manage network security
Answer: A) To store and retrieve data
Rationale: A DBMS is primarily responsible for storing, retrieving, and
managing data in a database.
5. Which of the following is NOT a characteristic of a class in object-
oriented programming?
A. It encapsulates data and behavior.
B. It can inherit from other classes.
C. It must be instantiated before use.
D. It cannot be extended by other classes.
Answer: D) It cannot be extended by other classes.
Rationale: Classes in OOP can be extended (through inheritance),
which is a key feature of OOP.
6. What is a key difference between a relational database and a non-
relational database?
A. Relational databases store data in tables, whereas non-relational
databases do not.
B. Non-relational databases are more rigid in data structure.
C. Relational databases use JSON format, while non-relational
databases do not.
D. Non-relational databases require SQL queries.
, Answer: A) Relational databases store data in tables, whereas non-
relational databases do not.
Rationale: Relational databases store data in tables with predefined
schemas, while non-relational databases use more flexible data formats
like key-value pairs, documents, or graphs.
7. Which of the following describes a linked list data structure?
A. A collection of elements that can be accessed directly by their index.
B. A linear structure with nodes where each node points to the next
one.
C. A collection of elements stored in a sorted order.
D. A static data structure with fixed size.
Answer: B) A linear structure with nodes where each node points to the
next one.
Rationale: A linked list consists of nodes, where each node points to the
next node in the sequence, allowing for dynamic size.
8. Which of the following best describes a "full outer join" in SQL?
A. It returns rows when there is a match in one of the tables.
B. It returns only rows where there is a match in both tables.
C. It returns all rows from both tables, with NULLs where there is no
match.
D. It returns only rows that do not match in either table.
Answer: C) It returns all rows from both tables, with NULLs where
there is no match.
Rationale: A full outer join returns all rows from both tables, including
unmatched rows, where NULL values are used for missing data.
9. Which of the following is the primary purpose of an algorithm?
A. To solve problems
B. To write a computer program
