SQL Review

Which SQL keyword is used to sort the results?

• SORT

• ORDER BY

• ARRANGE

• ORGANIZE

Which column can I use to join the Unit table to the Tenant table?

One benefit of a relational database is its ability to

• Store a LOT of unstructured data efficiently

• Store structured data efficiently, and establish relationships between different tables

You might find yourself often using two types of joins... which two are they?

• Inner join

• Outer Join

• Cross join

• Left join

A primary key must be... (select all that apply)

• Unique

• Continuous

• Non-null

• Duplicated

Answer explanation

A primary key must be unique and non-null.

What does the SQL LEFT JOIN keyword do?

• It returns all records from the left table, and the matched records from the right table.

• It returns all records from the right table, and the matched records from the left table.

• It returns records that have matching values in both tables.

• It returns all records from both tables, and fills in NULLs for missing matches.

Which of the following is a characteristic of a primary key?

• A primary key is a foreign key in a database table.

• A primary key can have duplicate values.

• A primary key is a unique identifier for a record in a database table.

tiny.db: How many users in the users table?

• 6

• 7

• 8

• 9

Which statement will execute first?

What's the purpose of a WHERE statement?

• To filter rows based on condition

• To provide instructions for joining two tables

• For filtering rows after aggregation

• To describe the order the data should be sorted in