SQL Joins Quiz part 3 - Learn DA-DS Course in Hindi

5 minutes

Thanks you have successfully attempted the quiz.

SQL Joins 3

Fill out the form to attempt test.

1 / 10

Which join would you use to combine data from three tables: employees, departments, and salaries, where all employees should be included?

LEFT JOIN

INNER JOIN

RIGHT JOIN

FULL OUTER JOIN

2 / 10

In SQL, which type of join returns rows where there is no match in both tables?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

3 / 10

Which join will return rows where only the columns that match a specified condition in both tables are included?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

4 / 10

Which of the following queries will result in a Cartesian product?

SELECT * FROM table1 LEFT JOIN table2

SELECT * FROM table1 CROSS JOIN table2

SELECT * FROM table1 INNER JOIN table2

SELECT * FROM table1 RIGHT JOIN table2

5 / 10

< 4>A FULL OUTER JOIN will return rows when:< 4>

There is a match in one of the tables

There is no match in either table

A match is found in both tables

All of the above

6 / 10

If you want to return all rows from both tables, matching rows where available, and NULL where there is no match, which type of JOIN do you use?

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

INNER JOIN

7 / 10

Which of the following JOIN types includes rows that have no matching data in the result set?

FULL OUTER JOIN

LEFT JOIN

RIGHT JOIN

INNER JOIN

8 / 10

Which of the following is not a valid SQL JOIN type?

OUTER JOIN

LEFT OUTER JOIN

RIGHT OUTER JOIN

FULL RIGHT JOIN

9 / 10

What type of JOIN would you use to select all customers and their orders, even if the customer has no orders?

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

CROSS JOIN

10 / 10

How would you write a query to join three tables: table1, table2, and table3 with INNER JOIN?

SELECT * FROM table1, table2, table3 WHERE table1.id = table2.id AND table2.id = table3.id

SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id INNER JOIN table3 ON table2.id = table3.id

SELECT * FROM table1 INNER JOIN table2 INNER JOIN table3 ON table1.id = table2.id AND table2.id = table3.id

SELECT * FROM table1, table2, table3 WHERE table1.id = table2.id

Your score is

QUIZ Time Starts !

Which join would you use to combine data from three tables: employees, departments, and salaries, where all employees should be included?

Which join will return rows where only the columns that match a specified condition in both tables are included?

Which of the following queries will result in a Cartesian product?

Which of the following JOIN types includes rows that have no matching data in the result set?

Which of the following is not a valid SQL JOIN type?

What type of JOIN would you use to select all customers and their orders, even if the customer has no orders?

Resourses

Quick Links

Support