What type of join returns all rows from both tables, regardless of whether there is a match?
FULL OUTER JOIN
INNER JOIN
RIGHT JOIN
LEFT JOIN
What type of join returns all rows from the left table, even if there are no matching rows in the right table?
FULL JOIN
Which of the following is NOT a valid SQL data type?
VARCHAR
BOOLEAN
INTEGER
FLOAT
Which data type would be most suitable for storing a person's last name in a SQL database?
DATE
DECIMAL
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 filter product IDs based on a specific condition.
To limit the number of product IDs returned.
To sort the product IDs in ascending order.
To retrieve only unique product IDs, eliminating duplicates.
What is the function of the SQL 'WHERE' clause?
To order the results of a query
To filter records based on a specified condition
To limit the number of rows returned by a query
To group rows with the same value in a certain column
What is the primary clause used to retrieve data from a table in SQL?
GET
SELECT
RETRIEVE
FETCH
Which SQL statement is used to add new rows into a table?
ADD
INSERT
CREATE
APPEND
By default, how does the 'ORDER BY' clause sort data?
Randomly
In descending order
In ascending order
Alphabetically
Which SQL statement is used to remove rows from a table?
TRUNCATE
REMOVE
DELETE
DROP