Midterm Exam 2 Review Sheet

General Information

The midterm will be open notes, and have a time limit of 75 minutes. Most of it will be answered on the exam paper itself, though one section will ask you to use the computer.

Along with your notes and readings, review the kinds of questions asked on the assignments. 
Contact me if you have a question about any topic or solution to assignments.

What to Expect. There is usually a section of short answer (true/false, multiple choice, and one liners), a section of short answer questions on main concepts and coding in SQL,  a section that requires evaluating expressions and  problems where you'll write SQL or come up with a sketch of the results of short SQL queries.

Likely Exam Topics

Structured Query Language.  Some leftover SQL topics may appear, revisit the first midterm review.

A blast from the past: client-server architecture & what runs where on the web

HTML.  The basic tags and structure of HTML, as well as fundamental web technologies. Understand:

• the basic idea of hypertext as opposed to HTML
  
• how it is used in the World Wide Web
• the purpose and structure of URLs
• the use of our webserver and how to access resources on it

local vs global references (in URLs, anchor tags)

basic tags like:
    h1, p, hr, i, b, anchors (a href="..."), images (img src="...")

CSS. Basic idea behind the STYLE tag, STYLE attributes embedded in other tags (all with simple examples), and enforcing site-wide styles using Cascading Style Sheets.

History.  The little bit of history covered was origins of hypertext and the first Web technologies.

You should know some Command Line...

There may not be any questions specifically about these commands, but you may need to use them.

Unix Commands:
     ls CS284
     ls ~/html/CS284
     cd
     cp
     pwd
     mkdir

Directory navigation (as a tree) using 'special' symbols:
     *
     .
     ..