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

+

- Table-A

−

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

+

- Table-B

−

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

+

+ Table-C

−

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

+

- Table-D

−

- None of the above

+

- Table-E

</quiz>

</quiz>

+

[[Category:Quizzes]]

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="()"}

-

SELECTnameFROMbbcWHEREnameBEGINwithC

-

SELECTnameFROMbbcWHEREnameLIKE'%C'

-

SELECTnameFROMbbcWHEREnameLIKE'%C%'

-

SELECTnameFROMbbcWHEREnameLIKEU

+

SELECTnameFROMbbcWHEREnameLIKE'U%'

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

-

SELECTnameFROMbbcWHEREnameLike'United%'

-

SELECTnameFROMbbcWHEREpopulation='United Kingdom'

-

SELECTname,populationFROMbbcWHEREname='United Kingdom'

+

SELECTpopulationFROMbbcWHEREname='United Kingdom'

-

SELECTpopulationFROMbbcWHEREname=UnitedKingdom

{Select the answer which shows the problem with this SQL code:

SELECTnameFROM"bbc"WHEREpopulation>'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:

SELECTname,population/10FROMbbcWHEREpopulation<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="()"}