Question 1

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

Accepted Answer

A) comma (,) 
B) ​period (.) 
C) percent sign (%) 
D) ​asterisk (*)

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) dependent 
B) ​no 
C) independent 
D) ​duplicate

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

You can join three tables together but not four tables.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

The answer of There are three set operations: union,intersection,difference.Define each...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The answer of The subquery that involves a table listed...

Question 9

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

Accepted Answer

A) inner outer 
B) ​correlated 
C) reverse 
D) ​parameter

Question 10

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

Accepted Answer

The answer of What steps should you take to construct...

Question 11

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

Accepted Answer

The answer of The ____________________ of two tables is a...

Question 12

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

Accepted Answer

The answer of Joining a table to itself is called...

Question 13

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

Accepted Answer

The answer of What steps should you take to construct...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

There is only one approach to joining tables.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

The answer of When tables are listed in the FROM...

Question 17

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

Accepted Answer

The answer of If the SQL implementation truly supports the...

Question 18

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

Accepted Answer

A) union 
B) ​minus 
C) difference 
D) ​intersect

Question 19

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

Accepted Answer

A) UNION 
B) ​INTERSECT 
C) MINUS 
D) ​ALL

Question 20

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

Accepted Answer

A) True 
 B)False

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.

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.

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

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

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

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?

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.