Question 1

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 2

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, name
FROM publisher JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
B)  SELECT title, pubdate, name
FROM publisher JOIN books ON (pubid)
WHERE category = 'BUSINESS'; 
C)  SELECT title, pubdate, name
FROM publisher OUTER JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
D)  SELECT title, pubdate, name
FROM publisher CROSS JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
A)  SELECT title, pubdate, name
FROM publisher JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
B)  SELECT title, pubdate, name
FROM publisher JOIN books ON (pubid)
WHERE category = 'BUSINESS'; 
C)  SELECT title, pubdate, name
FROM publisher OUTER JOIN books USING (pubid)
WHERE category = 'BUSINESS'; 
D)  SELECT title, pubdate, name
FROM publisher CROSS JOIN books USING (pubid)
WHERE category = 'BUSINESS';

Question 3

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)  1 
A)  4 
B)  3 
C)  2 
D)  1

Question 4

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 join 
A)  Cartesian join 
B)  equality join 
C)  self-join 
D)  outer join

Question 5

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 6

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 title
FROM customers NATURAL JOIN books
WHERE customer# = 1003; 
B)  SELECT title
FROM customers JOIN orders USING (customer#)
JOIN orderitems USING (order#) JOIN books USING (isbn)
WHERE customer# = 1003; 
C)  SELECT title
FROM customers JOIN orders ON (customer#)
JOIN orderitems ON (order#) JOIN books ON (isbn)
WHERE customer# = 1003; 
D)  both a and b 
A)  SELECT title
FROM customers NATURAL JOIN books
WHERE customer# = 1003; 
B)  SELECT title
FROM customers JOIN orders USING (customer#)
JOIN orderitems USING (order#) JOIN books USING (isbn)
WHERE customer# = 1003; 
C)  SELECT title
FROM customers JOIN orders ON (customer#)
JOIN orderitems ON (order#) JOIN books ON (isbn)
WHERE customer# = 1003; 
D)  both a and b

Question 7

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)  89 
A)  19 
B)  18 
C)  90 
D)  89

Question 8

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 gift
FROM promotion
WHERE order# = 1003; 
B)  SELECT gift
FROM promotion NATURAL JOIN books
WHERE order# = 1003; 
C) isbn AND order# = 1003; 
D)  SELECT gift
FROM promotion, orderitems oi, books b
WHERE retail BETWEEN minretail AND maxretail
AND oi.isbn = 
E)  none of the above 
A)  SELECT gift
FROM promotion
WHERE order# = 1003; 
B)  SELECT gift
FROM promotion NATURAL JOIN books
WHERE order# = 1003; 
C) isbn AND order# = 1003; 
D)  SELECT gift
FROM promotion, orderitems oi, books b
WHERE retail BETWEEN minretail AND maxretail
AND oi.isbn = 
E)  none of the above

Question 9

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 above 
A)  NATURAL JOIN 
B)  JOIN...ON 
C)  JOIN...USING 
D)  all of the above

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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)  MINUS 
A)  UNION 
B)  UNION ALL 
C)  INTERSECT 
D)  MINUS

Question 12

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 13

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 customers
UNION
SELECT customer# FROM orders; 
B)  SELECT customer# FROM orders
MINUS
SELECT customer# FROM customers; 
C)  SELECT customer# FROM orders
INTERSECT
SELECT customer# FROM customers; 
D)  SELECT customer# FROM customers
MINUS
SELECT customer# FROM orders; 
A)  SELECT customer# FROM customers
UNION
SELECT customer# FROM orders; 
B)  SELECT customer# FROM orders
MINUS
SELECT customer# FROM customers; 
C)  SELECT customer# FROM orders
INTERSECT
SELECT customer# FROM customers; 
D)  SELECT customer# FROM customers
MINUS
SELECT customer# FROM orders;

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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#.orders 
A)  o.order# 
B)  orders.order# 
C)  order#.o 
D)  order#.orders

Question 17

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 (+) 
A)  FULL OUTER JOIN keywords 
B)  LEFT OUTER JOIN keywords 
C)  RIGHT OUTER JOIN keywords 
D)  outer join operator (+)

Question 18

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, customers
WHERE orders.customer# = customers.customer#; 
D)  all of the above 
A)  SELECT * FROM orders, customers; 
B)  SELECT lastname, firstname, order#
FROM orders NATURAL JOIN customers; 
C)  SELECT lastname, firstname, order#
FROM orders, customers
WHERE orders.customer# = customers.customer#; 
D)  all of the above

Question 19

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 20

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

Accepted Answer

non-equali

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.

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?

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?

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

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

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?

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.

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?

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

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

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?

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

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?

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

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

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

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

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?

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

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

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

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.

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?

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?

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

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

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?

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.

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?

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

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

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?

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

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?

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

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

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

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

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?

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

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

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

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