SQL Session 2 Quiz

SQL Session 2 Quiz

Professional Development

10 Qs

quiz-placeholder

Similar activities

Python-quiz2

Python-quiz2

University - Professional Development

11 Qs

[BD] 02.1 - Modelo Relacional - Intuição, Notação, Domínios

[BD] 02.1 - Modelo Relacional - Intuição, Notação, Domínios

University - Professional Development

12 Qs

ER Model

ER Model

Professional Development

10 Qs

Software Security

Software Security

University - Professional Development

10 Qs

C Programming

C Programming

Professional Development

10 Qs

Advance MS Excel Tips and Tricks

Advance MS Excel Tips and Tricks

Professional Development

10 Qs

Interesting Bird Facts

Interesting Bird Facts

KG - Professional Development

11 Qs

Streams

Streams

Professional Development

10 Qs

SQL Session 2 Quiz

SQL Session 2 Quiz

Assessment

Quiz

Computers

Professional Development

Practice Problem

Medium

Created by

Ammar Taimoori

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...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does INNER JOIN in SQL do?

  • Retrieves all rows from both tables

Retrieves only matching rows from both tables

Retrieves only rows from the left table

Retrieves only rows from the right table

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Only single WHEN statement can be included in CASE statement

True

False

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is the default join type in SQL?

LEFT JOIN

RIGHT JOIN

INNER JOIN

OUTER JOIN

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following JOINs returns all rows from the left table and matching rows from the right table?

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In a LEFT JOIN, what happens if there is no match in the right table?

No rows are returned

All rows from the right table are returned with NULL values for columns from the left table

All rows from the left table are returned with NULL values for columns from the right table

An error is thrown

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How is the CASE statement used in a SELECT clause?

To filter rows in the WHERE clause

To define conditions and return values based on them

To sort the result set

To join multiple tables

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?