Question 1

The outer join operator in the WHERE clause cannot be used with which of the following operators?

Accepted Answer

A)  IN 
B)  OR 
C)  AND 
D)  both a and b 
A)  IN 
B)  OR 
C)  AND 
D)  both a and b

Question 2

If you are attempting to join two tables that have multiple common columns, which of the following JOIN keywords should be used to specify how the tables should be linked?

Accepted Answer

A)  OUTER JOIN 
B)  CROSS JOIN 
C)  JOIN...USING 
D)  none of the above 
A)  OUTER JOIN 
B)  CROSS JOIN 
C)  JOIN...USING 
D)  none of the above

Question 3

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 names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY?

Accepted Answer

A)  SELECT lastname, firstname
FROM customers NATURAL JOIN books
WHERE title LIKE '%BUSI%'; 
B)  SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi
WHERE title LIKE '%BUSI%'; 
C)  SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi
WHERE c.customer# = o.customer# AND o.order# = oi.order# AND
Oi)isbn = b.isbn AND title LIKE '%BUSI%'; 
D)  none of the above 
A)  SELECT lastname, firstname
FROM customers NATURAL JOIN books
WHERE title LIKE '%BUSI%'; 
B)  SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi
WHERE title LIKE '%BUSI%'; 
C)  SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi
WHERE c.customer# = o.customer# AND o.order# = oi.order# AND
Oi)isbn = b.isbn AND title LIKE '%BUSI%'; 
D)  none of the above

Question 4

A table alias can consist of a maximum of ____ characters.

Accepted Answer

A)  12 
B)  225 
C)  255 
D)  30 
A)  12 
B)  225 
C)  255 
D)  30

Question 5

The ____________________ keyword can be included in the FROM clause to link tables.

Accepted Answer

The answer of The ____________________ keyword can be included in...

Question 6

A(n) $\underline {\text { Cartesian Join }}$ replicates each row from the first table with every row from the second table. _________________________

Accepted Answer

A) True 
 B)False

Question 7

Set operators are used to combine the results of multiple queries.

Accepted Answer

A) True 
 B)False

Question 8

A(n) $\underline { \text { inner join }}$ will only include rows that have matching rows in the other table. _________________________

Accepted Answer

A) True 
 B)False

Question 9

A(n) $\underline {\text { non-equality }}$ join is when a table is joined to itself. _________________________

Accepted Answer

A) True 
 B)False

Question 10

When using the JOIN...ON keywords to join four tables, both keywords must be repeated four times.

Accepted Answer

A) True 
 B)False

Question 11

Structure of the BOOKS table
   
Structure of the PUBLISHER table
-Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $35.95?

Accepted Answer

A)  SELECT name, title, retail
FROM books, publisher
WHERE cost > 35.95; 
B)  SELECT name, title, retail FROM books NATURAL JOIN publisher
WHERE cost > 35.95; 
C)  SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p
WHERE b.cost > 35.95; 
D)  none of the above 
A)  SELECT name, title, retail
FROM books, publisher
WHERE cost > 35.95; 
B)  SELECT name, title, retail FROM books NATURAL JOIN publisher
WHERE cost > 35.95; 
C)  SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p
WHERE b.cost > 35.95; 
D)  none of the above

The outer join operator in the WHERE clause cannot be used with which of the following operators?

If you are attempting to join two tables that have multiple common columns, which of the following JOIN keywords should be used to specify how the tables should be linked?

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 names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY?

A table alias can consist of a maximum of ____ characters.

The ____________________ keyword can be included in the FROM clause to link tables.

A(n) $\underline {\text { Cartesian Join }}$ replicates each row from the first table with every row from the second table. _________________________

Set operators are used to combine the results of multiple queries.

A(n) $\underline { \text { inner join }}$ will only include rows that have matching rows in the other table. _________________________

A(n) $\underline {\text { non-equality }}$ join is when a table is joined to itself. _________________________

When using the JOIN...ON keywords to join four tables, both keywords must be repeated four times.

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $35.95?

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 outer join operator in the WHERE clause cannot be used with which of the following operators?

If you are attempting to join two tables that have multiple common columns, which of the following JOIN keywords should be used to specify how the tables should be linked?

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 names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY?

A table alias can consist of a maximum of ____ characters.

The ____________________ keyword can be included in the FROM clause to link tables.

A(n) Cartesian Join ‾\underline {\text { Cartesian Join }} Cartesian Join ​ replicates each row from the first table with every row from the second table. _________________________

Set operators are used to combine the results of multiple queries.

A(n) inner join ‾\underline { \text { inner join }} inner join ​ will only include rows that have matching rows in the other table. _________________________

A(n) non-equality ‾\underline {\text { non-equality }} non-equality ​ join is when a table is joined to itself. _________________________

When using the JOIN...ON keywords to join four tables, both keywords must be repeated four times.

Structure of the BOOKS table Structure of the PUBLISHER table -Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $35.95?

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 { Cartesian Join }}$ replicates each row from the first table with every row from the second table. _________________________

A(n) $\underline { \text { inner join }}$ will only include rows that have matching rows in the other table. _________________________

A(n) $\underline {\text { non-equality }}$ join is when a table is joined to itself. _________________________