Structured Query Language

What is the purpose of SQL?

• To retrieve, delete, and manipulate data in relational databases

• To express the logic of how something needs to be achieved

• To define and control data access

• To create and modify tables in a database

Which type of language is SQL?

• Declarative

• Procedural

• Object-oriented

• Functional

Ella, Eesha, and Mira are working on a database project. What can they do with SQL in their project?

• Query data to find specific information

• Manipulate data to update records

• Define data to create new tables

• Control data access to restrict certain users

Arthur is working on a database for his school project and wants to retrieve specific data from a table. Which SQL statement should he use?

• SELECT

• INSERT

• DELETE

• UPDATE

James, Sebastian, and Matilda are working on a project about world demographics. They are using a database named 'world'. James runs the SQL statement 'SELECT population FROM world WHERE name = Germany'. What does this statement do?

• Retrieves the population of Germany from the 'world' table

• Deletes the record of Germany from the 'world' table

• Updates the population of Germany in the 'world' table

• Inserts a new record for Germany into the 'world' table

Mira is working on a school project about Algeria. She needs to retrieve the name, area, population, GDP, and capital of Algeria from a database. Which SQL statement should she use?

• SELECT name, area, population, GDP, capital FROM world WHERE name = 'Algeria'

• DELETE FROM world WHERE name = 'Algeria'

• UPDATE world SET name = 'Algeria', area = 'new_area', population = 'new_population', GDP = 'new_GDP', capital = 'new_capital'

• INSERT INTO world (name, area, population, GDP, capital) VALUES ('Algeria', 'new_area', 'new_population', 'new_GDP', 'new_capital')

What does the SQL statement 'SELECT * FROM world WHERE name = Algeria' do?

• Retrieves all fields of the record for Algeria from the 'world' table

• Deletes the record of Algeria from the 'world' table

• Updates all fields of the record for Algeria in the 'world' table

• Inserts a new record for Algeria into the 'world' table

What does the SQL statement 'SELECT name, population FROM world WHERE name LIKE 'A%' OR name LIKE 'B%'' do?

• Retrieves the name and population of countries whose names start with 'A' or 'B' from the 'world' table

• Deletes records from the 'world' table

• Updates records in the 'world' table

• Inserts new records into the 'world' table

What does the SQL statement 'SELECT name FROM world WHERE population > (SELECT population FROM world WHERE name = Algeria)' do?

• Retrieves the name of countries with a population greater than Algeria from the 'world' table

• Deletes records from the 'world' table

• Updates records in the 'world' table

• Inserts new records into the 'world' table

What does the SQL statement 'INSERT INTO world (name, capital, population) VALUES ('Ours', 'Emerald City', 1000000)' do?

• Inserts a new record with the given values into the 'world' table

• Deletes records from the 'world' table

• Updates records in the 'world' table

• Retrieves data from the 'world' table