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