ITMT 1403 Quiz 04: Joins

When using the implicit join syntax, the relationship or condition for joining rows from two tables is written in the ON clause. True/False

False

When writing an outer join, the keyword OUTER must be included. True/False

False

If the keyword INNER is omitted from the join clause of a query, SQL Server will assume that it should be an inner join. True/False

True

Tables in the implicit join syntax (i.e. specifying neither INNER nor OUTER keywords) are listed in the FROM clause and separated by a comma. True/False

True

Which type of join would NOT show nulls as a match? a. INNER b. RIGHT OUTER c. FULL OUTER d. LEFT OUTER

a. INNER

Which of the following is a reason for using the explicit syntax instead of the implicit syntax for joins? The explicit syntax: a. is easier to read and understand b. is the only syntax supported by SQL Server c. combines the join and filtering conditions in the ON clause d. is older and has been used in all versions of SQL Server

a. is easier to read and understand

Code example 4-2: SELECT VendorName, InvoiceNumber FROM Invoices LEFT JOIN Vendors ON Invoices.VendorID = Vendors.VendorID Which of the following is true with respect to code example 4-2? a. none of the above b. The query's result set will always include information from all VendorName values in the Vendors table. c. The query results in an error because the keyword OUTER was not included. d. The query results in an error because the keyword INNER was not included.

b. The query's result set will always include information from all VendorName values in the Vendors table.

Review the statement below. The statement fails to execute because: SELECT Faculty.FacultyID, LastName, FirstName, Salary, DepartmentID FROM Faculty JOIN Classes WHERE Faculty.FacultyID = Classes.FacultyID a. The keyword INNER is missing. b. Table names were not included. c. An explicit JOIN, like the one in this statement, must use an ON clause to indicate the relationship between the tables, not a WHERE clause. d. A query that includes a JOIN cannot include a WHERE clause.

c. An explicit JOIN, like the one in this statement, must use an ON clause to indicate the relationship between the tables, not a WHERE clause.

Code example 4-1: SELECT VendorName, InvoiceNumber FROM Invoices JOIN Vendors ON VendorID = VendorID Which of the following is true with respect to code example 4-1? a. The query results in an error because the keyword OUTER was not included. b. The query results in an error because the keyword INNER was not included. c. none of the above d. The query generates an error because the table names were not included in the ON clause.

d. The query generates an error because the table names were not included in the ON clause.

A full outer join includes rows that satisfy the join condition, plus a. none of the above are true b. rows in the right table that don't satisfy the join condition c. rows in the left table that don't satisfy the join condition d. all of the above are true

d. all of the above are true