Which keyword is used in conjunction with the UPDATE statement to specify the conditions for updating rows?
IF
WHEN
WHERE
CONDITION
In a SQL query, what does the logical operator 'AND' do?
It sorts the results in descending order.
It negates a condition.
It combines two conditions, and both conditions must be true for the row to be included.
It combines two conditions, and at least one condition must be true for the row to be included.
What is the function of the SQL 'WHERE' clause?
To filter records based on a specified condition
To order the results of a query
To group rows with the same value in a certain column
To limit the number of rows returned by a query
What is the purpose of the 'OR' operator in a SQL WHERE clause?
It selects rows where both conditions are true.
It selects rows where at least one condition is true.
It limits the number of rows returned.
Which aggregate function would you use to find the highest value in a column?
AVG()
MAX()
SUM()
MIN()
To modify existing data in a table, which SQL statement would you use?
CHANGE
MODIFY
UPDATE
ALTER
Which SQL statement is used to remove rows from a table?
DELETE
REMOVE
DROP
TRUNCATE
What does SQL stand for?
Simple Query Language
System Query Language
Structured Query Language
Standard Query Logic
Which SQL statement is used to add new rows into a table?
CREATE
ADD
APPEND
INSERT
What is the purpose of a subquery in SQL?
To retrieve data from a table that will be used in a larger query.
To define a new aggregate function.
To modify data in multiple tables simultaneously.
To create a temporary table for intermediate results.