Study Guide Sections
Exam 2 Overview
Exam Details
Date: November 6th
Time: TBD
Duration: 65 Minutes
Location: Computer Lab
Points: 100 points
Materials: One page (single-sided) cheat sheet
Exam Format - 100% SQL Focus
Section 1: Multiple Choice (50 points) - 20 questions @ 2.5 pts each
Section 2: SQL Coding (50 points) - 10 queries (3-7 pts each)
Recommended Time: 30 min for MCQ, 45 min for coding
Database: movies.db (same as Homework 4)
Content Distribution
Based on Homework 3 (25%): SELECT, WHERE, ORDER BY, LIKE, BETWEEN, IS NULL
Based on Homework 4 (40%): Aggregates (COUNT, SUM, AVG, MAX, MIN, ROUND), GROUP BY, HAVING
INSERT/DELETE Lecture (20%): INSERT single/multiple rows, DELETE with WHERE
Schema Design (15%): CREATE TABLE, PRIMARY KEY, FOREIGN KEY, constraints
Critical Topics to Master
WHERE vs HAVING - Most commonly confused concept
IS NULL vs = NULL - Common syntax trap
GROUP BY with HAVING - Most challenging questions
ROUND precision - Easy points if careful
DELETE safety - Always use WHERE clause!