Fall 2026 — Exam2 guide

Tentative plan as of 23-Aug-2026

---

Where and When

• Test date: 28-October-2026
• Test time: 10am-10:50am (class time)
• Test location: Rice 130
• The exam is a paper-based exam. It will be administered in a classroom, in-person.

Conflicts

• All conflicts should have been reported and an alternative exam date must be arranged in advanced.

Make-up exam

Please refer to the Make-up exam section on the course Policies page.

SDAC accommodation

If you need accommodation, please submit proper documents to SDAC. We unfortunately cannot provide accommodation in class or during office hours. Please schedule to take the exam at SDAC.

Please visit https://www.studenthealth.virginia.edu/SDAC or use the direct link https://yukon.accessiblelearning.com/virginia/Default.aspx to schedule your exam.

What to bring

• Pens, pencils, erasers, writing utensils
• One cheat sheet (see detail in test specific) -- this is optional
• No calculators, scratch paper, backpacks, books, laptops, or anything else should be brought. These items will be left in the back/front of the room if you bring them.

Test specific

• Exam2 is closed book / notes / laptops / web / electronic devices / neighbors; paper-based, administered in class, no collaboration. No online version. No take-home version.
• The only exception is a single sheet of 8 1/2 x 11 paper with handwritten by the person taking the exam (may write on both sides of the sheet).
  • A cheat sheet must be in your handwriting.
  • Only handwriting on a single sheet of paper is allowed.
  • **NO** writing on electronic device(s) and print.
  • We must take away any sheet that violates this rule and/or assign a zero grade on the exam.
• Refer to the Coverage section below for the exam coverage.
• Only what has been introduced or discussed in Fall 2026 CS 4750 will be covered. We will not ask you for anything that has not been covered in this course this semester.
• The format of the exam will be similar to POTDs, activities, and homework assignments.
• You may expect different kinds of questions:
  • Short answer
  • Multiple choices (less likely but possible)
  • Matching (less likely but possible)
  • True/false (less likely but possible)
  • Problem-solving
  • Discussion
  • Design and diagram drawing
  • (SQL) Code reading, writing, and fixing
  • Database-related questions that relate to your project
• Very minor syntax errors are acceptable. Major syntax errors result in point deductions.

Major things you can expect

• Some questions related to the material discussed in class
• Some questions related to POTDs, activities, examples, homework assignments
• Some questions related to project

Coverage

• SQL (meetings 12-14, 16-20), excluding Assertion
  • Basics
  • Aggregates
  • Joins
  • Subqueries
  • Subqueries in WHERE and quantifiers
  • Constraints and triggers — focus on general concepts, no coding
  • Stored procedures — focus on general concepts, no coding
• General concepts of database interfacing (meetings 21-24)
  • You are expected to understand the general concepts, how database programming works, and how software application interacts with a database to provide services.
  • No specific coding. No programming language is required. We will not ask you to write a software.
• Database security, SQL injection and prevention methods (meeting 25)

Study guide

• Review the lectures / materials / slides / online resources
• Redo POTDs, activities, examples
• Review or redo homework assignments
• Practice writing SQL
  • You are expected to remember the fundamental and syntax covered in class and be able to write SQL with correct syntax.
  • A few very minor syntax errors is OK. But if you are really off we will take off points.
• Get a good night's sleep

A past exam will be available in Canvas/Files.

Note: the emphasis of some content/materials may be different between semesters. The past exam does NOT represent the Fall 2026 exam. The past exam is NOT a practice exam. It is provided for additional problem-solving practice only. Our exam will be based on what is introduced/discussed/emphasized in Fall 2026. The Fall 2026 exam will most likely be different from the past exam. Thus, please do NOT assume that our version of the exam will be the same as the past exam. 

Good luck !

---