275 SQL

Question 1

A full outer join includes rows that satisfy the join condition, plus

Answer 1

Rows in both tables that don’t satisfy the join condition

Question 2

When applying multiple join conditions (i.e. more than one condition which must be true) to an inner join in explicit syntax, the extra conditions can be applied:

Answer 2

In the WHERE clause and/or the ON section

Question 3

The basic format for an inner join using explicit syntax is:

Answer 3

SELECT … FROM table1 JOIN table2 ON join_condition

Question 4

In most cases, the join condition of an inner join compares the primary key of one table to the ____________________ key of another table.

Answer 4

foreign

Question 5

When performing an inner join using implicit join syntax, you should place the join condition(s):

Answer 5

In the WHERE clause

Question 6

In a cross join, all of the rows in the first table are joined with…

Answer 6

all rows in the second table

Question 7

SELECT v.VendorName AS Vendor, i.InvDate AS Date
FROM Vendors v
JOIN Invoices i ON v.VendorID = i.VendorID;

In this example, “i” is known as…

Answer 7

a table alias

Question 8

Correlation names (aka table aliases) can be specified with the option AS keyword to temporarily re-name a table within the scope of the query. When/how is the best practice for using correlation names?

Answer 8

When they simplify or clarify the query.

Question 9

Queries combined with UNION must use the same tables to avoid an error.

Answer 9

False

Question 10

SELECT VendorName, InvoiceNumber
FROM Invoices i
RIGHT JOIN Vendors v ON i.VendorID = v.VendorID;

If the RIGHT keyword is replaced with the LEFT keyword, the query…

Answer 10

keeps unmatched rows in the Invoices tab