What SQL clause is used to filter rows in a result set based on specific conditions?
ORDER BY
WHERE
FROM
SELECT
Which of the following is NOT a valid SQL data type?
VARCHAR
INTEGER
FLOAT
BOOLEAN
Which comparison operator means 'not equal to' in SQL?
!=
<
<>
=
What is the purpose of the 'LIMIT' clause in SQL?
It sorts the result set.
It filters rows based on a condition.
It restricts the number of rows returned by the query.
It groups rows with the same values.
Which keyword is used in conjunction with the UPDATE statement to specify the conditions for updating rows?
CONDITION
WHEN
IF
How would you sort results in descending order by the 'date_created' column?
SORT BY date_created DESC
ORDER BY date_created DESC
ORDER BY date_created ASC
SORT BY date_created ASC
What type of join returns all rows from both tables, regardless of whether there is a match?
INNER JOIN
RIGHT JOIN
LEFT JOIN
FULL OUTER JOIN
What does the asterisk (*) symbol represent when used in a SELECT statement?
A comment indicator
All columns
A wildcard for searching data
A specific column name
What SQL clause is used to group rows with the same value in one or more columns into a summary row?
GROUP BY
In a SQL query, what does the logical operator 'AND' do?
It negates a condition.
It sorts the results in descending order.
It combines two conditions, and at least one condition must be true for the row to be included.
It combines two conditions, and both conditions must be true for the row to be included.