Which SQL function would you use to combine the first and last names from two different columns into a single column?
MERGE()
CONCAT()
COMBINE()
JOIN()
What does SQL stand for?
Standard Query Logic
Structured Query Language
System Query Language
Simple Query Language
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.
IN compares values, while EXISTS checks for the presence of rows.
There is no difference; they are interchangeable.
IN checks for existence in a list, while EXISTS checks for existence in a table.
Which of the following is NOT a valid SQL data type?
FLOAT
BOOLEAN
INTEGER
VARCHAR
Which SQL statement is used to add new rows into a table?
INSERT
ADD
APPEND
CREATE
What is the purpose of the COUNT() function in SQL?
COUNT()
Returns the average value of a column
Finds the minimum value in a column
Calculates the sum of values in a column
Returns the number of rows in a table
Which aggregate function would you use to find the highest value in a column?
MIN()
SUM()
MAX()
AVG()
What is the purpose of the 'OR' operator in a SQL WHERE clause?
It limits the number of rows returned.
It negates a condition.
It selects rows where at least one condition is true.
It selects rows where both conditions are true.
Which SQL clause is used to sort the result set?
ORDER
SORT
ORDER BY
SORT BY
How would you sort results in descending order by the 'date_created' column?
ORDER BY date_created DESC
ORDER BY date_created ASC
SORT BY date_created DESC
SORT BY date_created ASC