Database Tutorial

Quiz Disclaimer

The quizzes are linked to the material covered during the lesson or prior lessons. 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 #7

This is a typical quiz because it contains 10 questions worth 3 points each. Four questions deal with normalization, two with subqueries, two with joins, one with definitions, and one with import normalization issues. You should be prepared to explain concepts like but not necessarily limited to these:

• Know vocabulary on various elements of DDL, DML, TCL, and DCL.
• Know how to explain various joins, like the CROSS, INNER, NATURAL, LEFT OUTER, RIGHT OUTER, and FULL OUTER joins, including self-joins.
• Know how the syntax and differences between ANSI SQL:89 and ANSI SQL:92 in any of the aforementioned joins.
• Know how the syntax and characteristics of how subqueries work.
• Know the normalization issues relative to importing *.csv files where some of the row fields repeats while others are unique, as discussed in the Import Transaction Units page.