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

Skip to content

Programs
Quiz
Tutorials
Mock Questions
Blog

Register For Free

QUIZ Time Starts !

5 minutes

Thanks you have successfully attempted the quiz.

SQL Joins 4

Fill out the form to attempt test.

1 / 10

Which of the following types of JOIN will result in returning only rows from the right table that have no match in the left table?

RIGHT JOIN

LEFT JOIN

INNER JOIN

FULL OUTER JOIN

2 / 10

How would you join three tables with an INNER JOIN on a common key column?

SELECT * FROM table1 INNER JOIN table2 INNER JOIN table3

SELECT * FROM table1 JOIN table2 JOIN table3

SELECT * FROM table1 LEFT JOIN table2 LEFT JOIN table3

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

3 / 10

Which type of JOIN would you use to retrieve all employees, including those who have not yet been assigned to a department?

LEFT JOIN

INNER JOIN

RIGHT JOIN

FULL OUTER JOIN

4 / 10

What would be the result of a CROSS JOIN between a table with 3 rows and another with 5 rows?

8 rows

15 rows

3 rows

5 rows

5 / 10

Which of the following SQL joins will not return any data if there is no match in the joined tables?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

6 / 10

How does a FULL OUTER JOIN behave when there are no matching rows in either table?

Returns NULL values for columns in both tables

Returns rows from the first table only

Returns rows from the second table only

Throws an error

7 / 10

What is the key difference between an INNER JOIN and a LEFT JOIN?

INNER JOIN returns rows from the left table only

LEFT JOIN returns unmatched rows from the left table as NULLs

INNER JOIN returns matched rows only

LEFT JOIN returns rows from the right table

8 / 10

Which of the following joins will return all rows from both tables?

FULL OUTER JOIN

INNER JOIN

LEFT JOIN

RIGHT JOIN

9 / 10

In a SELF JOIN, how do you distinguish between the two instances of the same table?

Use aliases for the table

Use different column names

Use DISTINCT keyword

Use a subquery

10 / 10

What is the result of an INNER JOIN between two tables that contain null values in the join column?

The rows with null values will be excluded

The rows with null values will be included

The query will result in an error

Only matching rows will be included

Your score is

Welcome to DADS Course

Email : info@techpratham.com

Phone (India) : +91-8882178896

WhatsApp : +91-8384036614

Resourses

Student Registration
Dashboard

Quick Links

Contact Us
About US

Support

Refund Policy
Privacy Policy
FAQs