Structured Query Language Quiz

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 SQL command is used to select specific data from a table?

• INSERT INTO

• DELETE FROM

• UPDATE

• SELECT

What does the SQL command 'SELECT *' do?

• Selects all fields from the table

• Selects only the primary key field

• Selects fields with a specific value

• Selects fields based on a condition

How can you select records from a table where the name starts with 'A' and the population is greater than 1 million?

• SELECT name, population FROM table WHERE name = 'A' AND population > 1 million

• SELECT name, population FROM table WHERE name LIKE 'A%' AND population > 1 million

• SELECT name, population FROM table WHERE name = 'A' OR population > 1 million

• SELECT name, population FROM table WHERE name LIKE 'A%' OR population > 1 million

Which SQL command is used to insert new records into a table?

• INSERT INTO

• DELETE FROM

• UPDATE

• SELECT

How can you delete all records from a table with a population larger than 10 million?

• DELETE FROM table WHERE population > 10 million

• DELETE FROM table WHERE population < 10 million

• DELETE FROM table WHERE population = 10 million

• DELETE FROM table WHERE population >= 10 million

Which SQL command is used to modify data in a table?

• INSERT INTO

• DELETE FROM

• UPDATE

• SELECT

How can you perform an SQL query on more than one table?

• JOIN

• INSERT INTO

• DELETE FROM

• UPDATE

What does the SQL command 'DROP TABLE' do?

• Deletes existing tables

• Modifies the structure of a table

• Inserts new records into a table

• Selects specific data from a table

What can you do with SQL besides the commands mentioned?

• Define and create tables

• Add, delete, and change fields in a table

• Set up relationships between tables

• All of the above