Chapter 4 Quiz

Temporary names assigned to tables are called

Correlation names

Self-joins include the _____ keyword to eliminate duplicate rows.

DISTINCT

The _____ operator is used to exclude rows that are listed in both tables.

EXCEPT

SQL server only allows you to join 2 tables

False

You can not combine inner and outer joins

False

The _____ operator is used to only include rows that are listed in both tables.

INTERSECT

A join condition can contain 2 or more conditions connected by AND or OR.

True

By default, a union will eliminate duplicate rows.

True

EXCEPT, INTERSECT, and UNION operators are considered set operators because they work with result sets.

True

The INNER AND OUTER keywords are optional when coding a join.

True

Which is the correct way to code a qualified column name

Vendors.VendorID

When tables are joined by columns that do not have a defined relationship in the database, it is called an

ad hoc relationship

An ___ joins each row from the first table with each row from the second table

cross join

An ___ returns all rows that meet the join condition PLUS all rows from both tables in the SELECT statement

full outer join

An ___ returns only those rows that satisfy the join condition

inner join

A ___ lets you combine columns from two or more tables into a result set

join

The ___ indicates how the two tables should be compared

join condition

An ___ returns all rows that meet the join condition PLUS all rows from the left table in the SELECT statement

left outer join

An ___ returns all rows that satisfy the join condition AND all unmatched rows in one or both tables

outer join

Use a ____ when two columns in a join condition have the same name.

qualified column name

When joining tables from databases on different servers, you must first add a _____ to the current database server you are working on

reference server

An ___ returns all rows that meet the join condition PLUS all rows from the right table in the SELECT statement

right outer join

An ___ joins a table with itself

self join

To join tables from different databases, you must use a _____ when listing the tables in the SELECT statement

table alias

An ___ combines the result sets of two or more SELECT statements into one result set

union