Which keyword is used in conjunction with the UPDATE statement to specify the conditions for updating rows?
WHEN
IF
CONDITION
WHERE
What is the purpose of the COUNT() function in SQL?
COUNT()
Returns the average value of a column
Finds the minimum value in a column
Returns the number of rows in a table
Calculates the sum of values in a column
How would you convert the text 'hello world' to uppercase in SQL?
UCASE('hello world')
TO_UPPER('hello world')
MAKE_UPPER('hello world')
UPPER('hello world')
Which SQL statement is used to add new rows into a table?
ADD
APPEND
CREATE
INSERT
What does the asterisk (*) symbol represent when used in a SELECT statement?
A comment indicator
A specific column name
A wildcard for searching data
All columns
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 * FROM games WHERE score LIMIT 5;
SELECT TOP 5 * FROM games ORDER BY score DESC;
Which SQL clause is used to sort the result set?
ORDER
SORT
ORDER BY
SORT BY
Which of the following is NOT a valid SQL data type?
INTEGER
BOOLEAN
FLOAT
VARCHAR
What is the purpose of a subquery in SQL?
To define a new aggregate function.
To retrieve data from a table that will be used in a larger query.
To create a temporary table for intermediate results.
To modify data in multiple tables simultaneously.
What is the purpose of the 'LIMIT' clause in SQL?
It restricts the number of rows returned by the query.
It groups rows with the same values.
It sorts the result set.
It filters rows based on a condition.