## Times and Locations

### 1st Phase

• Date: 22/01/2021
• Time: 11:30 - 13:00
• Rooms: B207, B104

### 2nd Phase / Improvement

• Date: 05/02/2021
• Time: 08:30 - 10:00
• Room: B207 (ESIN), B104 (SIBD)

## Necessary materials

If it is not listed below, it should not be on your table. Any consultation materials (including the slides) deemed necessary for the exam will be made available in Moodle.

• Writing material.
• Blank paper sheets, just in case we run out of draft paper sheets that we will supply during the exam. Sign and return all draft paper sheets to the professor in your exam room before leaving. All questions will be answered in Moodle, so you can use the paper sheet simply as a draft. Anything written on the paper sheets will not be considered for evaluation.
• Student card, which you will place on the corner of your table for easy checking; otherwise we will bother you during the exam unnecessarily.

Smartwatches and mobile phones must stay in your bags.

## Format

The exam will be made available in Moodle. Please make sure to test your access to the platform. Contact the FEUP Helpdesk to sort out any issues beforehand.

NOTE: wrong answers on multiple choice questions will produce negative scores, so if you are not sure, do not answer.

• UML Class Diagram: multiple choice and open-answer questions.
• SQL:
• An SQL script will be provided in Moodle, that you must download and use to initialize your database. Please review how to initialize a database in SQLite3 beforehand, so you do not waste time during the exam.
• For every exercise, you must provide the SQL query that returns the expected results. To avoid losing work and time, you can follow this workflow, like we did in class:
1. Use a proper code text editor available at the FEUP computers, such as Notepad++, Atom or VS Code.
2. Use UTF-8 encoding (same as the one used in the script).
3. Make a separate text file for each of your solutions and edit the code there.
4. Test your queries using the SQLite command line (use the .read command to run each of your files instead of typing on the command line).
5. When you are happy with your solution, please copy and paste the solution into the answer text box in Moodle.
6. Do not include any SQLite initialization code, such as .headers on or .mode columns. The answer should be the query itself only.
• When a question does not ask you to order the results, your answer will be correct as long as it returns the expected tuples, regardless of their order.
• Even when your answer produces the same tuples as the ones presented as the example result for the question, it may not be considered correct. In the correction we will test your queries against a database with the same structure as the supplied script but with different records, designed to test more edge cases (like we have seen in class). To be considered correct, your query should still produce the correct answers when ran against the correction database.
• HTML, CSS, PHP, Git and Docker: multiple choice and open-answer questions.
• PHP: code question.

## Rules of conduct in times of COVID-19

• The use of a mask is mandatory for all participants (students, teachers, etc).
• Before the test starts, students should keep a distance of more than 1m from each other, either during the waiting time in the corridor or during the entrance and exit.
• Groups of persons are not allowed in the corridors, as well as outside spaces of FEUP, before and after the exams.
• In the 10 minutes before the starting time, students must go to the respective classrooms, entering and sitting immediately:
• Should sit at the available tables further away from the entrance door(s) to the room, in the order of entry; Students should be distributed evenly in the classroom with places of interval as in the classes.
• At the entrance of the PC rooms, each student must be provided with a disinfectant wipe, with which they must disinfect the equipment they will use (keyboard, mouse…); the used wipe must be deposited in the dustbin when leaving the room, at the end of the test.
• During the exam:
• There will be no possibility of questioning the professors present to avoid proximity between professors and students.
• Delivery of extra sheets of paper should be avoided during the test.
• Students must remain seated until the end of the exam, even if they finish before;
• At the order of the professor, students may leave the classroom starting from those who are closest to the doors;

## Previous exams

Some examples of previous years are available here. Given that some topics covered have changed this year, the structure may also be different. Use the format above as reference.

## Important notes for Erasmus students (remote exams)

• In exceptional cases justified by the school calendar, Erasmus students may carry out the exam remotely at their home University.

• All Erasmus students that cannot be present during the exam must contact the course professors to arrange a remote exam.

• These students must secure the contact of a responsible person at their home University beforehand and supply that contact to the course professors. We will then coordinate with this person to arrange a controlled environment at the student’s home institution where they can perform the exam. This person will assume responsibility for making sure that exam rules are followed.

• The responsible person needs to communicate to the professors the range of external IPs from which the student will perform the exam, otherwise the student will not be able to perform the exam.

## Play fair

Any illegal behaviour during the exam (plagiarism by any means or exchange of information between students) is punishable with a full annulment of the exam, resulting in a grade of zero.

All network accesses and interactions with the computers during the exam are monitored. Unlawful behaviour will be easy to detect and any implicated individuals will be dealt with accordingly.

Any attempt to perform the exam on computers other than the ones in the computer rooms is easily detectable and will result in immediate anullment of the exam, unless you are an Erasmus student and have contacted us beforehand to arrange a remote exam.