SQL Joins & Functions Quiz

Last Updated :
Discuss
Comments

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.

Take a part in the ongoing discussion