Question 1

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 ISBN of each book purchased by the customers would require how many joins in the FROM clause of the SQL statement?

Accepted Answer

A)   4
B)   3
C)   2
D)   1E) B) and C)
F) A) and D)

Question 2

The ____________________ set operator is used to display the results that were returned by the first query that were not also returned by the second query.

Accepted Answer

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

Question 3

In a Cartesian join, linking a table that contains 10 rows to a table that contains 9 rows will result in ____ rows being displayed in the output.

Accepted Answer

A)   19
B)   18
C)   90
D)   89E) All of the above
F) B) and D)

Question 4

A Cartesian join usually results from the user omitting the joining condition that links two or more tables together.

Accepted Answer

A) True 
 B)False

Question 5

The$\underline {\text { outer join } }$operator is used to combine the results of multiple SELECT statements. _________________________

Accepted Answer

A) True 
 B)False

Question 6

The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is used to create an outer join in a WHERE clause?

Accepted Answer

A)   FULL OUTER JOIN keywords
B)   LEFT OUTER JOIN keywords
C)   RIGHT OUTER JOIN keywords
D)   outer join operator (+) E) None of the above
F) A) and B)

Question 8

An outer join only lists rows that contain a match in both tables.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following types of joins refers to joining a table to itself?

Accepted Answer

A)   Cartesian join
B)   equality join
C)   self-join
D)   outer joinE) B) and D)
F) B) and C)

Question 10

A(n) ____________________ join is used when the related columns between two tables cannot be joined through an equal sign.

Accepted Answer

non-equali...

Question 11

A column qualifier is separated from the column name with a colon.

Accepted Answer

A) True 
 B)False

Question 12

The outer join operator is placed on the side of the comparison that is deficient or is missing the matching rows.

Accepted Answer

A) True 
 B)False

Question 13

In which of the following examples is the ORDERS table used as a column qualifier?

Accepted Answer

A)   o.order#
B)   orders.order#
C)   order#.o
D)   order#.ordersE) A) and D)
F) A) and B)

Question 14

Structure of the ORDERS table
  
Structure of the CUSTOMERS table
-Which of the following SQL statements will display all customers who have not recently placed an order?

Accepted Answer

A)   SELECT customer# FROM customersUNIONSELECT customer# FROM orders;
B)   SELECT customer# FROM ordersMINUSSELECT customer# FROM customers;
C)   SELECT customer# FROM ordersINTERSECTSELECT customer# FROM customers;
D)   SELECT customer# FROM customersMINUSSELECT customer# FROM orders;E) A) and C)
F) B) and C)

Question 15

Which of the following set operators can be used to make certain that only the rows returned by both queries are displayed in the results?

Accepted Answer

A)   UNION
B)   UNION ALL
C)   INTERSECT
D)   MINUSE) None of the above
F) A) and C)

Question 16

Structure of the ORDERS table
  
Structure of the CUSTOMERS table
-Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?

Accepted Answer

A)   SELECT * FROM orders, customers;
B)   SELECT lastname, firstname, order#FROM orders NATURAL JOIN customers;
C)   SELECT lastname, firstname, order#FROM orders, customersWHERE orders.customer# = customers.customer#;
D)   all of the aboveE) B) and C)
F) All of the above

Question 17

Structure of the PROMOTION table
  
Structure of the BOOKS table
  
Structure of the ORDERITEMS table
-Which of the following SQL statements will display the gift or gifts that should be sent with order# 1003?

Accepted Answer

A)   SELECT giftFROM promotionWHERE order# = 1003;
B)   SELECT giftFROM promotion NATURAL JOIN booksWHERE order# = 1003;
C)  isbn AND order# = 1003;
D)   SELECT giftFROM promotion, orderitems oi, books bWHERE retail BETWEEN minretail AND maxretailAND oi.isbn =
E)   none of the aboveF) A) and B)
G) A) and E)

Question 18

Which of the following keywords is used to create an equality join?

Accepted Answer

A)   NATURAL JOIN
B)   JOIN...ON
C)   JOIN...USING
D)   all of the aboveE) B) and D)
F) A) and C)

Question 19

Structure of the BOOKS table
  
