See the Exam 2 Logistics for how the exam will be conducted.

Exam Format

The exam will be conducted on Canvas. It will consist of a mix of multiple choice, multiple answer, drop down, fill-in-the-blank, short answer, and code snippet questions.

You must independently answer the exam questions without help from other individuals, but the exam is open-book open-note. You may reference any necessary websites, such as API documentation, past lecture and homework code, and so on. You may also run code in Eclipse.

You will have between 12:45pm to 2:30pm PT on Tuesday 4/28 to complete the exam. The exam will only be accessible during this time unless you have made other arrangements.

See the Exam 2 Logistics page for additional details.

Exam Retake

There will be a retake opportunity. Details are pending.

Exam Topics

The exam will cover all topics since Week 9. This includes the slides, code demos, quizzes, discussions, and homework assigned since then. Below is a summary. See also the Modules section for a full list.

Module	Pages and Code	Practice Quizzes, etc.	Homework
Week 09	Regular Expressions	Regex Basics
Week 10	Multithreading Basics, Synchronization	Thread Basics, Thread Demos Discussion, Multithreading Synchronization
Week 11	Multithreading Concepts, Work Queues	Multithreading Work Queue, Indexed Set Discussion	ReadWriteLock
Week 12	Web Basics, Sockets, Servlets	Web: Basics, Web: HTTP, Web: Dynamic Pages	PrimeFinder
Week 13	Servlets, Sessions	Servlet Contexts, Message Board Discussion	LinkParser
Week 14	Relational Databases, SQL Guides	SQL: Joins, SQL: Grouping, SQL Discussion	HtmlCleaner

Example Topics

The following are some example topics that you may want to make sure you understand. This is a non-comprehensive list. Some of these topics may not appear on the exam and some topics not covered here may appear on the exam.

You should understand the pros and cons to multithreading, and when to use multithreading.
You should understand the different states of a thread, and how methods such as start(), join(), wait(), and notifyAll() affect a thread’s state.
You should understand how to use the synchronized keyword, and how the object used for the lock affects the number of threads that may enter a code block.
You should understand how to use a custom read/write lock instead of the synchronized keyword to protect access to shared data.
You should understand how to use a thread pool and work queue, and how they work.
You should understand how to create and use worker threads (using the Runnable interface or Thread class) versus how to create and use work (or tasks, Runnable objects) to be used with a work queue.
You should understand how to use the Pattern and Matcher classes in Java to handle regular expressions, and the difference between the find() versus matches() methods.
You should understand how to create character classes, such as [a-z] and [^0-9], in regular expressions.
You should understand how to use predefined character classes such as \w, \W, \s, \S, and . in regular expressions.
You should understand how to use the ?, *, and + quantifiers in regular expressions.
You should understand the difference between a greedy versus reluctant quantifier in regular expressions.
You should understand how to create and use capturing groups and non-capturing groups in regular expressions.
You should understand how to use the i, m, and s flags.
You should understand how to use the ^, $, \A, \z, and \b boundary matchers.
You should understand the different ways to use the ? character in a regular expression. For example: (?i) to turn on the i flag, (?:i) to create a non-capturing group that matches the i character, [?!] to create a character class that matches the ? and ! characters, i? to match the i character 0 or 1 times (greedy), and i+? to match the i character 1 or more times (reluctant).
You should understand basics about the Internet versus the Web, and the different components of a URL.
You should understand how to create and use basic sockets to connect to a server.
You should understand how to create basic HTTP requests.
You should understand and be able to create basic HTML.
You should understand the difference between static and dynamic web pages.
You should understand the basic client-server architecture used by Jetty and servlets.
You should understand how to create dynamic web pages using Jetty and servlets.
You should understand how to create, use, and modify cookies using Jetty.
You should understand the benefits of relational databases.
You should understand how to create and use statements in the Data Definition Language (DDL) of SQL. This includes the CREATE, ALTER, and DROP statements.
You should understand how to create and use different types of columns in SQL. This includes the INTEGER, TINYINT, SMALLINT, BIGINT, NUMERIC, FLOAT, DOUBLE, CHAR, VARCHAR, ENUM, DATE, DATETIME, and TIMESTAMP types.
You should understand how to use the PRIMARY KEY, FOREIGN KEY, UNIQUE, DEFAULT, NOT NULL, and AUTO_INCREMENT keywords when creating columns and tables in SQL.
You should understand how to create and use statements in the Data Manipulation Language (DML) of SQL. This includes the SELECT, INSERT, UPDATE, and DELETE statements.
You should understand how to use different types of JOIN clauses to combine results from multiple related tables in SQL. This includes INNER JOIN, NATURAL JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, NATURAL LEFT OUTER JOIN, and NATURAL RIGHT OUTER JOIN.
You should understand how to sort results using the ORDER BY clause in a SELECT statement.
You should understand how to filter results using the WHERE clause in a SELECT statement.
You should understand how to combine columns using the CONCAT() function and give columns aliases using the AS clause in a SELECT statement.
You should understand how to combine rows using the GROUP BY clause (and aggregate functions) in SELECT statement.
You should understand how to use aggregate functions like GROUP_CONCAT(), COUNT(), AVG(), and SUM() in a SELECT statement.