Skip to content

Quiz on Joins in SQL

Quiz on Joins in SQL

Time limit: 0

Quiz Summary

0 of 10 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 10 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

Review / Skip
Answered
Correct
Incorrect

Question 1 of 10

1. Question

What is the main purpose of using a JOIN in SQL?

To delete data from two tables
Correct Incorrect Correct answer

To insert data into a table
Correct Incorrect Correct answer

To combine rows from two or more tables
Correct Incorrect Correct answer

To create a new database
Correct Incorrect Correct answer

Correct

Incorrect
Question 2 of 10

2. Question

Which JOIN returns only the matching rows from both tables?

LEFT JOIN
Correct Incorrect Correct answer

RIGHT JOIN
Correct Incorrect Correct answer

FULL JOIN
Correct Incorrect Correct answer

INNER JOIN
Correct Incorrect Correct answer

Correct

Incorrect
Question 3 of 10

3. Question

Which JOIN returns all rows from the left table, and matched rows from the right table?

FULL JOIN
Correct Incorrect Correct answer

RIGHT JOIN
Correct Incorrect Correct answer

LEFT JOIN
Correct Incorrect Correct answer

CROSS JOIN
Correct Incorrect Correct answer

Correct

Incorrect
Question 4 of 10

4. Question

What does a RIGHT JOIN return?

Only matching rows
Correct Incorrect Correct answer

All rows from the left table
Correct Incorrect Correct answer

All rows from the right table and matched ones from the left
Correct Incorrect Correct answer

Duplicate rows
Correct Incorrect Correct answer

Correct

Incorrect
Question 5 of 10

5. Question

Which JOIN returns all records when there is a match in either left or right table?

INNER JOIN
Correct Incorrect Correct answer

LEFT JOIN
Correct Incorrect Correct answer

RIGHT JOIN
Correct Incorrect Correct answer

FULL JOIN
Correct Incorrect Correct answer

Correct

Incorrect
Question 6 of 10

6. Question

What is required in the tables to perform a JOIN?

Same number of rows
Correct Incorrect Correct answer

A common column
Correct Incorrect Correct answer

Identical table names
Correct Incorrect Correct answer

No primary key
Correct Incorrect Correct answer

Correct

Incorrect
Question 7 of 10

7. Question

Which JOIN produces a result that is the combination of every row from both tables?

CROSS JOIN
Correct Incorrect Correct answer

INNER JOIN
Correct Incorrect Correct answer

LEFT JOIN
Correct Incorrect Correct answer

FULL JOIN
Correct Incorrect Correct answer

Correct

Incorrect
Question 8 of 10

8. Question

If no match is found in a LEFT JOIN, what is returned from the right table?

Blank rows
Correct Incorrect Correct answer

Zeros
Correct Incorrect Correct answer

NULLs
Correct Incorrect Correct answer

Default values
Correct Incorrect Correct answer

Correct

Incorrect
Question 9 of 10

9. Question

Which JOIN is typically used to find unmatched rows in one table compared to another?

INNER JOIN
Correct Incorrect Correct answer

RIGHT JOIN
Correct Incorrect Correct answer

LEFT JOIN with WHERE condition
Correct Incorrect Correct answer

FULL JOIN only
Correct Incorrect Correct answer

Correct

Incorrect
Question 10 of 10

10. Question

In which clause do we usually specify the condition for the JOIN?

SELECT
Correct Incorrect Correct answer

ON
Correct Incorrect Correct answer

WHERE
Correct Incorrect Correct answer

HAVING
Correct Incorrect Correct answer

Correct

Incorrect

Fill the form to proceed
Upskill & get ready for AI-era

Please leave this field empty.

Δ

Our executives will contact you shortly

Have Questions?
Talk directly to the Instructor

Please leave this field empty.

Δ

Our executives will arrange a call with the Instructor shortly

talk to the instructor

Career Counselling

Please leave this field empty.

Δ

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Signup / Login with Google

Signup / Login with X

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account