UNIVERSITY EXAMINATIONS
OCT/NOV 2022
INF3707
DATABASE DESIGN AND IMPLEMENTATION
Duration: 2 hours
Total marks: 100
Examiners:
First: Dr B. Chipangura
Second: Dr L. Motsi
External: Dr G. Toko
This is a closed book examination, under IRIS invigilation. Unisa exam policy applies.
Instructions to students
1. Answer all questions in the given order.
2. You are not allowed to use Mobile devices, Calculators or Oracle XE during this exam.
3. Study the tables in Annexure A.
4. Students must upload their answer scripts in a single PDF file (answer scripts must not be
password protected or uploaded as “read only” files.)
5. NO emailed scripts will be accepted.
6. Students are advised to preview submissions (answer scripts) to ensure legibility and that
the correct answer script file has been uploaded.
7. Students are permitted to resubmit their answer scripts should their initial submission be
unsatisfactory.
8. Incorrect file format and uncollated answer scripts will not be considered.
9. Incorrect answer scripts and/or submissions made on unofficial examinations platforms
(including the invigilator cellphone application) will not be marked and no opportunity will
be granted for resubmission.
10. Mark awarded for incomplete submission will be the student’s final mark. No opportunity
for resubmission will be granted.
11. Mark awarded for illegible scanned submission will be the student’s final mark. No
opportunity for resubmission will be granted.
12. Submissions will only be accepted from registered student accounts.
13. Students who have not utilised the IRIS invigilation tools will be subjected to disciplinary
processes.
14. Students suspected of dishonest conduct during the examinations will be subjected to
disciplinary processes. UNISA has a zero tolerance for plagiarism and/or any other forms
of academic dishonesty.
15. Students are provided 30 minutes to submit their answer scripts after the official
examination time. Submissions made after the official examination time will be rejected by
the examination regulations and will not be marked.
16. Students experiencing network or load shedding challenges are advised to apply together
with supporting evidence for an Aegrotat within 3 days of the examination session.
Students experiencing technical challenges, contact the SCSC 080 000 1870 or email
or refer to Get-Help for the list of additional contact numbers.
[Turn over]
, 2 INF3707
OCT/NOV
Question 1 20 marks
Choose the most applicable answers and write in your on your answer sheet. For example, 1.1 A,B, C,D
1.1 Which four(4) statements are true regarding views? (4 marks)
A. Data can’t be added to a view column containing an expression
B. Only simple views can use indexes existing on the underlying tables
C. Both simple and complex views can use indexes existing on the underlying tables
D. Complex views can be created only on multiple tables that exists in the same schema
E. Complex views can be created on multiple tables that exist in the same or different schemas
F. Row on a view cannot be deleted through a view if the view definition contains the DISTINCT keyword
G. If a view is dropped with the DROP VIEW command, the data in the original table will get affected.
H. DML operations are permitted on non-key-preserved tables
1.2 Examine the data in the Orderitems tables (2 marks)
ORDER# ITEM# QUANTITY
---------- ---------- ----------------
1007 2 1
1007 3 1
1007 4 1
1008 1 2
1009 1 1
Evaluate the following query:
select item#, avg(quantity) from orderitems having avg(quantity) >
min(quantity)*0.5 group by item#;
Which statement is true regarding the outcome of the above query?
A. It gives an error because the having clause should be specified after the GROUP BY clause
B. It gives an error because all the aggregate functions used in the HAVING clause must be specified in the
SELECT list.
C. It displays the item numbers with their average quantity where the average quantity is more than 0.5 the
minimum quantity of that item in the table
D. It displays the item numbers with their average quantity where the average quantity is more than 0.5 the
overall quantity of the items in the table.
1.3 Which three (3) SQL statements would display the value 2190.55 as $1, 890.55? (3 marks)
A. Select to_char(2190.55,’$0G000D00’ from dual;
B. Select to_char(2190.55, ‘$9,999V99’) from dual;
C. Select to_char(2190.55, ‘$99,999D99’) from dual;
D. Select to_char(2190.55, ‘$99G999V99’) from dual;
E. Select to_char(2190.55, ‘$9,999V99’) from dual;
1.4 If a column has high selectivity or cardinality, which index type is most appropriate for that column?
(2 marks)
A. IOT
B. B-tree
C. Bitmap
D. Function based index
[Turn over]
OCT/NOV 2022
INF3707
DATABASE DESIGN AND IMPLEMENTATION
Duration: 2 hours
Total marks: 100
Examiners:
First: Dr B. Chipangura
Second: Dr L. Motsi
External: Dr G. Toko
This is a closed book examination, under IRIS invigilation. Unisa exam policy applies.
Instructions to students
1. Answer all questions in the given order.
2. You are not allowed to use Mobile devices, Calculators or Oracle XE during this exam.
3. Study the tables in Annexure A.
4. Students must upload their answer scripts in a single PDF file (answer scripts must not be
password protected or uploaded as “read only” files.)
5. NO emailed scripts will be accepted.
6. Students are advised to preview submissions (answer scripts) to ensure legibility and that
the correct answer script file has been uploaded.
7. Students are permitted to resubmit their answer scripts should their initial submission be
unsatisfactory.
8. Incorrect file format and uncollated answer scripts will not be considered.
9. Incorrect answer scripts and/or submissions made on unofficial examinations platforms
(including the invigilator cellphone application) will not be marked and no opportunity will
be granted for resubmission.
10. Mark awarded for incomplete submission will be the student’s final mark. No opportunity
for resubmission will be granted.
11. Mark awarded for illegible scanned submission will be the student’s final mark. No
opportunity for resubmission will be granted.
12. Submissions will only be accepted from registered student accounts.
13. Students who have not utilised the IRIS invigilation tools will be subjected to disciplinary
processes.
14. Students suspected of dishonest conduct during the examinations will be subjected to
disciplinary processes. UNISA has a zero tolerance for plagiarism and/or any other forms
of academic dishonesty.
15. Students are provided 30 minutes to submit their answer scripts after the official
examination time. Submissions made after the official examination time will be rejected by
the examination regulations and will not be marked.
16. Students experiencing network or load shedding challenges are advised to apply together
with supporting evidence for an Aegrotat within 3 days of the examination session.
Students experiencing technical challenges, contact the SCSC 080 000 1870 or email
or refer to Get-Help for the list of additional contact numbers.
[Turn over]
, 2 INF3707
OCT/NOV
Question 1 20 marks
Choose the most applicable answers and write in your on your answer sheet. For example, 1.1 A,B, C,D
1.1 Which four(4) statements are true regarding views? (4 marks)
A. Data can’t be added to a view column containing an expression
B. Only simple views can use indexes existing on the underlying tables
C. Both simple and complex views can use indexes existing on the underlying tables
D. Complex views can be created only on multiple tables that exists in the same schema
E. Complex views can be created on multiple tables that exist in the same or different schemas
F. Row on a view cannot be deleted through a view if the view definition contains the DISTINCT keyword
G. If a view is dropped with the DROP VIEW command, the data in the original table will get affected.
H. DML operations are permitted on non-key-preserved tables
1.2 Examine the data in the Orderitems tables (2 marks)
ORDER# ITEM# QUANTITY
---------- ---------- ----------------
1007 2 1
1007 3 1
1007 4 1
1008 1 2
1009 1 1
Evaluate the following query:
select item#, avg(quantity) from orderitems having avg(quantity) >
min(quantity)*0.5 group by item#;
Which statement is true regarding the outcome of the above query?
A. It gives an error because the having clause should be specified after the GROUP BY clause
B. It gives an error because all the aggregate functions used in the HAVING clause must be specified in the
SELECT list.
C. It displays the item numbers with their average quantity where the average quantity is more than 0.5 the
minimum quantity of that item in the table
D. It displays the item numbers with their average quantity where the average quantity is more than 0.5 the
overall quantity of the items in the table.
1.3 Which three (3) SQL statements would display the value 2190.55 as $1, 890.55? (3 marks)
A. Select to_char(2190.55,’$0G000D00’ from dual;
B. Select to_char(2190.55, ‘$9,999V99’) from dual;
C. Select to_char(2190.55, ‘$99,999D99’) from dual;
D. Select to_char(2190.55, ‘$99G999V99’) from dual;
E. Select to_char(2190.55, ‘$9,999V99’) from dual;
1.4 If a column has high selectivity or cardinality, which index type is most appropriate for that column?
(2 marks)
A. IOT
B. B-tree
C. Bitmap
D. Function based index
[Turn over]
