Martian Database and SQL Joins Quiz

Martian Database and SQL Joins Quiz

Assessment

Interactive Video

Computers

9th - 10th Grade

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

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?