Question 1

A Cartesian join can be created by not including a joining condition in the $\underline { \text { WHERE }}$ clause of a SELECT statement. _________________________

Accepted Answer

A) True 
 B)False

Question 2

The ____________________ set operator is used to display the combined results returned by multiple SELECT statements.

Accepted Answer

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

Question 3

The ____________________ keywords create a join automatically between two tables, based on columns with matching names.

Accepted Answer

The answer of The ____________________ keywords create a join automatically...

Question 4

The number of joining conditions required to join tables is always one less than the number of tables being joined.

Accepted Answer

A) True 
 B)False

Question 5

Equality, non-equality, and self-joins are broadly categorized as $\underline {\text { outer }}$ joins. _________________________

Accepted Answer

A) True 
 B)False

Question 6

The $\underline {\text { outer join } }$ operator is placed on the side of the joining condition that references the table containing the deficient rows. _________________________

Accepted Answer

A) True 
 B)False

Question 7

Structure of the ORDERS table
  
Structure of the CUSTOMERS table
-Which of the following SQL statements will list the name of each customer stored in the CUSTOMERS table, and, if the customer has placed an order that is contained in the ORDERS table, the order# of any order each customer has placed?

Accepted Answer

A)  SELECT lastname, firstname, order#
FROM customers NATURAL JOIN orders
WHERE orders.customer# IS NOT NULL; 
B)  SELECT lastname, firstname, order#
FROM customers, orders
WHERE orders.customer# (+) = customers.customer#; 
C)  SELECT lastname, firstname, order#
FROM customers, orders
WHERE orders.customer# = customers.customer# (+); 
D)  SELECT lastname, firstname, order#
FROM customers NATURAL JOIN orders
WHERE orders.customer# IS NULL;

Question 8

A column ____________________ indicates the table containing the column being referenced.

Accepted Answer

The answer of A column ____________________ indicates the table containing...

Question 9

A column qualifier indicates the $\underline { \text { column } }$ containing the data being referenced. _________________________

Accepted Answer

A) True 
 B)False

Question 10

A(n) $\underline { \text { outer } }$ join can be created by not including a joining condition in a SELECT statement. _________________________

Accepted Answer

A) True 
 B)False

Question 11

Which of the following SQL statements will display books that have not been ordered recently?

Accepted Answer

A)  SELECT title
FROM books, orderitems
WHERE books.isbn  orderitems.isbn; 
B)  SELECT title
FROM books NATURAL JOIN orderitems
WHERE JOIN IS NULL; 
C)  SELECT title FROM books NATURAL JOIN orderitems
MINUS
SELECT title FROM books; 
D)  SELECT title FROM books
MINUS
SELECT title FROM books NATURAL JOIN orderitems;

Question 12

Structure of the CUSTOMERS table
 
-Which of the following queries will display the first and last name of the individual who referred another customer, along with the customer# of the referred customer?

Accepted Answer

A)  SELECT r.firstname, r.lastname, c.customer# FROM customers r, customers c
WHERE r.customer# = c.referred; 
B)  SELECT r.firstname, r.lastname, c.customer# FROM customers r JOIN customers c
ON r.customer# = c.referred; 
C)  SELECT r.firstname, r.lastname, c.customer# FROM customers r NATURAL JOIN customers c; 
D)  both a and b

Question 13

Which of the following types of joins refers to results consisting of each row from the first table being replicated from every row in the second table?

Accepted Answer

A)  outer join 
B)  non-equality join 
C)  self-join 
D)  Cartesian join

Question 14

The JOIN keyword is used in the WHERE clause to indicate the tables that should be joined or linked.

Accepted Answer

A) True 
 B)False

Question 15

Structure of the ORDERS table
  
Structure of the CUSTOMERS table
-Which of the following queries will return the same results as the following SQL statement? SELECT

Accepted Answer

A)  SELECT customer#, lastname, firstname, order#
FROM customers NATURAL JOIN orders; 
B)  SELECT customer#, lastname, firstname, order#
FROM customers JOIN orders USING (customer#); 
C)  SELECT c.customer#, lastname, firstname, order# FROM customers c, orders o; 
D)  both a and b

Question 16

Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?

Accepted Answer

A)  SELECT title
FROM books NATURAL JOIN orderitems
WHERE qty > 1; 
B)  SELECT title
FROM books JOIN orderitems
WHERE qty > 1; 
C)  SELECT title
FROM books JOIN orderitems ON (isbn) JOIN orders ON (order#)
WHERE qty>1; 
D)  SELECT title
FROM books JOIN orderitems USING(isbn);

Question 17

The NATURAL JOIN keywords can be used to create non-equality joins.

Accepted Answer

A) True 
 B)False

Question 18

A table alias is assigned in the $\underline { \text { FROM } }$ clause. _________________________

Accepted Answer

A) True 
 B)False

Question 19

A column qualifier is separated from the column using which symbol?

Accepted Answer

A)  comma (,) 
B)  plus sign (+) 
C)  period (.) 
D)  percent sign (%)

Question 20

Which of the following can only be used to link tables that have a common column?

Accepted Answer

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

Exam 9: Joining Data From Multiple Tables

A Cartesian join can be created by not including a joining condition in the WHERE ‾\underline { \text { WHERE }} WHERE ​ clause of a SELECT statement. _________________________

The ____________________ set operator is used to display the combined results returned by multiple SELECT statements.

The ____________________ keywords create a join automatically between two tables, based on columns with matching names.

The number of joining conditions required to join tables is always one less than the number of tables being joined.

Equality, non-equality, and self-joins are broadly categorized as outer ‾\underline {\text { outer }} outer ​ joins. _________________________

The outer join ‾\underline {\text { outer join } } outer join ​ operator is placed on the side of the joining condition that references the table containing the deficient rows. _________________________

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following SQL statements will list the name of each customer stored in the CUSTOMERS table, and, if the customer has placed an order that is contained in the ORDERS table, the order# of any order each customer has placed?

A column ____________________ indicates the table containing the column being referenced.

A column qualifier indicates the column ‾\underline { \text { column } } column ​ containing the data being referenced. _________________________

A(n) outer ‾\underline { \text { outer } } outer ​ join can be created by not including a joining condition in a SELECT statement. _________________________

Which of the following SQL statements will display books that have not been ordered recently?

Structure of the CUSTOMERS table -Which of the following queries will display the first and last name of the individual who referred another customer, along with the customer# of the referred customer?

Which of the following types of joins refers to results consisting of each row from the first table being replicated from every row in the second table?

The JOIN keyword is used in the WHERE clause to indicate the tables that should be joined or linked.

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following queries will return the same results as the following SQL statement? SELECT

Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?

The NATURAL JOIN keywords can be used to create non-equality joins.

A table alias is assigned in the FROM ‾\underline { \text { FROM } } FROM ​ clause. _________________________

A column qualifier is separated from the column using which symbol?

Which of the following can only be used to link tables that have a common column?

A Cartesian join can be created by not including a joining condition in the $\underline { \text { WHERE }}$ clause of a SELECT statement. _________________________

Equality, non-equality, and self-joins are broadly categorized as $\underline {\text { outer }}$ joins. _________________________

The $\underline {\text { outer join } }$ operator is placed on the side of the joining condition that references the table containing the deficient rows. _________________________

A column qualifier indicates the $\underline { \text { column } }$ containing the data being referenced. _________________________

A(n) $\underline { \text { outer } }$ join can be created by not including a joining condition in a SELECT statement. _________________________

A table alias is assigned in the $\underline { \text { FROM } }$ clause. _________________________