Revision – Final Exam Information
NoSQL Test
The NoSQL test was available from 12:00pm, 23 October (Saturday) to 11:59pm, 28 October (Thursday).
The NoSQL results will be released on 29 October (Friday). Special Drop-in Session: 2-3 pm (Tuesday) 2 November.
Final Exam
Final Exam
COMP2400: 5:40 pm, 8 November (Monday) 2021
Final Exam
COMP2400: 5:40 pm, 8 November (Monday) 2021 COMP6240: 5:30 pm, 8 November (Monday) 2021
Final Exam
COMP2400: 5:40 pm, 8 November (Monday) 2021 COMP6240: 5:30 pm, 8 November (Monday) 2021 Writing period: 150 minutes
Final Exam
COMP2400: 5:40 pm, 8 November (Monday) 2021 COMP6240: 5:30 pm, 8 November (Monday) 2021 Writing period: 150 minutes
Venue: Online Wattle Exam
Refer to the following website for the final exam time
https://exams.anu.edu.au/timetable/
Final Exam
COMP2400: 5:40 pm, 8 November (Monday) 2021 COMP6240: 5:30 pm, 8 November (Monday) 2021 Writing period: 150 minutes
Venue: Online Wattle Exam
Refer to the following website for the final exam time
https://exams.anu.edu.au/timetable/
Application for deferred-examinations:
https://www.anu.edu.au/students/program-administration/ assessments-exams/deferred-examinations
Importance of Final Exam
Best 6 out of 10 quizzes (0.5% × 6 = 3%) and engaging 4 out of 8 labs (0.5% × 4 = 2%, at your own choice).
In total (20% + 15% = 35%).
An online test about NoSQL databases on Wattle.
The final exam will take place on 8 November 2021 .
5% Quizzes and Labs
35% Assignments
5% NoSQL test
55% Final exam
Final Exam
It is 150 miniutes (two and a half hours) long.
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course.
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course. To pass the course you must achieve:
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course. To pass the course you must achieve:
at least 40% in the final examination (i.e., 22/55),
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course. To pass the course you must achieve:
at least 40% in the final examination (i.e., 22/55),
at least 50% as a combined total of quizzes, labs, assignments, NoSQL test and final exam
Final Exam
It is 150 miniutes (two and a half hours) long.
It counts for 55% of the total marks for this course. To pass the course you must achieve:
at least 40% in the final examination (i.e., 22/55),
at least 50% as a combined total of quizzes, labs, assignments,
NoSQL test and final exam
The final marks will be moderated in the examiners’s meeting and may be scaled as a result of this moderation.
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle). Note that this process is encouraged, but not required.
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required. You will not be asked to pass your recording on to ANU.
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required. You will not be asked to pass your recording on to ANU. You should keep your recording safely for one month.
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required. You will not be asked to pass your recording on to ANU. You should keep your recording safely for one month.
If the ANU should raise any concerns about the integrity of the work you did during the exam, you will have the option to submit your screen recording as evidence to support your case.
Self Invigilation
The final exam for COMO2400/6240 will be self-invigilated.
You should create a screen recording of your entire exam (refer to Wattle).
Note that this process is encouraged, but not required. You will not be asked to pass your recording on to ANU. You should keep your recording safely for one month.
If the ANU should raise any concerns about the integrity of the work you did during the exam, you will have the option to submit your screen recording as evidence to support your case.
If you should experience any unexpected issues on Wattle, you will have the option to submit your screen recording as evidence to support your case.
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in Wattle from one machine during your final exam period. Otherwise, your final exam may be terminated by the system.
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in Wattle from one machine during your final exam period. Otherwise, your final exam may be terminated by the system.
Our IT Support recommends that you use Firefox or Google Chrome for this final exam, and do not use Safari.
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in Wattle from one machine during your final exam period. Otherwise, your final exam may be terminated by the system.
Our IT Support recommends that you use Firefox or Google Chrome for this final exam, and do not use Safari.
You only have one attempt for this final exam.
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in Wattle from one machine during your final exam period. Otherwise, your final exam may be terminated by the system.
Our IT Support recommends that you use Firefox or Google Chrome for this final exam, and do not use Safari.
You only have one attempt for this final exam.
This is an open book exam. However, you must complete this exam independently and with academic integrity.
What you need to know before the exam:
The final exam will be held via this Wattle course site. You can only log in Wattle from one machine during your final exam period. Otherwise, your final exam may be terminated by the system.
Our IT Support recommends that you use Firefox or Google Chrome for this final exam, and do not use Safari.
You only have one attempt for this final exam.
This is an open book exam. However, you must complete this exam
independently and with academic integrity.
(Optional) Find screen recording software that you trust works well on your computer (refer to Wattle). Test it, and make sure you can successfully record the whole of your screen for self invigilation.
What you need to do during the exam:
Make yourself comfortable and power down all communication channels, except the exam zoom session.
What you need to do during the exam:
Make yourself comfortable and power down all communication channels, except the exam zoom session.
(Optional) Start your full screen recording.
What you need to do during the exam:
Make yourself comfortable and power down all communication channels, except the exam zoom session.
(Optional) Start your full screen recording.
COMP2400 students must enter their answers to Wattle between 5:40 pm and 8:10 pm (150 mins) and submit their answers before 8:15 pm. The additional 5-minute window (8:10 pm – 8:15 pm) must only be used for your submission. Note that, if you don’t submit your answers within the given
time, the final exam session on Wattle will be automatically closed and your answers may not be saved and submitted.
What you need to do during the exam:
Make yourself comfortable and power down all communication channels, except the exam zoom session.
(Optional) Start your full screen recording.
COMP2400 students must enter their answers to Wattle between 5:40 pm and 8:10 pm (150 mins) and submit their answers before 8:15 pm. The additional 5-minute window (8:10 pm – 8:15 pm) must only be used for your submission. Note that, if you don’t submit your answers within the given time, the final exam session on Wattle will be automatically closed and your answers may not be saved and submitted.
COMP6240 students must enter their answers to Wattle between 5:30 pm and 8:00 pm (150 mins) and submit their answers before 8:05 pm. The additional 5-minute window (8:00 pm – 8:05 pm) must only be used for your submission. Note that, if you don’t submit your answers within the given time, the final exam session on Wattle will be automatically closed and your answers may not be saved and submitted.
What you need to do during the exam:
Make yourself comfortable and power down all communication channels, except the exam zoom session.
(Optional) Start your full screen recording.
COMP2400 students must enter their answers to Wattle between 5:40 pm and 8:10 pm (150 mins) and submit their answers before 8:15 pm. The additional 5-minute window (8:10 pm – 8:15 pm) must only be used for your submission. Note that, if you don’t submit your answers within the given time, the final exam session on Wattle will be automatically closed and your answers may not be saved and submitted.
COMP6240 students must enter their answers to Wattle between 5:30 pm and 8:00 pm (150 mins) and submit their answers before 8:05 pm. The additional 5-minute window (8:00 pm – 8:05 pm) must only be used for your submission. Note that, if you don’t submit your answers within the given time, the final exam session on Wattle will be automatically closed and your answers may not be saved and submitted.
(Optional) At the end of the exam, stop your screen recording, save it, check
it, and keep it in a safe place for one month. Do not send it to ANU. 8/26
Pre-Final Exam Support
Make effective use of the Wattle discussion forum! Drop-in Sessions (Next Week)
1 4-5 pm, Monday, Nov 1
2 7-8 pm, Wednesday, Nov 3
3 4-5 pm, Thursday, Nov 4
4 4-5 pm, Friday, Nov 5
Yu Lin: or :
Final Exam
How to prepare for the final exam for COMP2400/6240?
Final Exam
Be clear with what are included & what are not included.
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples) Lab notes (more exercises)
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions) Sample exam paper (sample questions and solutions)
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions) DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
Final Exam
Be clear with what are included & what are not included.
What are important information sources for the final exam?
Lecture slides
Workshop slides (more examples)
Lab notes (more exercises)
Assignments (sample questions and solutions)
Sample exam paper (sample questions and solutions) DatabaseBench: https://cs.anu.edu.au/dab/bench/db-exercises/
You may also use the textbook as a reference, or search on Google …
What have you learned?
1 Introduction to database systems Relational data model
Entity-relationship model
5 Functional dependencies Normalisation
7 Relational algebra
Query processing and optimisation
9 Database security 11 NoSQL Databases
Lectures/Workshops
Database transactions
What will be covered in the final exam?
1 Introduction to database systems
5 Functional dependencies Normalisation
7 Relational algebra
Query processing and optimisation
9 Database security
Armstrongs Inference Rules in Week 5 workshop slides (slides 16-25) will not be covered. Execution plan in Week 8 workshop slides (slides 8-27) will not be covered.
Lectures/Workshops
Relational data model
SQL (Writing SQL queries will not be assessed)
Entity-relationship model
Database transactions
NoSQL Databases
What will be covered in the final exam?
Lab Environment
Advanced SQL
Entity-Relationship Model
5 Functional Dependencies Normalisation
7 Relational Algebra, and Query Processing and Optimisation
Database Programming
Final Exam – Assignments and Past Exam Papers
The assignment on SQL will not be covered.
Final Exam – Assignments and Past Exam Papers
The assignment on SQL will not be covered. The assignment on database theory is covered.
Final Exam – Assignments and Past Exam Papers
The assignment on SQL will not be covered. The assignment on database theory is covered. The NoSQL test will not be covered.
Final Exam – Assignments and Past Exam Papers
The assignment on SQL will not be covered. The assignment on database theory is covered. The NoSQL test will not be covered.
The final exam paper in 2012 (the specification and solution are available in Wattle). Note the difference.
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2.
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one Assume the correct answer is (A)(C)
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks. (A) and (A)(C)(D)
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks.
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks. (A)(B) and (A)(C)(D)(E)
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks. (A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks.
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks. (A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks. (A)(B)(D) and (D)
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks. (A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks. (A)(B)(D) and (D) will receive 0 (out of 2) marks.
Question type:
Final Exam Questions
(1) Multiple Choice Questions (first 10 questions)
Select one or more choices as desired.
Partial marks are available and the minimum mark per question is 0.
The full mark for each quesion (of five choices) is 2. +0.4 for each correct one and -0.4 for each incorrect one Assume the correct answer is (A)(C)
(A)(C) will receive 2 (out of 2) marks.
(A) and (A)(C)(D) will receive 1.2 (out of 2) marks. (A)(B) and (A)(C)(D)(E) will receive 0.4 (out of 2) marks. (A)(B)(D) and (D) will receive 0 (out of 2) marks.
Question type:
Final Exam Questions
(2) Problem-Solving Questions (remaining 9 questions) Include necessary justifications if instructed.
Type your answer in the text window (or upload at mo