BBC QUIZ

BBC QUIZ
<quiz shuffle=none display=simple>
{Select the code which gives the name of countries beginning with C
|type="()"}
- A. SELECT name FROM bbc WHERE name BEGIN with C
- B. SELECT name FROM bbc WHERE name LIKE '%C'
- C. SELECT name FROM bbc WHERE name LIKE '%C%'
- D. 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?
|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>