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

Programs
Quiz
Tutorials
Mock Questions
Blog

QUIZ Time Starts !

5 minutes

Thanks you have successfully attempted the quiz.

SQL Joins 2

Fill out the form to attempt test.

1 / 10

What is the main difference between a FULL OUTER JOIN and a LEFT JOIN?

FULL OUTER JOIN returns only matched rows

LEFT JOIN returns all rows from the left table

FULL OUTER JOIN returns all rows from both tables, unmatched rows as NULL

LEFT JOIN only returns rows from the left table

2 / 10

When performing a JOIN operation, the columns used to connect the tables should:

Have the same name

Contain the same data type

Be indexed

All of the above

3 / 10

Which type of JOIN should you use to get the total sales by employee, including employees who have no sales?

LEFT JOIN

INNER JOIN

RIGHT JOIN

CROSS JOIN

4 / 10

How do you prevent duplicate rows when performing a JOIN operation?

Use the DISTINCT keyword

Use GROUP BY clause

Use the HAVING clause

Use a subquery to filter results

5 / 10

Which type of join will return a Cartesian product?

LEFT JOIN

INNER JOIN

FULL OUTER JOIN

CROSS JOIN

6 / 10

Which of the following joins will not return any data if there are no matching rows in both tables?

RIGHT JOIN

LEFT JOIN

FULL OUTER JOIN

INNER JOIN

7 / 10

In a RIGHT JOIN, which rows will be included in the result?

Rows from the left table and NULLs for the right table columns

All rows from the right table, and matching rows from the left table

Only rows with matching data from both tables

All rows from both tables, regardless of matching

8 / 10

What is the result of an INNER JOIN with two tables that do not have matching rows?

No rows are returned

All rows from both tables are returned

An error is thrown

Only rows from the first table are returned

9 / 10

Which join is used to return rows when there is no matching record in both tables?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

10 / 10

What happens when a LEFT JOIN does not have a matching row in the right table?

NULL values are returned for the right table columns

The row is not returned at all

An error is raised

The left table is ignored

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