INF2603
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
,UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2023
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms CL Hlengwa
This paper consists of 5 pages.
Instructions:
1. Answer all questions.
2. The marks for each question are given in brackets next to the question.
3. Please answer the questions in the order in which they have been set.
4. You signed an Honesty Declaration. This means you will complete this paper on
your own and without help.
5. This final pdf document should not be password protected.
6. Convert all the pages into a single PDF file.
7. Poorly scanned and hard to read answer files will result in a zero mark.
8. Once your document meets all the criteria, then you can upload the file to myAdmin.
GOOD LUCK.
, 2
INF2603
OCTOBER/NOVEMBER 2023
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. 11. (e)) (2 marks each):
1. The _____ is actually a system-created database whose tables store the
user/designer-created database characteristics and contents.
a. unique index
b. database tuple
c. system catalogue
d. systematic database
2. Within the relational model, tables are known as ____, columns of tables are referred
to as ____ and rows of tables are called ____.
a. tuples, attributes, entities
b. relations, attributes, tuples
c. relations, tuples, attributes
d. relation, attributes, tuples
3. Which of the following returns all tuples in one relation that are not found in the other
relation?
a. PRODUCT
b. SELECT
c. PROJECT
d. DIFFERENCE
4. The STUDENT table’s primary key is STUDENT_NUMB. The STUDENT primary key
column has no null entries, and all entries are unique. This is an example of _____
integrity.
a. null
b. entity
c. relational
d. referential
5. Which of the following is true of NoSQL databases?
a. They do not support distributed database architectures.
b. They are not based on the relational model.
c. They are geared toward transaction consistency rather than performance.
d. They do not support very large amounts of sparse data.
6. 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.
TURN OVER