
Martian Database and SQL Joins Quiz

Interactive Video
•
Computers
•
9th - 10th Grade
•
Hard
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
Similar Resources on Wayground
6 questions
CLEAN : In Paris, a restaurateur serves Beaujolais Nouveau to take away to help people "forget" the crisis

Interactive video
•
9th - 10th Grade
6 questions
CLEAN : Protesters clash with police at Turkey mine blast site (part 2)

Interactive video
•
9th - 10th Grade
6 questions
NASA's InSight Mission Quiz

Interactive video
•
9th - 10th Grade
11 questions
Inventory System in Game Development

Interactive video
•
9th - 10th Grade
11 questions
SQL Joins and Future Concepts Quiz

Interactive video
•
9th - 10th Grade
6 questions
CLEAN : France summons milk producers following salmonella scandal

Interactive video
•
9th - 10th Grade
6 questions
INDONESIA: ACEH: VILLAGERS FLEE AS MILITARY CONSOLIDATES POSITION

Interactive video
•
9th - 10th Grade
11 questions
Mars Exploration and History Quiz

Interactive video
•
9th - 10th Grade
Popular Resources on Wayground
55 questions
CHS Student Handbook 25-26

Quiz
•
9th Grade
10 questions
Afterschool Activities & Sports

Quiz
•
6th - 8th Grade
15 questions
PRIDE

Quiz
•
6th - 8th Grade
15 questions
Cool Tool:Chromebook

Quiz
•
6th - 8th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
20 questions
Bullying

Quiz
•
7th Grade
18 questions
7SS - 30a - Budgeting

Quiz
•
6th - 8th Grade