Using Null Quiz - Revision history

Marek at 12:43, 15 August 2012

2012-08-15T12:43:20Z

Connor at 14:42, 7 August 2012

2012-08-07T14:42:00Z

Connor at 14:41, 7 August 2012

2012-08-07T14:41:28Z

Connor at 13:22, 7 August 2012

2012-08-07T13:22:11Z

Connor at 11:02, 23 July 2012

2012-07-23T11:02:34Z

Connor at 10:49, 23 July 2012

2012-07-23T10:49:08Z

Marek at 09:50, 20 July 2012

2012-07-20T09:50:49Z

Marek at 09:49, 20 July 2012

2012-07-20T09:49:20Z

Marek at 09:48, 20 July 2012

2012-07-20T09:48:42Z

Marcin at 00:30, 20 July 2012

2012-07-20T00:30:29Z

@@ Line 126: / Line 126: @@
 <table style='float:left'><caption>Table-B</caption><tr><td>Shrivell</td><td>Computing</td></tr><tr><td>Throd</td><td>Computing</td></tr><tr><td>Splint</td><td>Computing</td></tr><tr><td>Spiregrain</td><td>Computing</td></tr><tr><td>Cutflower</td><td>Computing</td></tr><tr><td>Deadyawn</td><td>Computing</td></tr></table>
 <table style='float:left'><caption>Table-C</caption><tr><td>Shrivell</td><td>Computing</td></tr><tr><td>Throd</td><td>Computing</td></tr><tr><td>Splint</td><td>Computing</td></tr></table>
 |type="()"}
 + Table-A
 - Table-B
 - Table-C
 </quiz>
 [[Category:Quizzes]]

@@ Line 124: / Line 124: @@
 {Select the result that would be obtained from the following code: SELECT name, CASE WHEN dept IN (1) THEN 'Computing' ELSE 'Other' END FROM teacher
 <table style='float:left'><caption>Table-A</caption><tr><td>Shrivell</td><td>Computing</td></tr><tr><td>Throd</td><td>Computing</td></tr><tr><td>Splint</td><td>Computing</td></tr><tr><td>Spiregrain</td><td>Other</td></tr><tr><td>Cutflower</td><td>Other</td></tr><tr><td>Deadyawn</td><td>Other</td></tr></table>
-<table style='float:left'><caption>Table-A</caption><tr><td>Shrivell</td><td>Computing</td></tr><tr><td>Throd</td><td>Computing</td></tr><tr><td>Splint</td><td>Computing</td></tr><tr><td>Spiregrain</td><td>Computing</td></tr><tr><td>Cutflower</td><td>Computing</td></tr><tr><td>Deadyawn</td><td>Computing</td></tr></table>
+<table style='float:left'><caption>Table-B</caption><tr><td>Shrivell</td><td>Computing</td></tr><tr><td>Throd</td><td>Computing</td></tr><tr><td>Splint</td><td>Computing</td></tr><tr><td>Spiregrain</td><td>Computing</td></tr><tr><td>Cutflower</td><td>Computing</td></tr><tr><td>Deadyawn</td><td>Computing</td></tr></table>
-<table style='float:left'><caption>Table-A</caption><tr><td>Shrivell</td><td>Computing</td></tr><tr><td>Throd</td><td>Computing</td></tr><tr><td>Splint</td><td>Computing</td></tr></table>
+<table style='float:left'><caption>Table-C</caption><tr><td>Shrivell</td><td>Computing</td></tr><tr><td>Throd</td><td>Computing</td></tr><tr><td>Splint</td><td>Computing</td></tr></table>
 |type="()"}
 + Table-A

@@ Line 121: / Line 121: @@
 - 'two' for Cutflower
 - 'two' for Deadyawn
 </quiz>
 [[Category:Quizzes]]

@@ Line 84: / Line 84: @@
 {Select the code which uses a JOIN correctly.
 |type="()"}
