INF2630 Comprehensive Exam and Study Pack: Worked Out Exam Papers from 2017 until October 2022 plus past assignments.

Study & Exam Pack (2023)




Study & Exam Pack (2023)

, Contents
INF2603 (Database 1) OCTOBER/NOVEMBER 2022 (Answers) ................................. 1

INF2603 (Database 1) OCTOBER/NOVEMBER 2021 (Answers) ............................... 10

INF2603 (Database 1) October / November 2020 (Answers) ...................................... 24

Older Memos are from here on and past assignmen ………………………….25- 310




INF2603 (Database 1) OCTOBER/NOVEMBER 2022 (Answers)



QUESTION 1 [20 marks]
Carefully select the most correct answer to each of the following questions. Please
write down only the question number and corresponding to it put the correct
option’s number (e.g. Qu. 1 (e)).
1. Which of the following is NOT a true statement about constraints:
a. Constraints are important because they help to ensure data integrity.
b. Constraints support high-level inserts, updates and deletes.
c. Constraints are normally expressed in the form of rules.
d. A constraint is a restriction placed on the data.
The correct answer is (d) because a constraint is a restriction placed on the data and
all other options are true statements about constraints.


2. The logical view of the relational database is facilitated by the ____.
a. objects defined by the database wizard
b. file system used by the operating system
c. creation of queries using the database wizard
d. creation of data relationships based on a construct known as a table
The correct answer is (d) because a logical view of a relational database is facilitated
by creating data relationships based on a construct known as a table.
3. ______ is a common term used in traditional entity relationship modelling, and
is used to express the maximum number of entity occurrences associated with
one occurrence of the related entity.
a. Participation