BBC QUIZ - Revision history

Mmd: The answer to question 3 was wrong. Numbers must not have apostrophes around them because that makes them strings. Also corrected grammar.

2012-12-10T02:09:32Z

The answer to question 3 was wrong. Numbers must not have apostrophes around them because that makes them strings. Also corrected grammar.

76.113.152.178 at 06:31, 18 October 2012

2012-10-18T06:31:11Z

76.113.152.178 at 06:28, 18 October 2012

2012-10-18T06:28:57Z

76.113.152.178 at 06:28, 18 October 2012

2012-10-18T06:28:05Z

Andr3w at 16:27, 29 August 2012

2012-08-29T16:27:54Z

Andr3w at 19:04, 22 August 2012

2012-08-22T19:04:06Z

Connor at 10:15, 7 August 2012

2012-08-07T10:15:15Z

Connor at 09:51, 7 August 2012

2012-08-07T09:51:10Z

Connor at 09:49, 6 August 2012

2012-08-06T09:49:56Z

Connor at 09:49, 6 August 2012

2012-08-06T09:49:44Z

@@ Line 94: / Line 94: @@
 - Apostrophes should be used around 'bbc' instead of speech marks
 - There are apostrophes surrounding '2000000'
-+ There are speech marks surrounding "bbc"
+- There are speech marks surrounding "bbc"
-- There are speech marks surrounding "bbc" and there is apostrophes surrounding '2000000'
++ There are speech marks surrounding "bbc" and there are apostrophes surrounding '2000000'
 - The use of a WHERE function is incorrect

@@ Line 74: / Line 74: @@
 <quiz shuffle=none display=simple>
