Final%20Exam%20of%20CS031 - PowerPoint PPT Presentation

About This Presentation
Title:

Final%20Exam%20of%20CS031

Description:

Concept questions: total 60% Chapters 8, 9, 10, 11, 12 in the textbook ... Use http://www.uwo.ca/gifs/uwologo4.gif as the source URL, and link it to http://www.uwo.ca ... – PowerPoint PPT presentation

Number of Views:22
Avg rating:3.0/5.0
Slides: 8
Provided by: csd50
Category:
Tags: 20cs031 | 20exam | 20of | final | gifs

less

Transcript and Presenter's Notes

Title: 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.
Write a Comment
User Comments (0)
About PowerShow.com