Exam 5: Multiple-Table Queries

To qualify a column name,precede the name of the column with the name of the table,followed by a(n)____.​

For two tables to be union compatible,the columns of the two tables must be identical.

For an SQL implementation to truly support the union operation,it must remove ____ rows automatically.​

To produce the same results as the INTERSECT operator,use the BETWEEN operator and a subquery.

You can join three tables together but not four tables.

There are three set operations: union,intersection,difference.Define each of these operations.Which are supported by Oracle?​

You can use the EXISTS operator to retrieve data from more than one table.

The subquery that involves a table listed in the outer query is called a(n)____________________ subquery.​

When a subquery involves a table listed in the outer query,the subquery is called a(n)____ subquery.​

What steps should you take to construct the SQL command to join (relate)tables?​

The ____________________ of two tables is a table containing all rows that are in both tables.​

Joining a table to itself is called a(n)____________________.​

What steps should you take to construct a detailed query in a step-by-step fashion?​

It is permissible to qualify all column names in a query.

There is only one approach to joining tables.

When tables are listed in the FROM clause,you can give each table a(n)____________________,or an alternate name.​

If the SQL implementation truly supports the union operation,it will remove any duplicate ____________________ automatically.​

Two tables are ____ compatible if they have the same number of columns and if their corresponding columns have identical data types and lengths.​

Oracle and SQL Server support the ____ operator but Microsoft Access does not.​

In a nested query,the outer query is evaluated first.