To modify existing data in a table, which SQL statement would you use?
CHANGE
MODIFY
ALTER
UPDATE
Which SQL clause is used to sort the result set?
ORDER BY
ORDER
SORT BY
SORT
How would you select the top 5 highest-scoring games from a table named 'games' with a column called 'score'?
SELECT * FROM games ORDER BY score DESC LIMIT 5;
SELECT * FROM games ORDER BY score ASC LIMIT 5;
SELECT TOP 5 * FROM games ORDER BY score DESC;
SELECT * FROM games WHERE score LIMIT 5;
In which scenario would a subquery be a more suitable choice than a JOIN operation?
When you need to filter data based on a condition that involves a separate query.
When you need to update data in one table based on data from another table.
When you need to combine data from multiple tables based on a common column.
When you need to sort data from multiple tables based on a common column.
Which type of subquery is used to check if a value exists in a list of values returned by another query?
IN Subquery
Correlated Subquery
EXISTS Subquery
Nested Subquery
What does the asterisk (*) symbol represent when used in a SELECT statement?
A wildcard for searching data
A comment indicator
All columns
A specific column name
Which keyword is used in conjunction with the UPDATE statement to specify the conditions for updating rows?
WHERE
CONDITION
WHEN
IF
How would you sort results in descending order by the 'date_created' column?
SORT BY date_created ASC
ORDER BY date_created ASC
SORT BY date_created DESC
ORDER BY date_created DESC
In a SQL query, what does the logical operator 'AND' do?
It negates a condition.
It combines two conditions, and at least one condition must be true for the row to be included.
It sorts the results in descending order.
It combines two conditions, and both conditions must be true for the row to be included.
What is the purpose of the 'OR' operator in a SQL WHERE clause?
It selects rows where at least one condition is true.
It limits the number of rows returned.
It selects rows where both conditions are true.