Structure of the PUBLISHER table
-Which of the following will display the title, publication date, and publisher name of each book in the BUSINESS category?

Accepted Answer

A)   SELECT title, pubdate, nameFROM publisher JOIN books USING (pubid) WHERE category = 'BUSINESS';
B)   SELECT title, pubdate, nameFROM publisher JOIN books ON (pubid) WHERE category = 'BUSINESS';
C)   SELECT title, pubdate, nameFROM publisher OUTER JOIN books USING (pubid) WHERE category = 'BUSINESS';
D)   SELECT title, pubdate, nameFROM publisher CROSS JOIN books USING (pubid) WHERE category = 'BUSINESS';E) B) and C)
F) A) and B)

Question 20

Structure of the CUSTOMERS table
  
Structure of the ORDERS table
  
Structure of the ORDERITEMS table
  
Structure of the BOOKS table
-Which of the following SQL statements will display the title of the books ordered by customer# 1003?

Accepted Answer

A)   SELECT titleFROM customers NATURAL JOIN booksWHERE customer# = 1003;
B)   SELECT titleFROM customers JOIN orders USING (customer#) JOIN orderitems USING (order#)  JOIN books USING (isbn) WHERE customer# = 1003;
C)   SELECT titleFROM customers JOIN orders ON (customer#) JOIN orderitems ON (order#)  JOIN books ON (isbn) WHERE customer# = 1003;
D)   both a and bE) B) and D)
F) None of the above

Exam 9: Joining Data From Multiple Tables

In which of the following examples is the ORDERS table used as a column qualifier?

Correct AnswerverifiedShow Answer

Which of the following types of joins refers to joining a table to itself?

Correct AnswerverifiedShow Answer

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following will display the title, publication date, and publisher name of each book in the BUSINESS category?

Correct AnswerverifiedShow Answer

The outer join ‾\underline {\text { outer join } } outer join ​ operator is used to combine the results of multiple SELECT statements. _________________________

Correct AnswerverifiedShow Answer

A Cartesian join usually results from the user omitting the joining condition that links two or more tables together.

Correct AnswerverifiedShow Answer

Which of the following set operators can be used to make certain that only the rows returned by both queries are displayed in the results?

Correct AnswerverifiedShow Answer

The ____________________ set operator is used to display the results that were returned by the first query that were not also returned by the second query.

Correct AnswerverifiedShow Answer

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?

Correct AnswerverifiedShow Answer

The outer join operator is placed on the side of the comparison that is deficient or is missing the matching rows.

Correct AnswerverifiedShow Answer

Structure of the CUSTOMERS table Structure of the ORDERS table Structure of the ORDERITEMS table Structure of the BOOKS table -Which of the following SQL statements will display the title of the books ordered by customer# 1003?

Correct AnswerverifiedShow Answer

Which of the following is used to create an outer join in a WHERE clause?

Correct AnswerverifiedShow Answer

Structure of the ORDERS table Structure of the CUSTOMERS table -Which of the following SQL statements will display all customers who have not recently placed an order?

Correct AnswerverifiedShow Answer

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 ISBN of each book purchased by the customers would require how many joins in the FROM clause of the SQL statement?

Correct AnswerverifiedShow Answer

Structure of the PROMOTION table Structure of the BOOKS table Structure of the ORDERITEMS table -Which of the following SQL statements will display the gift or gifts that should be sent with order# 1003?

Correct AnswerverifiedShow Answer

The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column.

Correct AnswerverifiedShow Answer

A column qualifier is separated from the column name with a colon.

Correct AnswerverifiedShow Answer

In a Cartesian join, linking a table that contains 10 rows to a table that contains 9 rows will result in ____ rows being displayed in the output.

Correct AnswerverifiedShow Answer

An outer join only lists rows that contain a match in both tables.

Correct AnswerverifiedShow Answer

A(n) ____________________ join is used when the related columns between two tables cannot be joined through an equal sign.

Correct Answerverifiednon-equali...View AnswerShow Answer

Which of the following keywords is used to create an equality join?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

The $\underline {\text { outer join } }$ operator is used to combine the results of multiple SELECT statements. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
non-equali...
View Answer

Correct Answer
verified