Difference between revisions of "BBC QUIZ"

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

	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

	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

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

	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'

@@ Line 3: / Line 3: @@
 {Select the code which gives the name of countries beginning with C
 |type="()"}
--A. SELECT name FROM bbc WHERE name BEGIN with C</label>
+-A. SELECT name FROM bbc WHERE name BEGIN with C
--B. SELECT name FROM bbc WHERE name LIKE '%C'</label>
+-B. SELECT name FROM bbc WHERE name LIKE '%C'
--C. SELECT name FROM bbc WHERE name LIKE '%C%'</label>
+-C. SELECT name FROM bbc WHERE name LIKE '%C%'
--D. SELECT name FROM bbc WHERE name LIKE C</label>
+-D. SELECT name FROM bbc WHERE name LIKE C
-+E. SELECT name FROM bbc WHERE name LIKE 'C%'</label>
++E. SELECT name FROM bbc WHERE name LIKE 'C%'

Revision as of 09:44, 3 August 2012