INF2603
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
,UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2024
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Mrs CL Hlengwa
This paper consists of 7 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 2024
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)):
For question 1 to 5: Indicate whether the statement is true or false. (2 marks each):
1. Overlapping subtypes are subtypes that contain nonunique subsets of the
supertype entity set; that is, each entity instance of the supertype may appear in
more than one subtype.
a. True
b. False
2. Within a specialisation hierarchy, every subtype can have many supertypes to
which it is directly related.
a. True
b. False
3. If Capricon TVET College had some departments that were classified as “research
only,” they would not offer courses; therefore, the COURSE entity would be
independent to the DEPARTMENT entity.
a. True
b. False
4. A cloud database is a database that is built, deployed, and accessed in a cloud
environment, such as a private, public, or hybrid cloud.
a. True
b. False
5. The multivalued type of attribute cannot be created in a DBMS.
a. True
b. False
TURN OVER
, 3
INF2603
OCTOBER/NOVEMBER 2024
For question 6 to 10: Identify the choice that best completes the statement or answer the
question. (2 marks each):
a. CHECK
b. HAVING
c. EXISTS
d. UPDATE
e. LIKE
6. Validates data in an attribute.
7. Checks whether a subquery returns any rows.
8. Restricts the selection of grouped rows based on a condition.
9. Modifies an attribute’s values in one or more table’s rows.
10. Checks whether an attribute value matches a given string pattern
TURN OVER
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
,UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2024
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Mrs CL Hlengwa
This paper consists of 7 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 2024
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)):
For question 1 to 5: Indicate whether the statement is true or false. (2 marks each):
1. Overlapping subtypes are subtypes that contain nonunique subsets of the
supertype entity set; that is, each entity instance of the supertype may appear in
more than one subtype.
a. True
b. False
2. Within a specialisation hierarchy, every subtype can have many supertypes to
which it is directly related.
a. True
b. False
3. If Capricon TVET College had some departments that were classified as “research
only,” they would not offer courses; therefore, the COURSE entity would be
independent to the DEPARTMENT entity.
a. True
b. False
4. A cloud database is a database that is built, deployed, and accessed in a cloud
environment, such as a private, public, or hybrid cloud.
a. True
b. False
5. The multivalued type of attribute cannot be created in a DBMS.
a. True
b. False
TURN OVER
, 3
INF2603
OCTOBER/NOVEMBER 2024
For question 6 to 10: Identify the choice that best completes the statement or answer the
question. (2 marks each):
a. CHECK
b. HAVING
c. EXISTS
d. UPDATE
e. LIKE
6. Validates data in an attribute.
7. Checks whether a subquery returns any rows.
8. Restricts the selection of grouped rows based on a condition.
9. Modifies an attribute’s values in one or more table’s rows.
10. Checks whether an attribute value matches a given string pattern
TURN OVER
