Difference between revisions of "BBC QUIZ"
From SQLZOO
| Line 3: | Line 3: | ||
{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="()"} | ||
| − | - SELECT name FROM bbc WHERE name BEGIN with C | + | - A. SELECT name FROM bbc WHERE name BEGIN with C |
| − | - SELECT name FROM bbc WHERE name LIKE '%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 the code which shows just the population of United Kingdom? | {Select the code which shows just the population of United Kingdom? | ||
|type="()"} | |type="()"} | ||
| − | - SELECT name FROM bbc WHERE name Like 'United%' | + | - A. SELECT name FROM bbc WHERE name Like 'United%' |
| − | - SELECT name FROM bbc WHERE population = 'United Kingdom' | + | - B. SELECT name FROM bbc WHERE population = 'United Kingdom' |
| − | - SELECT name, population FROM bbc WHERE name = 'United Kingdom' | + | - C. SELECT name, population FROM bbc WHERE name = 'United Kingdom' |
| − | + SELECT 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 the answer which shows the problem with this SQL code:SELECT name FROM "bbc" WHERE population > '2000000' | {Select the answer which shows the problem with this SQL code:SELECT name FROM "bbc" WHERE population > '2000000' | ||
|type="()"} | |type="()"} | ||
| − | - Apostrophes should be used around 'bbc' instead of speech marks | + | - A. Apostrophes should be used around 'bbc' instead of speech marks |
| − | - There are apostrophes surrounding '2000000' | + | - B. There are apostrophes surrounding '2000000' |
| − | + There are speech marks surrounding "bbc" | + | + C. There are speech marks surrounding "bbc" |
| − | - There are speech marks surrounding "bbc" and there is apostrophes surrounding '2000000' | + | - D. There are speech marks surrounding "bbc" and there is apostrophes surrounding '2000000' |
| − | - The use of a WHERE function is incorrect | + | - 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 | {Select the code which would reveal the name and population of countries in Europe, North America and South America | ||
|type="()"} | |type="()"} | ||
| − | - SELECT name FROM bbc WHERE region IN ('Europe', 'North America', 'South America') | + | - A. SELECT name FROM bbc WHERE region IN ('Europe', 'North America', 'South America') |
| − | + SELECT name, population 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 IS ('Europe', 'North America', 'South America') | + | - D. SELECT name, population FROM bbc WHERE region IS ('Europe', 'North America', 'South America') |
| − | - SELECT population FROM bbc WHERE region IN ('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 | {Select the code which would give two rows | ||
|type="()"} | |type="()"} | ||
| − | - SELECT name FROM bbc WHERE name = 'United Kingdom' | + | - A. SELECT name FROM bbc WHERE name = 'United Kingdom' |
| − | + SELECT name FROM bbc WHERE name = 'United Kingdom' or name = 'Algeria' | + | + B. SELECT name FROM bbc WHERE name = 'United Kingdom' or name = 'Algeria' |
| − | - SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria') | + | - C. SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria') |
| − | - SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria') | + | - D. SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria') |
| − | - SELECT name FROM WHERE name IS 'Scotland' | + | - E. SELECT name FROM WHERE name IS 'Scotland' |
</quiz> | </quiz> | ||
[[Category:Quizzes]] | [[Category:Quizzes]] | ||
Revision as of 08:23, 23 July 2012
BBC QUIZ
