The midterm exam will be held in class on Monday, November 6th. It will cover the materials from lectures and sections before that day.
The final exam will be held on Thursday, December 14th from 2:30pm-4:20pm in the classroom. The exam will be comprehensive.
SQL Practice: sql-practice-problems.txt and sql-practice-problems-answers.txt
Below are a few sample exams from previous offerings of 414 and 344 (version of the course for majors). Beware that the topics covered might be different, so some questions might not be applicable for this term. Please come to the lectures for instructions on what to study for the midterm and for the final.
Some solutions have mistakes. Be sure to check the list of errata here if you think you have encountered a mistake.