SLR10: SQL

What is the primary purpose of SQL?

• To define the structure of a database

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

• To express what needs to be achieved in data manipulation

• To create graphical user interfaces for databases

Which SQL command is used to retrieve data from a database?

• UPDATE

• DELETE

• SELECT

• INSERT

What does the wildcard '%' represent in an SQL query?

• A specific string

• A single character

• Any sequence of characters

• A specific number

Which SQL command is used to add new records to a table?

• UPDATE

• INSERT INTO

• SELECT

• DELETE

What is the purpose of the SQL 'ORDER BY' clause?

• To group records with similar values

• To sort the result set

• To join multiple tables

• To filter records based on a condition

Which SQL command is used to remove records from a table?

• UPDATE

• DELETE FROM

• SELECT

• INSERT INTO

What is the function of the SQL 'JOIN' clause?

• To update records in a table

• To combine data from two or more tables

• To delete records from multiple tables

• To insert records into multiple tables

Which SQL command is used to modify existing records in a table?

• DELETE FROM

• INSERT INTO

• UPDATE

• SELECT

What does the SQL 'DROP TABLE' command do?

• Updates the structure of a table

• Creates a new table

• Removes a table and all its data

• Deletes all records from a table

In SQL, what does the 'AND' clause do in a query?

• Sorts the result set in descending order

• Filters records based on multiple conditions

• Joins two tables together

• Combines results from multiple queries