SQL Joins & Functions Quiz

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