QUIZ Time Starts !

5 minutes

Thanks you have successfully attempted the quiz.


SQL Joins 1

Fill out the form to attempt test.

 

 

 

1 / 10

What happens if you perform a LEFT JOIN and there are no matching rows in the right table?

2 / 10

Which of the following is the correct syntax for an INNER JOIN?

3 / 10

Which type of JOIN would you use to combine all rows from multiple tables, even if there are no matches?

4 / 10

In a SELF JOIN, how are the tables represented?

5 / 10

How many rows would result from a CROSS JOIN between a table with 5 rows and another with 3 rows?

6 / 10

Which of the following joins would include all rows from the right table and matching rows from the left table?

7 / 10

< 4>A CROSS JOIN results in:< 4>

8 / 10

What is the purpose of a FULL OUTER JOIN?

9 / 10

What is the main difference between a LEFT JOIN and a RIGHT JOIN?

10 / 10

What is the result of an INNER JOIN between two tables with no matching rows?

Your score is