DATABASE CH 4 QUIZ

When you code a union that combines two result sets, which of the following is not true?

The result sets must be derived from different tables.

When you need to code multiple conditions in a join, it's best to

code only join conditions in the ON clause

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

foreign

When you code a union with the INTERSECT keyword to combine two result sets, the union

includes only rows that occur in both result sets

Code example 4-1 SELECT VendorName AS Vendor, InvoiceDate AS Date FROM Vendors AS v JOIN Invoices AS i ON v.VendorID = i.VendorID; (Refer to code example 4-1.) This type of join is called a/an

inner

Which of the following is not a reason for using the explicit syntax instead of the implicit syntax for inner joins? The explicit syntax

lets you combine the join and seearch conditions

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

rows in both tables that don't satisfy the join condition

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

rows in the second table

In a join, column names only need to be qualified where?

when the same names are used in both tables

If you assign a correlation name to one table in a join,

you have to use that name for the table in the query