INF3707 Exam Pack (solutions)

INF3707
Comprehensive Exam Pack
(Solutions)
Included in this Exam Pack
INF3707 Past Exam Papers Solutions ..................................................................................................................... 2
2018 OctNov exam solution ......................................................................................................................................... 2
2018 MayJune exam solution ...................................................................................................................................... 7
2017 OctNov exam solution ....................................................................................................................................... 11
2017 MayJune exam solution .................................................................................................................................... 16
INF3707 Past Assignments Solutions ................................................................................................................... 20
2019 Semester 1 ......................................................................................................................................................... 20
2018 Semester 2 ......................................................................................................................................................... 25
2018 Semester 1 ......................................................................................................................................................... 28
2017 Semester 2 ......................................................................................................................................................... 34
2017 Semester 1 ......................................................................................................................................................... 37



Includes verified solutions with screenshots from Oracle 11g XE. Most questions
from past exam papers/assignments come from the End of Chapter questions. If you
work through the questions and are able to successfully complete these on Oracle
11g XE by yourself, you will get a good mark in the exam!


My marks from 2019-Semester 1:

, INF3707 Past Exam Papers Solutions
2018 OctNov exam solution


SECTION A: Multiple Choice Questions [30]

1. D 6. B 11. B
2. A 7. D 12. B
3. B 8. D 13. B
4. C 9. A 14. D
5. D 10. A 15. B


Question 2 [30]

2.1 SELECT isbn, title
FROM books
WHERE title LIKE '_A_N%'
ORDER BY title DESC;




2.2 SELECT AVG(retail)retail, name, category
FROM books
JOIN publisher USING(pubid)
WHERE category IN ('CHILDREN', 'COMPUTER')
GROUP BY name, category
HAVING AVG(retail) > 50;




2.3 SELECT title, retail
FROM books
WHERE retail > (SELECT AVG(retail)
FROM books);