--A. SELECT teacher.name, dept.name FROM teacher JOIN dept ON (dept = id)
+- SELECT teacher.name, dept.name FROM teacher JOIN dept ON (dept = id)
--B. SELECT teacher.name, dept.name FROM teacher, dept INNER JOIN ON (teacher.dept = dept.id)
+- SELECT teacher.name, dept.name FROM teacher, dept INNER JOIN ON (teacher.dept = dept.id)
--C. SELECT teacher.name, dept.name FROM teacher, dept JOIN WHERE(teacher.dept = dept.id)
+- SELECT teacher.name, dept.name FROM teacher, dept JOIN WHERE(teacher.dept = dept.id)
--D. SELECT teacher.name, dept.name FROM teacher OUTER JOIN dept ON dept.id
+- SELECT teacher.name, dept.name FROM teacher OUTER JOIN dept ON dept.id
-+E. SELECT teacher.name, dept.name FROM teacher LEFT OUTER JOIN dept ON (teacher.dept > dept.id)
++ SELECT teacher.name, dept.name FROM teacher LEFT OUTER JOIN dept ON (teacher.dept > dept.id)
 {Select the correct statement that shows the name of department which employs Cutflower
 |type="()"}
--A. SELECT dept.name FROM teacher JOIN dept ON (dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower'))
+- SELECT dept.name FROM teacher JOIN dept ON (dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower'))
--B. SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE dept.id = (SELECT dept FROM teacher HAVING name = 'Cutflower')
+- SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE dept.id = (SELECT dept FROM teacher HAVING name = 'Cutflower')
-+C. SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE teacher.name = 'Cutflower'
++ SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE teacher.name = 'Cutflower'
--D. SELECT dept.name FROM teacher JOIN dept WHERE dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower')
+- SELECT dept.name FROM teacher JOIN dept WHERE dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower')
--E. SELECT name FROM teacher JOIN dept ON (id = dept) WHERE id = (SELECT dept FROM teacher WHERE name = 'Cutflower')
+- SELECT name FROM teacher JOIN dept ON (id = dept) WHERE id = (SELECT dept FROM teacher WHERE name = 'Cutflower')
 {Select out of following the code which uses a JOIN to show a list of all the departments and number of employed teachers
 |type="()"}
--A. SELECT dept.name, COUNT(*) FROM teacher LEFT JOIN dept ON dept.id = teacher.dept
+- SELECT dept.name, COUNT(*) FROM teacher LEFT JOIN dept ON dept.id = teacher.dept
--B. SELECT dept.name, COUNT(teacher.name) FROM teacher, dept JOIN ON dept.id = teacher.dept GROUP BY dept.name
+- SELECT dept.name, COUNT(teacher.name) FROM teacher, dept JOIN ON dept.id = teacher.dept GROUP BY dept.name
--C. SELECT dept.name, COUNT(teacher.name) FROM teacher JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
+- SELECT dept.name, COUNT(teacher.name) FROM teacher JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
--D. SELECT dept.name, COUNT(teacher.name) FROM teacher LEFT OUTER JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
+- SELECT dept.name, COUNT(teacher.name) FROM teacher LEFT OUTER JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
-+E. SELECT dept.name, COUNT(teacher.name) FROM teacher RIGHT JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
++ SELECT dept.name, COUNT(teacher.name) FROM teacher RIGHT JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
 {Using <code>SELECT name, dept, COALESCE(dept, 0) AS result FROM teacher</code> on <code>teacher</code> table will:
 |type="()"}
--A. display 0 in result column for all teachers
+- display 0 in result column for all teachers
-+B. display 0 in result column for all teachers without department
++ display 0 in result column for all teachers without department
--C. do nothing - the statement is incorrect
+- do nothing - the statement is incorrect
--D. set dept value of all teachers to 0
+- set dept value of all teachers to 0
--E. set dept value of all teachers without department to 0
+- set dept value of all teachers without department to 0
 {Query: <code>SELECT name, CASE WHEN phone = 2752 THEN 'two' WHEN phone = 2753 THEN 'three' WHEN phone = 2754 THEN 'four' END AS digit FROM teacher</code> shows following 'digit':
 |type="()"}
-+A. 'four' for Throd
++ 'four' for Throd
--B. NULL for all teachers
+- NULL for all teachers
--C. NULL for Shrivell
+- NULL for Shrivell
--D. 'two' for Cutflower
+- 'two' for Cutflower
--E. 'two' for Deadyawn
+- 'two' for Deadyawn
 </quiz>
 [[Category:Quizzes]]

@@ Line 84: / Line 84: @@
 {Select the code which uses a JOIN correctly.
 |type="()"}
-- SELECT teacher.name, dept.name FROM teacher JOIN dept ON (dept = id)
+-A. 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)
+-B. 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)
+-C. 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
+-D. 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)
++E. SELECT teacher.name, dept.name FROM teacher LEFT OUTER JOIN dept ON (teacher.dept > dept.id)
 {Select the correct statement that shows the name of department which employs Cutflower
 |type="()"}