-{Select the code which gives the name of countries beginning with C
+{Select the code which gives the name of countries beginning with U
 |type="()"}
 - SELECT name FROM bbc WHERE name BEGIN with C
 - SELECT name FROM bbc WHERE name LIKE '%C'
 - SELECT name FROM bbc WHERE name LIKE '%C%'
-- SELECT name FROM bbc WHERE name LIKE C
+- SELECT name FROM bbc WHERE name LIKE U
-+ SELECT name FROM bbc WHERE name LIKE 'C%'
++ SELECT name FROM bbc WHERE name LIKE 'U%'
 {Select the code which shows just the population of United Kingdom?

@@ Line 63: / Line 63: @@
 <td>Uzbekistan</td>
 <td>Central Asia</td>
-<td align='right'>652225</td>
+<td align='right'>447000</td>
 <td align='right'>26000000</td>
 <td></td>

@@ Line 57: / Line 57: @@
 <td align='right'>21</td>
 <td align='right'>9900</td>
 <td></td>
 </tr>

@@ Line 119: / Line 119: @@
 - SELECT name FROM WHERE name IS 'Scotland'
-{Select the result that would be obtained from this code: SELECT name FROM bbc WHERE region = 'South America' AND population > 40000000
+{Select the result that would be obtained from this code:
 <table style='float:left'><caption>Table-A</caption><tr><td>Afghanistan</td></tr><tr><td>Brazil</td></tr><tr><td>Colombia</td></tr></table>
 <table style='float:left'><caption>Table-B</caption><tr><td>Brazil</td></tr></table>

@@ Line 114: / Line 114: @@
 |type="()"}
 - SELECT name FROM bbc WHERE name = 'United Kingdom'
-+ SELECT name FROM bbc WHERE name = 'United Kingdom' or name = 'Algeria'
+- SELECT name FROM bbc WHERE name = 'United Kingdom' AND name = 'Algeria'
 - SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria')
-- SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria')
++ SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria')
 - SELECT name FROM WHERE name IS 'Scotland'

@@ Line 91: / Line 91: @@
 {Select the result that would be obtained from the following code: SELECT name, population / 10 FROM bbc WHERE population < 10000
-<table><caption>Table-A</caption><tr><td>Andorra</td><td>6400</td></tr><tr><td>Nauru</td><td>990</td></tr></table>
+<table style='float:left'><caption>Table-A</caption><tr><td>Andorra</td><td>6400</td></tr><tr><td>Nauru</td><td>990</td></tr></table>
-<table><caption>Table-B</caption><tr><td>Andorra</td><td>64000</td></tr><tr><td>Nauru</td><td>9900</td></tr></table>
+<table style='float:left'><caption>Table-B</caption><tr><td>Andorra</td><td>64000</td></tr><tr><td>Nauru</td><td>9900</td></tr></table>
-<table><caption>Table-C</caption><tr><td>Nauru</td><td>99</td></tr></table>
+<table style='float:left'><caption>Table-C</caption><tr><td>Nauru</td><td>99</td></tr></table>
-<table><caption>Table-D</caption><tr><td>Nauru</td><td>990</td></tr></table>
+<table style='float:left'><caption>Table-D</caption><tr><td>Nauru</td><td>990</td></tr></table>
-<table><caption>Table-E</caption><tr><td>Nauru</td><td>9900</td></tr></table>
+<table style='float:left'><caption>Table-E</caption><tr><td>Nauru</td><td>9900</td></tr></table>
 |type="()"}
 - Table-A
@@ Line 120: / Line 120: @@
 {Select the result that would be obtained from this code: SELECT name FROM bbc WHERE region = 'South America' AND population > 40000000
-<table><caption>Table-A</caption><tr><td>Afghanistan</td></tr><tr><td>Brazil</td></tr><tr><td>Colombia</td></tr></table>
+<table style='float:left'><caption>Table-A</caption><tr><td>Afghanistan</td></tr><tr><td>Brazil</td></tr><tr><td>Colombia</td></tr></table>
-<table><caption>Table-B</caption><tr><td>Brazil</td></tr></table>
+<table style='float:left'><caption>Table-B</caption><tr><td>Brazil</td></tr></table>
-<table><caption>Table-C</caption><tr><td>Brazil</td></tr><tr><td>Colombia</td></tr></table>
+<table style='float:left'><caption>Table-C</caption><tr><td>Brazil</td></tr><tr><td>Colombia</td></tr></table>
-<table><caption>Table-D</caption><tr><td>Brazil</td><td>South America</td></tr><tr><td>Colombia</td><td>South America</td></tr></table>
+<table style='float:left'><caption>Table-D</caption><tr><td>Brazil</td><td>South America</td></tr><tr><td>Colombia</td><td>South America</td></tr></table>
-<table><caption>Table-E</caption><tr><td>Brazil</td><td>182800000</td></tr><tr><td>Colombia</td><td>45600000</td></tr></table>
+<table style='float:left'><caption>Table-E</caption><tr><td>Brazil</td><td>182800000</td></tr><tr><td>Colombia</td><td>45600000</td></tr></table>
 |type="()"}
 - Table-A

@@ Line 91: / Line 91: @@
 {Select the result that would be obtained from the following code: SELECT name, population / 10 FROM bbc WHERE population < 10000
 |type="()"}
-- Andorra, 6400,  Nauru, 990
+- Table-A
-- Andorra, 64000,  Nauru, 9900
+- Table-B
-- Nauru, 99
+- Table-C
-+ Nauru, 990
++ Table-D
-- Nauru, 9900
+- Table-E
 {Select the code which would reveal the name and population of countries in Europe, North America and South America
@@ Line 115: / Line 120: @@
 {Select the result that would be obtained from this code: SELECT name FROM bbc WHERE region = 'South America' AND population > 40000000
 |type="()"}
-- Brazil
+- Table-A
-+ Brazil, Colombia
+- Table-B
-- Brazil, South America,  Colombia, South America
++ Table-C
-- Brazil,182800000, Colombia,45600000
+- Table-D
-- Afghanistan, Brazil, Colombia
+- Table-E
 </quiz>
 [[Category:Quizzes]]

@@ Line 36: / Line 36: @@
 <td align='right'>468</td>
 <td align='right'>64000</td>
 <td></td>
 </tr>
@@ Line 47: / Line 68: @@
 {Select the code which gives the name of countries beginning with C
 |type="()"}
--A. SELECT name FROM bbc WHERE name BEGIN with C
+- SELECT name FROM bbc WHERE name BEGIN with C
--B. SELECT name FROM bbc WHERE name LIKE '%C'
+- SELECT name FROM bbc WHERE name LIKE '%C'
--C. SELECT name FROM bbc WHERE name LIKE '%C%'
+- SELECT name FROM bbc WHERE name LIKE '%C%'
--D. SELECT name FROM bbc WHERE name LIKE C
+- SELECT name FROM bbc WHERE name LIKE C
-+E. SELECT name FROM bbc WHERE name LIKE 'C%'
++ SELECT name FROM bbc WHERE name LIKE 'C%'
-−
 {Select the code which shows just the population of United Kingdom?
 |type="()"}
-- A. SELECT name FROM bbc WHERE name Like 'United%'
+- SELECT name FROM bbc WHERE name Like 'United%'
-- B. SELECT name FROM bbc WHERE population = 'United Kingdom'
+- SELECT name FROM bbc WHERE population = 'United Kingdom'
-- C. SELECT name, population FROM bbc WHERE name = 'United Kingdom'
+- SELECT name, population FROM bbc WHERE name = 'United Kingdom'
-+ D. SELECT population FROM bbc WHERE name = 'United Kingdom'
++ SELECT population FROM bbc WHERE name = 'United Kingdom'
-- E. SELECT population FROM bbc WHERE name = United Kingdom
+- SELECT population FROM bbc WHERE name = United Kingdom
 {Select the answer which shows the problem with this SQL code:SELECT name FROM "bbc" WHERE population > '2000000'
 |type="()"}
-- A. Apostrophes should be used around 'bbc' instead of speech marks
+- Apostrophes should be used around 'bbc' instead of speech marks
-- B. There are apostrophes surrounding '2000000'
+- There are apostrophes surrounding '2000000'
-+ C. There are speech marks surrounding "bbc"
++ There are speech marks surrounding "bbc"
-- D. There are speech marks surrounding "bbc" and there is apostrophes surrounding '2000000'
+- There are speech marks surrounding "bbc" and there is apostrophes surrounding '2000000'
-- E. The use of a WHERE function is incorrect
+- The use of a WHERE function is incorrect
 {Select the code which would reveal the name and population of countries in Europe, North America and South America
 |type="()"}
-- A. SELECT name FROM bbc WHERE region IN ('Europe', 'North America', 'South America')
+- SELECT name FROM bbc WHERE region IN ('Europe', 'North America', 'South America')
-+ B. SELECT name, population FROM bbc WHERE region IN ('Europe', 'North America', 'South America')
++ SELECT name, population FROM bbc WHERE region IN ('Europe', 'North America', 'South America')
-- C. SELECT name, population FROM bbc WHERE region IN (Europe North America South America)
+- SELECT name, population FROM bbc WHERE region IN (Europe North America South America)
-- D. SELECT name, population FROM bbc WHERE region IS ('Europe', 'North America', 'South America')
+- SELECT name, population FROM bbc WHERE region IS ('Europe', 'North America', 'South America')
-- E. SELECT population FROM bbc WHERE region IN ('Europe', 'North America', 'South America')
+- SELECT population FROM bbc WHERE region IN ('Europe', 'North America', 'South America')
 {Select the code which would give two rows
 |type="()"}
-- A. SELECT name FROM bbc WHERE name = 'United Kingdom'
+- SELECT name FROM bbc WHERE name = 'United Kingdom'
-+ B. SELECT name FROM bbc WHERE name = 'United Kingdom' or name = 'Algeria'
++ SELECT name FROM bbc WHERE name = 'United Kingdom' or name = 'Algeria'
-- C. SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria')
+- SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria')
-- D. SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria')
+- SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria')
-- E. SELECT name FROM WHERE name IS 'Scotland'
+- SELECT name FROM WHERE name IS 'Scotland'
 </quiz>
 [[Category:Quizzes]]