Mastering SQL Joins

Mastering SQL Joins

KG

13 Qs

quiz-placeholder

Similar activities

ôn tập lớp 5

ôn tập lớp 5

2nd Grade

14 Qs

Components of GIS & Levels/Scales

Components of GIS & Levels/Scales

University

12 Qs

Java Collection

Java Collection

12th Grade

10 Qs

HTML TABLE BASIC

HTML TABLE BASIC

10th Grade

10 Qs

Databases

Databases

11th Grade

15 Qs

HTML (3CS)

HTML (3CS)

10th - 11th Grade

10 Qs

EPP WEEK 7

EPP WEEK 7

4th Grade

10 Qs

Working with tables

Working with tables

5th - 12th Grade

10 Qs

Mastering SQL Joins

Mastering SQL Joins

Assessment

Quiz

Computers

KG

Practice Problem

Medium

Created by

Ms. Preeti Gupta

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

13 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of a JOIN in SQL?

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

To update existing records in a table.

To create a new table in the database.

To delete rows from a table.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of JOIN returns all records from the left table and matched records from the right table?

RIGHT JOIN

INNER JOIN

LEFT JOIN

FULL OUTER JOIN

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL JOIN returns all records from both tables, regardless of whether there is a match?

RIGHT JOIN

FULL OUTER JOIN

LEFT JOIN

INNER JOIN

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the difference between INNER JOIN and OUTER JOIN?

OUTER JOIN only returns unmatched rows.

INNER JOIN can include NULL values from both tables.

INNER JOIN returns all rows from both tables.

INNER JOIN returns matched rows; OUTER JOIN returns all rows from one table with matched rows from the other.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you perform a LEFT JOIN in SQL?

SELECT columns FROM table1 LEFT JOIN table2 ON table1.common_column = table2.common_column;

SELECT columns FROM table1 RIGHT JOIN table2 ON table1.common_column = table2.common_column;

SELECT columns FROM table1 JOIN table2 USING (common_column);

SELECT columns FROM table1 INNER JOIN table2 ON table1.common_column = table2.common_column;

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What keyword is used to specify the condition for a JOIN?

FILTER

ON

WITH

WHERE

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does a CROSS JOIN do in SQL?

A CROSS JOIN creates a new table with unique rows from both tables.

A CROSS JOIN only combines rows with matching values.

A CROSS JOIN filters rows based on a condition.

A CROSS JOIN combines every row of one table with every row of another table.

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?