SQL JOIN Quiz

SQL JOIN Quiz

University

24 Qs

quiz-placeholder

Similar activities

KHỐI 10- AI TRẠNG-I'M TRẠNG - VÒNG THI HỘI

KHỐI 10- AI TRẠNG-I'M TRẠNG - VÒNG THI HỘI

10th Grade - University

20 Qs

Division of Polynomials (Long Division/Synthetic Division)

Division of Polynomials (Long Division/Synthetic Division)

7th Grade - Professional Development

20 Qs

Dr Vj

Dr Vj

University

20 Qs

Tell me’ questions Driving Test

Tell me’ questions Driving Test

11th Grade - Professional Development

19 Qs

DBMS mcq -2

DBMS mcq -2

University

20 Qs

Twilight Trivia Part 2

Twilight Trivia Part 2

University

20 Qs

QUIZALMANIA

QUIZALMANIA

University

20 Qs

Round 01

Round 01

5th Grade - Professional Development

20 Qs

SQL JOIN Quiz

SQL JOIN Quiz

Assessment

Quiz

Other

University

Practice Problem

Medium

Created by

Lythia Amoakon

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

24 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is the purpose of a JOIN in SQL?

To delete rows from multiple tables

To combine rows from two or more tables based on a related column

To add new columns to a table

To update data in a single table

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which of the following types of JOIN returns only matching rows from both tables?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

3.

DRAG AND DROP QUESTION

1 min • 1 pt

A LEFT JOIN will return rows from the left table with (a)   for non-matching rows in the right table.

Only matching rows
Rows from the left table with NULLs
Only rows with NULL values
An error

4.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Media Image

SELECT e.Name, d.DepartmentName

FROM Employees e

LEFT JOIN Departments d

ON e.DepartmentID = d.DepartmentID;

What is the result of the query?

Alice - HR; Bob - NULL; Charlie - IT

Alice - HR; Charlie - IT

NULL - NULL

Alice - HR; Bob - IT; Charlie - IT

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Which JOIN should you use to include unmatched rows from both tables?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is the result of using an INNER JOIN with no matching records between tables?

NULL rows

No rows returned

All rows from both tables

Rows from the left table only

7.

DRAG AND DROP QUESTION

1 min • 1 pt

(a)   will produce the same result as reversing the roles of the two tables in a LEFT JOIN.

INNER JOIN
FULL OUTER JOIN
RIGHT JOIN
CROSS JOIN

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?