What is the primary clause used to retrieve data from a table in SQL?
RETRIEVE
SELECT
GET
FETCH
What is the purpose of the COUNT() function in SQL?
COUNT()
Returns the number of rows in a table
Finds the minimum value in a column
Returns the average value of a column
Calculates the sum of values in a column
What SQL clause is used to filter rows in a result set based on specific conditions?
FROM
WHERE
ORDER BY
What does SQL stand for?
Standard Query Logic
Simple Query Language
System Query Language
Structured Query Language
In which scenario would a subquery be a more suitable choice than a JOIN operation?
When you need to sort data from multiple tables based on a common column.
When you need to filter data based on a condition that involves a separate query.
When you need to combine data from multiple tables based on a common column.
When you need to update data in one table based on data from another table.
What is the key difference between the IN and EXISTS operators when used with subqueries?
IN is used for single values, while EXISTS is used for multiple values.
There is no difference; they are interchangeable.
IN compares values, while EXISTS checks for the presence of rows.
IN checks for existence in a list, while EXISTS checks for existence in a table.
Which SQL clause is used to sort the result set?
SORT BY
ORDER
SORT
How would you sort results in descending order by the 'date_created' column?
ORDER BY date_created DESC
SORT BY date_created DESC
SORT BY date_created ASC
ORDER BY date_created ASC
What is the function of the SQL 'WHERE' clause?
To limit the number of rows returned by a query
To group rows with the same value in a certain column
To order the results of a query
To filter records based on a specified condition
Which SQL statement is used to add new rows into a table?
CREATE
APPEND
ADD
INSERT