Question 1

Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?

Accepted Answer

A)  NATURAL JOIN 
B)  JOIN...ON 
C)  JOIN...USING 
D)  none of the above 
A)  NATURAL JOIN 
B)  JOIN...ON 
C)  JOIN...USING 
D)  none of the above

Question 2

Which of the following set operators will display only the unique results of the combined SQL statements?

Accepted Answer

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

Question 3

Structure of the PROMOTION table
   
Structure of the BOOKS table
   
Structure of the ORDERITEMS table
-How many joining conditions will be required in an SQL statement that is used to determine the gift that corresponds to each book in the BOOKS table?

Accepted Answer

A)  4 
B)  3 
C)  2 
D)  1 
A)  4 
B)  3 
C)  2 
D)  1

Question 4

Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?

Accepted Answer

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

Question 5

A(n) ____ is used to combine the results of two queries.

Accepted Answer

A)  concatenation operator 
B)  set operator 
C)  comparison operator 
D)  logical operator 
A)  concatenation operator 
B)  set operator 
C)  comparison operator 
D)  logical operator

Question 6

A full outer join cannot be created in the ____________________ clause.

Accepted Answer

The answer of A full outer join cannot be created...

Question 7

A(n) ____________________ outer join is necessary when you need rows returned from either table that do not have a matching record in the other table.

Accepted Answer

The answer of A(n) ____________________ outer join is necessary when...

Question 8

The JOIN keyword is included in which of the following clauses?

Accepted Answer

A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY 
A)  SELECT 
B)  FROM 
C)  WHERE 
D)  ORDER BY

Question 9

A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 10

Contents of the PROMOTION table
   
Structure of the BOOKS table
-Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS?

Accepted Answer

A)  SELECT gift FROM promotion
WHERE gift = minretail; 
B)  SELECT gift FROM promotion, books
WHERE retail >= minretail AND title = 'SHORTEST POEMS'; 
C)  SELECT gift FROM promotion, books
WHERE retail BETWEEN minretail AND maxretail
AND title = 'SHORTEST POEMS'; 
D)  none of the above 
A)  SELECT gift FROM promotion
WHERE gift = minretail; 
B)  SELECT gift FROM promotion, books
WHERE retail >= minretail AND title = 'SHORTEST POEMS'; 
C)  SELECT gift FROM promotion, books
WHERE retail BETWEEN minretail AND maxretail
AND title = 'SHORTEST POEMS'; 
D)  none of the above

Question 11

Explain the difference between an inner join and an outer join.

Accepted Answer

An inner join only returns rows from one

Question 12

Explain the purpose of a set operator.

Accepted Answer

A set operator is us

Question 13

Structure of the CUSTOMERS table
   
Structure of the ORDERS table
   
Structure of the ORDERITEMS table
   
Structure of the BOOKS table
-To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?

Accepted Answer

A)  4 
B)  3 
C)  2 
D)  1 
A)  4 
B)  3 
C)  2 
D)  1

Question 14

An inequality join refers to a join that is used to link a table to a copy of itself.

Accepted Answer

A) True 
 B)False

Question 15

The most common type of join is an equijoin, which joins two or more tables together based upon the tables having equivalent data values in a common column.

Accepted Answer

A) True 
 B)False

Question 16

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?

Accepted Answer

A)  NATURAL JOIN 
B)  JOIN...ON 
C)  LEFT OUTER JOIN 
D)  FULL OUTER JOIN 
A)  NATURAL JOIN 
B)  JOIN...ON 
C)  LEFT OUTER JOIN 
D)  FULL OUTER JOIN

Question 17

If you are joining two tables in a SELECT statement, $\underline { \text { three } }$ joining conditions will be required. _________________________

Accepted Answer

A) True 
 B)False

Question 18

When combining the results of two $\underline { \text { SELECT } }$statements with the UNION keyword, duplicate rows are suppressed in the results. _________________________

Accepted Answer

A) True 
 B)False

Question 19

A table alias is assigned to a table in the WHERE clause.

Accepted Answer

A) True 
 B)False

Question 20

When combining the results of two SELECT statements with the $\underline {\text { MINUS } }$ keyword, duplicate rows are suppressed in the results. _________________________

Accepted Answer

A) True 
 B)False

Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?

Which of the following set operators will display only the unique results of the combined SQL statements?

Structure of the PROMOTION table Structure of the BOOKS table Structure of the ORDERITEMS table -How many joining conditions will be required in an SQL statement that is used to determine the gift that corresponds to each book in the BOOKS table?

Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?

A(n) ____ is used to combine the results of two queries.

A full outer join cannot be created in the ____________________ clause.

A(n) ____________________ outer join is necessary when you need rows returned from either table that do not have a matching record in the other table.

The JOIN keyword is included in which of the following clauses?

A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.

Contents of the PROMOTION table Structure of the BOOKS table -Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS?

Explain the difference between an inner join and an outer join.

Explain the purpose of a set operator.

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?

An inequality join refers to a join that is used to link a table to a copy of itself.

The most common type of join is an equijoin, which joins two or more tables together based upon the tables having equivalent data values in a common column.

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?

If you are joining two tables in a SELECT statement, $\underline { \text { three } }$ joining conditions will be required. _________________________

When combining the results of two $\underline { \text { SELECT } }$ statements with the UNION keyword, duplicate rows are suppressed in the results. _________________________

A table alias is assigned to a table in the WHERE clause.

When combining the results of two SELECT statements with the $\underline {\text { MINUS } }$ keyword, duplicate rows are suppressed in the results. _________________________

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 9: Joining Data From Multiple Tables

Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?

Which of the following set operators will display only the unique results of the combined SQL statements?

Structure of the PROMOTION table Structure of the BOOKS table Structure of the ORDERITEMS table -How many joining conditions will be required in an SQL statement that is used to determine the gift that corresponds to each book in the BOOKS table?

Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?

A(n) ____ is used to combine the results of two queries.

A full outer join cannot be created in the ____________________ clause.

A(n) ____________________ outer join is necessary when you need rows returned from either table that do not have a matching record in the other table.

The JOIN keyword is included in which of the following clauses?

A full outer join can be created by including an outer join operator on both sides of the linking condition stated in the WHERE clause.

Contents of the PROMOTION table Structure of the BOOKS table -Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS?

Explain the difference between an inner join and an outer join.

Explain the purpose of a set operator.

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?

An inequality join refers to a join that is used to link a table to a copy of itself.

The most common type of join is an equijoin, which joins two or more tables together based upon the tables having equivalent data values in a common column.

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?

If you are joining two tables in a SELECT statement, three ‾\underline { \text { three } } three ​ joining conditions will be required. _________________________

When combining the results of two SELECT ‾\underline { \text { SELECT } } SELECT ​ statements with the UNION keyword, duplicate rows are suppressed in the results. _________________________

A table alias is assigned to a table in the WHERE clause.

When combining the results of two SELECT statements with the MINUS ‾\underline {\text { MINUS } } MINUS ​ keyword, duplicate rows are suppressed in the results. _________________________

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

If you are joining two tables in a SELECT statement, $\underline { \text { three } }$ joining conditions will be required. _________________________

When combining the results of two $\underline { \text { SELECT } }$ statements with the UNION keyword, duplicate rows are suppressed in the results. _________________________

When combining the results of two SELECT statements with the $\underline {\text { MINUS } }$ keyword, duplicate rows are suppressed in the results. _________________________