2.2.3(d) SQL

Question 1

a database is …

Answer 1

… an organised collect of structured information, or data, typically stored electronically in a computer system

Question 2

SQL is …

Answer 2

… a language used to get data from a database

Question 3

use SQL when …

Answer 3

… when there is a lot of data you need a way of getting ‘querying’ the information that you want

Question 4

SQL commands

Answer 4

• SELECT population FROM world WHERE name - ‘Albania’
• SELECT * FROM world WHERE name = ‘Algeria”
• SELECT * FROM world WHERE name LIKE ’A*’ and population > 10,000,000
• SELECT name, population FROM world WHERE name LIKE ‘A’ OR name LIKE ‘B’
• SELECT name FROM world Where population > (SELECT population FROM world WHERE name = ‘Algeria’)