Question 1

A(n) ____________________ join is required when a table must be joined to itself.

Accepted Answer

self
self-

Question 2

Joins are classified as ____________________ joins if the results can only contain the rows that had matching values in each table, rather than rows being matched with NULL values.

Accepted Answer

inner

Question 3

The outer join operator is placed on the side of the joining condition that has ____________________ rows.

Accepted Answer

deficient
missing
NULL

Question 4

Give the appropriate situation in which to use each of the following join keywords: NATURAL JOIN, JOIN...USING, and JOIN...ON.

Accepted Answer

The NATURAL JOIN keywords create a join

Question 5

Data stored in separate tables can be reconstructed through the use of ____________________.

Accepted Answer

joins
join

Question 6

Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.

Accepted Answer

A) True 
 B)False

Question 7

The INTERSECT set operator only displays the rows returned by both queries.

Accepted Answer

A) True 
 B)False

Question 8

A(n) $\underline {\text { non-equality }}$ join is used when there are no equivalent rows of data in the tables that are being joined. _________________________

Accepted Answer

A) True 
 B)False

Question 9

In Oracle11g, tables can be linked through which clause(s)?

Accepted Answer

A)  SELECT 
B)  FROM 
C)  WHERE 
D)  both b and c 
A)  SELECT 
B)  FROM 
C)  WHERE 
D)  both b and c

Question 10

The ____________________ operator is used to create an outer join in the WHERE clause of a SQL statement.

Accepted Answer

The answer of The ____________________ operator is used to create...

Question 11

Data stored in multiple tables can be combined through the use of an ORDER BY clause.

Accepted Answer

A) True 
 B)False

Question 12

Structure of the ORDERS table
   
Structure of the CUSTOMERS table
-Which of the following is a valid SQL statement?

Accepted Answer

A)  SELECT 
B)  SELECT * FROM customers JOIN orders ON (customer#); 
C)  SELECT c.customer#, order#, orderdate, shipdate FROM customers c, orders c
WHERE c.customer# = o.customer#; 
D)  both b and c 
A)  SELECT 
B)  SELECT * FROM customers JOIN orders ON (customer#); 
C)  SELECT c.customer#, order#, orderdate, shipdate FROM customers c, orders c
WHERE c.customer# = o.customer#; 
D)  both b and c

Question 13

Using the JOIN...____________________ keywords to join two tables requires that a condition be specified to indicate how the tables are related.

Accepted Answer

The answer of Using the JOIN...____________________ keywords to join two...

Question 14

The $\underline {\text { JOIN...USING } }$ keywords are used to join two tables that do not have a commonly named and defined column. _________________________

Accepted Answer

A) True 
 B)False

Question 15

The ____________________ set operator is used to display the rows returned by both SELECT statements.

Accepted Answer

The answer of The ____________________ set operator is used to...

Question 16

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 THE WOK WAY TO COOK?

Accepted Answer

A)  SELECT title FROM promotion
WHERE retail BETWEEN minretail AND maxretail; 
B)  SELECT title FROM promotion NATURAL JOIN books
WHERE retail BETWEEN minretail AND maxretail; 
C)  SELECT title FROM promotion JOIN books
USING retail BETWEEN minretail AND maxretail; 
D)  none of the above 
A)  SELECT title FROM promotion
WHERE retail BETWEEN minretail AND maxretail; 
B)  SELECT title FROM promotion NATURAL JOIN books
WHERE retail BETWEEN minretail AND maxretail; 
C)  SELECT title FROM promotion JOIN books
USING retail BETWEEN minretail AND maxretail; 
D)  none of the above

Question 17

To display rows from one table that do not have a corresponding row in the other table, you must create a(n) ____________________ join.

Accepted Answer

The answer of To display rows from one table that...

Question 18

A(n) $\underline { \text { non-equality } }$ join is also known as an equijoin, inner join, or simple join. _________________________

Accepted Answer

A) True 
 B)False

Question 19

Structure of the ORDERS table
   
Structure of the CUSTOMERS table
-Which SQL statement will return the same results as the following SQL statement? SELECT * FROM orders, customers;

Accepted Answer