-- SELECT dept.name FROM teacher JOIN dept ON (dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower'))
+-A. SELECT dept.name FROM teacher JOIN dept ON (dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower'))
-- SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE dept.id = (SELECT dept FROM teacher HAVING name = 'Cutflower')
+-B. SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE dept.id = (SELECT dept FROM teacher HAVING name = 'Cutflower')
-+ SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE teacher.name = 'Cutflower'
++C. SELECT dept.name FROM teacher JOIN dept ON (dept.id = teacher.dept) WHERE teacher.name = 'Cutflower'
-- SELECT dept.name FROM teacher JOIN dept WHERE dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower')
+-D. SELECT dept.name FROM teacher JOIN dept WHERE dept.id = (SELECT dept FROM teacher WHERE name = 'Cutflower')
-- SELECT name FROM teacher JOIN dept ON (id = dept) WHERE id = (SELECT dept FROM teacher WHERE name = 'Cutflower')
+-E. SELECT name FROM teacher JOIN dept ON (id = dept) WHERE id = (SELECT dept FROM teacher WHERE name = 'Cutflower')
 {Select out of following the code which uses a JOIN to show a list of all the departments and number of employed teachers
 |type="()"}
-- SELECT dept.name, COUNT(*) FROM teacher LEFT JOIN dept ON dept.id = teacher.dept
+-A. SELECT dept.name, COUNT(*) FROM teacher LEFT JOIN dept ON dept.id = teacher.dept
-- SELECT dept.name, COUNT(teacher.name) FROM teacher, dept JOIN ON dept.id = teacher.dept GROUP BY dept.name
+-B. SELECT dept.name, COUNT(teacher.name) FROM teacher, dept JOIN ON dept.id = teacher.dept GROUP BY dept.name
-- SELECT dept.name, COUNT(teacher.name) FROM teacher JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
+-C. SELECT dept.name, COUNT(teacher.name) FROM teacher JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
-- SELECT dept.name, COUNT(teacher.name) FROM teacher LEFT OUTER JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
+-D. SELECT dept.name, COUNT(teacher.name) FROM teacher LEFT OUTER JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
-+ SELECT dept.name, COUNT(teacher.name) FROM teacher RIGHT JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
++E. SELECT dept.name, COUNT(teacher.name) FROM teacher RIGHT JOIN dept ON dept.id = teacher.dept GROUP BY dept.name
 {Using <code>SELECT name, dept, COALESCE(dept, 0) AS result FROM teacher</code> on <code>teacher</code> table will:
 |type="()"}
-- display 0 in result column for all teachers
+-A. display 0 in result column for all teachers
-+ display 0 in result column for all teachers without department
++B. display 0 in result column for all teachers without department
-- do nothing - the statement is incorrect
+-C. do nothing - the statement is incorrect
-- set dept value of all teachers to 0
+-D. set dept value of all teachers to 0
-- set dept value of all teachers without department to 0
+-E. set dept value of all teachers without department to 0
 {Query: <code>SELECT name, CASE WHEN phone = 2752 THEN 'two' WHEN phone = 2753 THEN 'three' WHEN phone = 2754 THEN 'four' END AS digit FROM teacher</code> shows following 'digit':
 |type="()"}
-+ 'four' for Throd
++A. 'four' for Throd
-- NULL for all teachers
+-B. NULL for all teachers
-- NULL for Shrivell
+-C. NULL for Shrivell
-- 'two' for Cutflower
+-D. 'two' for Cutflower
-- 'two' for Deadyawn
+-E. 'two' for Deadyawn
 </quiz>
 [[Category:Quizzes]]

@@ Line 79: / Line 79: @@
 </div>
-<div class='extra_space' style='width:1em; height:2.5em;'></div>
+<div class='extra_space' style='width:1em; height:16em;'></div>
 <quiz shuffle=none display=simple>