COMP9315 21T1 Final Exam The University of New South Wales
COMP9315 DBMS Implementation
21T1 Final Exam
DBMS Implementation
[Instructions] [PostgreSQL] [C]
[Q1] [Q2] [Q3] [Q4] [Q5] [Q6] [Q7] [Q8]

The University of New South Wales

COMP9315 DBMS Implementation
21T1 Final Exam

2pm Mon 3 May, 2021

  1. Time Required: ~3 hours
  2. Reading Time: as long as you like
  3. Total number of questions: 8
  4. Total marks available: 100
  5. Questions are not of equal value.
  6. Marks are shown on each question.

Read all of the instructions below before commencing.
You will need to scroll until End of Notes to see everything

This exam will be open from 2pm Mon 3 May until 8pm Mon 3 May.
You can do the exam any time during that period,
but you should definitely start before 5pm Mon 3 May.

About this Exam web-site:
  • the Instructions and the Questions use one browser tab
  • Notes, Postgresql and C language each have their own tab
  • the tab will be created the first time you access them
  • use the tabs to navigate to these once they're open
General Instructions:
  • Answer all questions.
  • Questions are not worth equal marks.
  • Questions may be answered in any order.
  • Calculator apps (e.g. bc, xcalc) are available on your workstation.
  • During the Exam, you must not communicate with other students
  • Answers to all questions are submitted online
    • for Q1, type your answer into the file pages.c (in the q1 directory)
    • for Q2, type your answer into the file bufpool.c (in the q2 directory)
    • for Q3, type your answer into the file bits.c (in the q3 directory)
    • for Q4..Q8, type your answer into the file with .txt suffix (e.g. q2.txt)
    • submit your answers using the give command
      • either use the Exam Qx pages in Webcms3
      • or copy the files to CSE and use give on the command line
  • Any answers submitted after 8:00pm will be ignored

If you believe that insufficient information has been provided to answer
a given question, then you should write any assumptions that you think are
necessary to complete the question and continue work from there. If the
assumptions are reasonable, you can still obtain full marks for the question.

Note that marks are awarded for primarily for working, not just for getting
the correct final answer. If you get an incorrect final answer in one part of
a question and use it in a later part of that question, it is still possible
to achieve full marks for the later part if all working is correct.

For the programming questions, you can only receive full marks for a
correctly-working program that compiles with no warnings. In all other
cases, you receive partial-marks based on how close the program
is to being correct. Submitting an unchanged pages.c or bufpool.cis worth zero marks.

End of Notes