To modify existing data in a table, which SQL statement would you use?
CHANGE
MODIFY
UPDATE
ALTER
Which of the following is NOT a valid SQL data type?
INTEGER
BOOLEAN
VARCHAR
FLOAT
What does the asterisk (*) symbol represent when used in a SELECT statement?
A comment indicator
All columns
A specific column name
A wildcard for searching data
Which comparison operator means 'not equal to' in SQL?
<>
=
<
!=
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.
What is the result of SELECT NOW(); in SQL?
SELECT NOW();
Current time
Current date
Current date and time
An error message
You want to select the department with the highest average salary. What SQL clause would you use to filter the grouped results based on the calculated average salary?
HAVING
WHERE
ORDER BY
LIMIT
How would you select the top 5 highest-scoring games from a table named 'games' with a column called 'score'?
SELECT * FROM games WHERE score LIMIT 5;
SELECT * FROM games ORDER BY score ASC LIMIT 5;
SELECT * FROM games ORDER BY score DESC LIMIT 5;
SELECT TOP 5 * FROM games ORDER BY score DESC;
In a SQL query, what does the logical operator 'AND' do?
It sorts the results in descending order.
It combines two conditions, and both conditions must be true for the row to be included.
It negates a condition.
It combines two conditions, and at least one condition must be true for the row to be included.
What is the primary clause used to retrieve data from a table in SQL?
RETRIEVE
FETCH
GET
SELECT