- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name = 'United Kingdom' </syntaxhighlight>

−

- SELECT name FROM bbc WHERE name = 'United Kingdom' AND name = 'Algeria'

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name = 'United Kingdom' AND name = 'Algeria' </syntaxhighlight>

−

- SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria')

+

- <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria') </syntaxhighlight>

−

+ SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria')

+

+ <syntaxhighlight lang='sql'> SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria') </syntaxhighlight>

−

- SELECT name FROM WHERE name IS 'Scotland'

+

- <syntaxhighlight lang='sql'> SELECT name FROM WHERE name IS 'Scotland' </syntaxhighlight>

{Select the result that would be obtained from this code:

{Select the result that would be obtained from this code:

Revision as of 10:41, 12 July 2013

BBC QUIZ

bbc

name

region

area

population

gdp

Afghanistan

South Asia

652225

26000000

Albania

Europe

28728

3200000

6656000000

Algeria

Middle East

2400000

32900000

75012000000

Andorra

Europe

468

64000

Brazil

South America

8550000

182800000

564852000000

Colombia

South America

1140000

45600000

Nauru

Asia-Pacific

21

9900

</tr>

Uzbekistan

Central Asia

447000

26000000

...

<quiz shuffle=none display=simple>
{Select the code which gives the name of countries beginning with U
|type="()"}

-

SELECT name FROM bbc WHERE name BEGINWITH 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'U%'

{Select the code which shows just the population of United Kingdom?
|type="()"}

-

SELECT name FROM bbc WHERE name LIKE'United%'

-

SELECT name FROM bbc WHERE population ='United Kingdom'

-

SELECT name, population FROM bbc WHERE name ='United Kingdom'

+

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="()"}
- 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" and there are apostrophes surrounding '2000000'
- The use of a WHERE function is incorrect

{Select the result that would be obtained from the following code:

SELECT name, population /10FROM bbc
WHERE population <10000

Table-A

Andorra

6400

Nauru

990

Table-B

Andorra

64000

Nauru

9900

Table-C

Nauru

99

Table-D

Nauru

990

Table-E

Nauru

9900

|type="()"}
- Table-A
- Table-B
- Table-C
+ Table-D
- Table-E

{Select the code which would reveal the name and population of countries in Europe, North America and South America
|type="()"}

-

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')

-

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')

-

SELECT population FROM bbc WHERE region IN('Europe','North America','South America')

{Select the code which would give two rows
|type="()"}

-

SELECT name FROM bbc WHERE name ='United Kingdom'

-

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 FROMWHERE name IS'Scotland'

{Select the result that would be obtained from this code:

SELECT name FROM bbc WHERE region ='South America'AND population >40000000