Exam #5 : Review Notes
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 #5
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 to read, interpret, and apply Venn diagrams to joins.
- Know how to read, interpret, and apply Venn diagrams to set operations through the
INTERSECTION
,UNION
,UNION ALL
, andMINUS
set operators. - Know how to read, interpret, and apply
INNER JOIN
,LEFT OUTER JOIN
,RIGHT OUTER JOIN
, andFULL OUTER JOIN
joins to data and based on scripts defining tables. - Know how to read, interpret, and apply the concept of a self-join with the
INNER JOIN
,LEFT OUTER JOIN
,RIGHT OUTER JOIN
, andFULL OUTER JOIN
joins. - Know how to read, interpret, and apply the concepts of an anti-join to resolve problems.
- Know how to describe and explain the differences of equijoin and non-equijoin operations.
- Know how Cartesian products are produces and how you can use them to solve problems.
- Know what an anti-join is, and how to describe it, as well as resolve it.
- Know the syntactical differences between ANSI SQL:89 and ANSI SQL:92 syntax surrounding join operations.