JOIN Quiz 2

From SQLZOO
Revision as of 12:57, 18 July 2012 by Marek (Talk | contribs) (Created page with "JOIN Quiz - part 2 <div class='db_ref' style='background:none'> <table class='zoo'> <caption>teacher</caption> <tr> <th>id</th> <th>dept</th> <th>name</th> <th>phone</th> <t...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

JOIN Quiz - part 2

teacher
id dept name phone mobile
101 1 Shrivell 2753 07986 555 1234
102 1 Throd 2754 07122 555 1920
103 1 Splint 2293
104 Spiregrain 3287
105 2 Cutflower 3212 07996 555 6574
106 Deadyawn 3345
dept
id name
1 Computing
2 Design
3 Engineering

<quiz shuffle=none display=simple> {Which of the following uses of JOIN is correct? |type="()"} - SELECT teacher.name, dept.name FROM teacher JOIN dept ON (dept = id) - SELECT teacher.name, dept.name FROM teacher, dept INNER JOIN ON (teacher.dept = dept.id) - SELECT teacher.name, dept.name FROM teacher, dept JOIN WHERE(teacher.dept = dept.id) - SELECT teacher.name, dept.name FROM teacher OUTER JOIN dept ON dept.id + SELECT teacher.name, dept.name FROM teacher LEFT OUTER JOIN dept ON (teacher.dept > dept.id)

</quiz>