Martian Database and SQL Joins Quiz

Martian Database and SQL Joins Quiz

Assessment

Interactive Video

Computers

9th - 10th Grade

Practice Problem

Hard

Created by

Jennifer Brown

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What are the four types of SQL Joins introduced in the video?

FULL, PARTIAL, INNER, OUTER

LEFT, RIGHT, CROSS, NATURAL

INNER, OUTER, CROSS, SELF

INNER, LEFT, RIGHT, FULL

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which table in the Martian database keeps track of the supplies in storage at each base?

Martian

Visitor

Inventory

Supply

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using an alias in SQL queries?

To create a backup of the table

To avoid excessive typing and simplify the query

To increase the complexity of the query

To change the data type of a column

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In a LEFT JOIN, what happens to the rows from the left table that do not have a match in the right table?

They are included with null values for the right table columns

They are excluded from the result

They are deleted

They are duplicated

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a 'Self Join' in SQL?

Joining a table with itself

Joining tables with different data types

Joining tables without a common column

Joining two different databases

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the main goal of the 'Visitor Report'?

To list all supplies in the inventory

To list all Martians and their bases

To list all bases and their locations

To list all visitors and their hosts

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the 'Super Report', what does a null value in the supervisor's name indicate?

The Martian is in training

The Martian is a visitor

The Martian is the head of their base

The Martian is unassigned

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?

Similar Resources on Wayground