Joins and functions are essential components of SQL, enabling you to combine data from multiple tables and perform advanced data manipulations efficiently. In this quiz, you'll delve into various types of SQL joins such as INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN, as well as important SQL functions like aggregate functions (SUM, AVG, COUNT, etc.) and scalar functions (UPPER, LOWER, SUBSTRING, etc.).
Question 1
Which SQL JOIN type returns all rows from both tables, joining records where available?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Question 2
What does the SQL function "CONCAT()" do?
Adds two numbers together
Concatenates two or more strings
Converts a string to uppercase
Returns the length of a string
Question 3
Which SQL JOIN type returns only the rows that have matching values in both tables?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Question 4
What does the SQL function "LOWER()" do?
Adds two numbers together
Concatenates two or more strings
Converts a string to lowercase
Returns the length of a string
Question 5
Which SQL JOIN type returns all rows from the left table and matching rows from the right table?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Question 6
What does the SQL function "UPPER()" do?
Adds two numbers together
Concatenates two or more strings
Converts a string to uppercase
Returns the length of a string
Question 7
Which SQL JOIN type returns all rows from the right table and matching rows from the left table?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Question 8
What does the SQL function "LENGTH()" do?
Adds two numbers together
Concatenates two or more strings
Converts a string to lowercase
Returns the length of a string
Question 9
Which SQL JOIN type returns all rows when there is a match in either the left or right table?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Question 10
What does the SQL function "ROUND()" do?
Rounds a number to the nearest integer
Concatenates two or more strings
Converts a string to lowercase
Returns the length of a string
There are 10 questions to complete.