What is the purpose of the 'LIMIT' clause in SQL?
It groups rows with the same values.
It restricts the number of rows returned by the query.
It sorts the result set.
It filters rows based on a condition.
To modify existing data in a table, which SQL statement would you use?
CHANGE
ALTER
MODIFY
UPDATE
You are using a subquery to fetch a list of product IDs from an 'Orders' table. What is the main purpose of using the DISTINCT keyword within this subquery?
To retrieve only unique product IDs, eliminating duplicates.
To limit the number of product IDs returned.
To sort the product IDs in ascending order.
To filter product IDs based on a specific condition.
Which comparison operator means 'not equal to' in SQL?
<>
=
<
!=
What type of join returns all rows from the left table, even if there are no matching rows in the right table?
LEFT JOIN
FULL JOIN
RIGHT JOIN
INNER JOIN
Which SQL statement is used to add new rows into a table?
CREATE
INSERT
APPEND
ADD
What is the purpose of the 'OR' operator in a SQL WHERE clause?
It limits the number of rows returned.
It selects rows where at least one condition is true.
It negates a condition.
It selects rows where both conditions are true.
Which SQL statement is used to remove rows from a table?
REMOVE
DROP
DELETE
TRUNCATE
What does SQL stand for?
System Query Language
Simple Query Language
Standard Query Logic
Structured Query Language
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 combines two conditions, and at least one condition must be true for the row to be included.