A)  SELECT * FROM orders CROSS JOIN customers; 
B)  SELECT * FROM orders, customers
WHERE orders.customer# = customers.customer#; 
C)  SELECT * FROM orders, customers.
WHERE orders.customer# > customers.customer#; 
D) customer#; 
E)  SELECT * FROM o orders , c customers
WHERE o.customer# = 
A)  SELECT * FROM orders CROSS JOIN customers; 
B)  SELECT * FROM orders, customers
WHERE orders.customer# = customers.customer#; 
C)  SELECT * FROM orders, customers.
WHERE orders.customer# > customers.customer#; 
D) customer#; 
E)  SELECT * FROM o orders , c customers
WHERE o.customer# =

Question 20

An outer join operator consists of a minus sign enclosed in parentheses, (-).

Accepted Answer

A) True 
 B)False

A(n) ____________________ join is required when a table must be joined to itself.

Joins are classified as ____________________ joins if the results can only contain the rows that had matching values in each table, rather than rows being matched with NULL values.

The outer join operator is placed on the side of the joining condition that has ____________________ rows.

Give the appropriate situation in which to use each of the following join keywords: NATURAL JOIN, JOIN...USING, and JOIN...ON.

Data stored in separate tables can be reconstructed through the use of ____________________.

Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.

The INTERSECT set operator only displays the rows returned by both queries.

A(n) $\underline {\text { non-equality }}$ join is used when there are no equivalent rows of data in the tables that are being joined. _________________________

In Oracle11g, tables can be linked through which clause(s)?

The ____________________ operator is used to create an outer join in the WHERE clause of a SQL statement.

Data stored in multiple tables can be combined through the use of an ORDER BY clause.

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following is a valid SQL statement?

Using the JOIN...____________________ keywords to join two tables requires that a condition be specified to indicate how the tables are related.

The $\underline {\text { JOIN...USING } }$ keywords are used to join two tables that do not have a commonly named and defined column. _________________________

The ____________________ set operator is used to display the rows returned by both SELECT statements.

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 THE WOK WAY TO COOK?

To display rows from one table that do not have a corresponding row in the other table, you must create a(n) ____________________ join.

A(n) $\underline { \text { non-equality } }$ join is also known as an equijoin, inner join, or simple join. _________________________

Structure of the ORDERS table Structure of the CUSTOMERS table -Which SQL statement will return the same results as the following SQL statement? SELECT * FROM orders, customers;

An outer join operator consists of a minus sign enclosed in parentheses, (-).

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

A(n) ____________________ join is required when a table must be joined to itself.

Joins are classified as ____________________ joins if the results can only contain the rows that had matching values in each table, rather than rows being matched with NULL values.

The outer join operator is placed on the side of the joining condition that has ____________________ rows.

Give the appropriate situation in which to use each of the following join keywords: NATURAL JOIN, JOIN...USING, and JOIN...ON.

Data stored in separate tables can be reconstructed through the use of ____________________.

Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.

The INTERSECT set operator only displays the rows returned by both queries.

A(n) non-equality ‾\underline {\text { non-equality }} non-equality ​ join is used when there are no equivalent rows of data in the tables that are being joined. _________________________

In Oracle11g, tables can be linked through which clause(s)?

The ____________________ operator is used to create an outer join in the WHERE clause of a SQL statement.

Data stored in multiple tables can be combined through the use of an ORDER BY clause.

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following is a valid SQL statement?

Using the JOIN...____________________ keywords to join two tables requires that a condition be specified to indicate how the tables are related.

The JOIN...USING ‾\underline {\text { JOIN...USING } } JOIN...USING ​ keywords are used to join two tables that do not have a commonly named and defined column. _________________________

The ____________________ set operator is used to display the rows returned by both SELECT statements.

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 THE WOK WAY TO COOK?

To display rows from one table that do not have a corresponding row in the other table, you must create a(n) ____________________ join.

A(n) non-equality ‾\underline { \text { non-equality } } non-equality ​ join is also known as an equijoin, inner join, or simple join. _________________________

Structure of the ORDERS table Structure of the CUSTOMERS table -Which SQL statement will return the same results as the following SQL statement? SELECT * FROM orders, customers;

An outer join operator consists of a minus sign enclosed in parentheses, (-).

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

A(n) $\underline {\text { non-equality }}$ join is used when there are no equivalent rows of data in the tables that are being joined. _________________________

The $\underline {\text { JOIN...USING } }$ keywords are used to join two tables that do not have a commonly named and defined column. _________________________

A(n) $\underline { \text { non-equality } }$ join is also known as an equijoin, inner join, or simple join. _________________________