Difference between revisions of "BBC QUIZ"

From SQLZOO
Jump to: navigation, search
Line 1: Line 1:
 
BBC QUIZ
 
BBC QUIZ
<quiz shuffle=none display=simple class='hover'>
+
<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 C
 
|type="()"}
 
|type="()"}
<input type='radio' name='q0'[A. SELECT name FROM bbc WHERE name BEGIN with C]' value='1' /><label>A. SELECT name FROM bbc WHERE name BEGIN with C</label>
+
<input type='radio' name='q0'[A. SELECT name FROM bbc WHERE name BEGIN with C]' value='1' /><label class='hover'>A. SELECT name FROM bbc WHERE name BEGIN with C</label>
 
-A. SELECT name FROM bbc WHERE name BEGIN with C
 
-A. SELECT name FROM bbc WHERE name BEGIN with C
<input type='radio' name='q0'[B. SELECT name FROM bbc WHERE name LIKE '%C']' value='2' /><label>B. SELECT name FROM bbc WHERE name LIKE '%C'</label>
+
<input type='radio' name='q0'[B. SELECT name FROM bbc WHERE name LIKE '%C']' value='2' /><label class='hover'>B. SELECT name FROM bbc WHERE name LIKE '%C'</label>
 
-B. SELECT name FROM bbc WHERE name LIKE '%C'
 
-B. SELECT name FROM bbc WHERE name LIKE '%C'
<input type='radio' name='q0'[C. SELECT name FROM bbc WHERE name LIKE '%C%']' value='3' /><label>C. SELECT name FROM bbc WHERE name LIKE '%C%'</label>
+
<input type='radio' name='q0'[C. SELECT name FROM bbc WHERE name LIKE '%C%']' value='3' /><label class='hover'>C. SELECT name FROM bbc WHERE name LIKE '%C%'</label>
 
-C. SELECT name FROM bbc WHERE name LIKE '%C%'
 
-C. SELECT name FROM bbc WHERE name LIKE '%C%'
<input type='radio' name='q0'[D. SELECT name FROM bbc WHERE name LIKE C]' value='4' /><label>D. SELECT name FROM bbc WHERE name LIKE C</label>
+
<input type='radio' name='q0'[D. SELECT name FROM bbc WHERE name LIKE C]' value='4' /><label class='hover'>D. SELECT name FROM bbc WHERE name LIKE C</label>
 
-D. SELECT name FROM bbc WHERE name LIKE C
 
-D. SELECT name FROM bbc WHERE name LIKE C
<input type='radio' name='q0'[E. SELECT name FROM bbc WHERE name LIKE 'C%']' value='5' /><label>E. SELECT name FROM bbc WHERE name LIKE 'C%'</label>
+
<input type='radio' name='q0'[E. SELECT name FROM bbc WHERE name LIKE 'C%']' value='5' /><label class='hover'>E. SELECT name FROM bbc WHERE name LIKE 'C%'</label>
 
+E. SELECT name FROM bbc WHERE name LIKE 'C%'
 
+E. SELECT name FROM bbc WHERE name LIKE 'C%'
  

Revision as of 10:34, 23 July 2012

BBC QUIZ <quiz shuffle=none display=simple> {Select the code which gives the name of countries beginning with C |type="()"} <input type='radio' name='q0'[A. SELECT name FROM bbc WHERE name BEGIN with C]' value='1' /><label class='hover'>A. SELECT name FROM bbc WHERE name BEGIN with C</label> -A. SELECT name FROM bbc WHERE name BEGIN with C <input type='radio' name='q0'[B. SELECT name FROM bbc WHERE name LIKE '%C']' value='2' /><label class='hover'>B. SELECT name FROM bbc WHERE name LIKE '%C'</label> -B. SELECT name FROM bbc WHERE name LIKE '%C' <input type='radio' name='q0'[C. SELECT name FROM bbc WHERE name LIKE '%C%']' value='3' /><label class='hover'>C. SELECT name FROM bbc WHERE name LIKE '%C%'</label> -C. SELECT name FROM bbc WHERE name LIKE '%C%' <input type='radio' name='q0'[D. SELECT name FROM bbc WHERE name LIKE C]' value='4' /><label class='hover'>D. SELECT name FROM bbc WHERE name LIKE C</label> -D. SELECT name FROM bbc WHERE name LIKE C <input type='radio' name='q0'[E. SELECT name FROM bbc WHERE name LIKE 'C%']' value='5' /><label class='hover'>E. SELECT name FROM bbc WHERE name LIKE 'C%'</label> +E. 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%' - B. SELECT name FROM bbc WHERE population = 'United Kingdom' - C. SELECT name, population FROM bbc WHERE name = 'United Kingdom' + D. SELECT population FROM bbc WHERE name = 'United Kingdom' - E. 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 - B. There are apostrophes surrounding '2000000' + C. There are speech marks surrounding "bbc" - D. There are speech marks surrounding "bbc" and there is apostrophes surrounding '2000000' - E. 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') + B. 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) - D. 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 the code which would give two rows |type="()"} - A. SELECT name FROM bbc WHERE name = 'United Kingdom' + B. SELECT name FROM bbc WHERE name = 'United Kingdom' or name = 'Algeria' - C. SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria') - D. SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria') - E. SELECT name FROM WHERE name IS 'Scotland' </quiz>