Final%20Exam%20of%20CS031

1
Final Exam of CS031

• 7 9 pm, Thursday, Dec 11, 2003
• Location TH GYM (both sections)
• Close book/notes. No cheat sheet or any
  electronic device

2
Coverage

• Concept questions total 60
• Chapters 8, 9, 10, 11, 12 in the textbook
• Corresponding lecture notes
• Multiple choice questions
• (No quiz, no PeopleSoft)
• HTML 20
• Written questions
• SQL 20
• Written questions

3
Sample questions on HTML

• Write HTML for a Web page with
• My First Web Page as the title
• Your name as a level 2 heading
• An enumerated list of your three favorite
  University courses
• An image for the University. Use
  http//www.uwo.ca/gifs/uwologo4.gif as the source
  URL, and link it to http//www.uwo.ca

4
Sample questions on HTML
Level 1 heading
Picture file is at
Link to http//
5
SQL Sample Questions

• Download Access file Western2000.mdb from
  www.csd.uwo.ca/faculty/cling/cs031
• Tables in a database will be given. For each
  question, write down SQL, and give result of
  executing the SQL statement.
• Practice with Access on Western2000.mdb. You can
  switch between Design View, SQL View, and
  Datasheet View (result)

6
SQL Sample Questions

• Find student last name who lives in London,
  ordered by the ascending order.
• Find student last name and first name who lives
  in London, and whose postal code starts with N or
  M.

7
SQL Sample Questions

• Find student last name and first name who takes a
  course in the B term.
• Find average mark of course taken by Clark.
• Find student last name who takes a course taught
  by Professor Mercer.