Skip to content

Quiz on SQL Joins

Quiz on SQL Joins

Time limit: 0

Quiz Summary

0 of 4 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 4 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 4

1. Question

What does an INNER JOIN do in SQL?

Combines rows from two tables, including unmatched rows
Correct Incorrect Correct answer

Combines only matching rows from two tables
Correct Incorrect Correct answer

Deletes duplicate rows from a result set
Correct Incorrect Correct answer

Filters rows based on conditions
Correct Incorrect Correct answer

Correct

Incorrect
Question 2 of 4

2. Question

What is the purpose of a FULL OUTER JOIN?

Combines only matching rows from two tables
Correct Incorrect Correct answer

Combines rows from two tables, including unmatched rows from both tables
Correct Incorrect Correct answer

Deletes duplicate rows from the result set
Correct Incorrect Correct answer

Filters rows based on conditions
Correct Incorrect Correct answer

Correct

Incorrect
Question 3 of 4

3. Question

Which join would you use to return the Cartesian product of two tables?

INNER JOIN
Correct Incorrect Correct answer

CROSS JOIN
Correct Incorrect Correct answer

OUTER JOIN
Correct Incorrect Correct answer

SELF JOIN
Correct Incorrect Correct answer

Correct

Incorrect
Question 4 of 4

4. Question

What does a SELF JOIN do?

Joins a table to itself
Correct Incorrect Correct answer

Combines rows from two different databases
Correct Incorrect Correct answer

Deletes rows based on matching conditions
Correct Incorrect Correct answer

Filters duplicate rows in a table
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