Database Tutorial

Course Tutorial Site

Site Admin

Exam #4 : Review Notes

without comments

Quiz Disclaimer

The quizzes are linked to the material covered during the lesson. They typically have 10 questions that are valued at 3 points each, and occasionally extra credit questions. Extra credit questions are most frequently vocabulary from the reading and not announced in the review notes. Extra credit points are added to the points earned on the subject matter up to but not exceeding the total points available on the quiz.

Quiz #4

This is a typical quiz and contains 10 questions. Two questions measure your ability to apply topics in the current or previous lessons. All questions are worth 3 points each and answered by short essay. You should be prepared to explain concepts like but not necessarily limited to these:

  • Know how various patterns of an INSERT statement work and why.
  • Know how automatic numbering works in the context of Oracle and MySQL databases.
  • Know how constraints impact and/or limit how INSERT statements work.
  • Know how transactions work and why.
  • Know how the who-audit columns work in the sample Video Store application.
  • Know how cardinality applies to column data types for INSERT statements.
  • Know how to work with mandatory and optional columns in INSERT statements.

Written by michaelmclaughlin

January 26th, 2010 at 3:07 am

Posted in

Leave a Reply