Martian Database and SQL Joins Quiz

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

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

• Martian

• Visitor

• Inventory

• Supply

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

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

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

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

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

What is the purpose of the 'Inventory Report'?

• To list all visitors without a host

• To list all Martians and their supervisors

• To list all bases and their inventory

• To list all supplies available at Base #1

What type of JOIN is used in the 'No Host Report' to find visitors without a host?

• LEFT JOIN

• FULL JOIN

• RIGHT JOIN

• INNER JOIN

How can null quantities be replaced with 0 in the 'Inventory Report'?

• By using a subquery

• By using a RIGHT JOIN

• By using a database function

• By using a FULL JOIN