Chapter 9 - Joining Data From Multiple Tables

Ace your homework & exams now with Quizwiz!

column qualifier

A __________ __________ indicates the table containing the column being reference.

D. Cartesian (Cross)

A __________ join replicates each row from the first table with every row form the second table. A. Inner (Equality) B. Outer C. Self D. Cartesian (Cross) F. Non-equality

B. period (.)

A column qualifier is separated from the column using which symbol? A. comma (,) B. period (.) C. plus sign (+) D. percent sign (%)

j

Given the following query: SELECT DISTINCT zip, category FROM customers NATURAL JOIN orders NATURAL JOIN orderitems NATURAL JOIN books; Which of the following queries is equivalent? A. SELECT zip FROM customers UNION SELECT category FROM books; B. SELECT DISTINCT zip, category FROM customers c, orders o, orderitems oi, books b WHERE c.customer# = o.customer# AND o.order# = oi.order# AND oi.isbn = b.isbn; C. SELECT DISTINCT zip, category FROM customers c JOIN orders o JOIN orderitems oi JOIN books b ON c.customer# = o.customer# AND o.order# = oi.order# AND oi.isbn = b.isbn; D. all of the above E. none of the above

D. Cartesian (Cross)

This type of join is useful when performing certain statistical procedures for data analysis. A. Inner (Equality) B. Outer C. Self D. Cartesian (Cross) F. Non-equality

Common column

A column with equivalent data existing in two or more tables is known as a __________ column.

B. equality join

A join based upon a column from each table containing equivalent data is known as a(n) ____. A. inequality join B. equality join C. outer join D. all of the above

D. 30

A table alias can consist of a maximum of ____ characters. A. 12 B. 255 C. 225 D. 30

A. NATURAL JOIN

A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables? A. NATURAL JOIN B. LEFT OUTER JOIN C. JOIN...ON D. FULL OUTER JOIN

C. set operator

A(n) ____ is used to combine the results of two queries. A. concatenation operator B. comparison operator C. set operator D. logical operator

A. True

An outer join can include the RIGHT, LEFT, or FULL keywords. A. True B. False

k

Given the following query: SELECT lastname, firstname, order# FROM customers LEFT OUTER JOIN orders USING (customer#) ORDER BY customer#; Which of the following queries returns the same results? A. SELECT lastname, firstname, order# FROM customers c OUTER JOIN orders o ON c.customer# = o.customer# ORDER BY c.customer#; B. SELECT lastname, firstname, order# FROM orders o RIGHT OUTER JOIN customers c ON c.customer# = o.customer# ORDER BY c.customer#; C. SELECT lastname, firstname, order# FROM customers c, orders o WHERE c.customer# = o.customer# (+) ORDER BY c.customer#; D. none of the above

i

Given the following query: SELECT title, give FROM books CROSS JOIN promotion; Which of the following queries is equivalent? A. SELECT title, gift FROM books NATURAL JOIN promotion; B. SELECT title FROM books INTERSECT SELECT gift FROM promotion; C. SELECT title FROM books UNION ALL SELECT gift FROM promotion; D. all of the above

m

Given the following query: SELECT zip, order# FROM customers NATURAL JOIN orders; Which of the following queries is equivalent? A. SELECT zip, order# FROM customers JOIN orders WHERE customers.customer# = orders.customer#; B. SELECT zip, order# FROM customers, orders WHERE customers.customer# = orders.customer#; C. SELECT zip, order# FROM customers, orders WHERE customers.customer# = orders.customer# (+); D. None of the above

It is the number of tables in the query minus 1

How do you determine the number of join operations needed?

D. 1

How many joining conditions will be required in an SQL statement that is used to determine the gift that corresponds to each book in the BOOKS table? A. 4 B. 2 C. 3 D. 1

Inner

If a join is not specified, the __________ join is implicitly used by default.

h

If the CUSTOMERS table contains seven records and the ORDERS table has eight records, how many records does the following query produce? SELECT * FROM customers CROSS JOIN orders; A. 0 B. 8 C. 7 D. 15 E. 56

B. JOIN...USING

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? A. OUTER JOIN B. JOIN...USING C. CROSS JOIN D. none of the above

D. both b and c

In Oracle11g, tables can be linked through which clause(s)? A. SELECT B. WHERE C. FROM D. both b and c

B. 90

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

F. Non-equality

In this type of join, a data value of a record stored in the common column for the first table must match the data value in the second table. A. Inner (Equality) B. Outer C. Self D. Cartesian F. Non-equality

C. orders.order#

In which of the following examples is the ORDERS table used as a column qualifier? A. o.order# B. order#.o C. orders.order# D. order#.orders

Join conditions

Instructions in queries that combine data from more than one table are known as ______ ______.

C. FROM

The JOIN keyword is included in which of the following clauses? A. SELECT B. WHERE C. FROM D. ORDER BY

o

The following SQL statement contains which type of join? SELECT title, order#, quantity FROM books, FULL JOIN orderitems ON books.isbn = orderitems.isbn; A. equality B. self-join C. non-equality D. outer join

A. Inner (Equality)

The most common type of join used in the workplace is based on two (or more) tables having equivalent data stored in a common column. This type of join is a __________ join. A. Inner (Equality) B. Outer C. Self D. Cartesian (Cross) F. Non-equality

A. True

The outer join operator can be used for only one table in the joining condition. A. True B. False

B. False

The outer join operator can use the IN or OR operator. A. True B. False

D. both a and b

The outer join operator in the WHERE clause cannot be used with which of the following operators? A. IN B. AND C. OR D. both a and b

A. Inner (Equality)

This type of join creates a join by using a commonly named and defined column. A. Inner (Equality) B. Outer C. Self D. Cartesian (Cross) F. Non-equality

B. Outer

This type of join includes records of a table in output when there's no matching record in the other table. A. Inner (Equality) B. Outer C. Self D. Cartesian (Cross) F. Non-equality

C. Self

This type of join, joins a table to itself. A. Inner (Equality) B. Outer C. Self D. Cartesian (Cross) F. Non-equality

F. Non-equality

This type of join, joins two tables when there are no equivalent rows in the tables to be joined. A. Inner (Equality) B. Outer C. Self D. Cartesian (Cross) F. Non-equality

B. 2

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

C. 3

To display the name of each customer and the title of each book purchased by the customers would require how many join conditions? A. 4 B. 2 C. 3 F. 1

b

What is the maximum number of characters allowed in a table alias? A. 10 B. 30 C. 255 D. 256

C. On

When the tables to be joined in a USING clause don't have a commonly named and defined field, you must add the __________ clause to the JOIN keyword to specify how the tables are related. A. In B. Before C. On D. From

A. SELECT * FROM orders CROSS JOIN customers;

Which SQL statement will return the same results as the following SQL statement? SELECT * FROM orders, customers; 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. SELECT * FROM o orders , c customers WHERE o.customer# = c.customer#;

B. Using

Which clause allows you to create joins based on a column that has the same name and definition in both tables. A. Natural B. Using C. On D. In

E. line 5 ( no closing )

Which line in the following SQL statement raises an error? 1. SELECT name, title 2. FROM books JOIN publisher 3. WHERE books.pubid = publisher.pubid 4. AND 5. cost <45.95 A. line 1 B. line 2 C. line 3 D. line 4 E. line 5

l

Which line in the following SQL statement raises an error? 1. SELECT name, title 2. FROM books NATURAL JOIN publisher 3. WHERE category = 'FITNESS' 4. OR 5. books.pubid=4; A. line 1 B. line 2 C. line3 D. line 4 E. line 5

c

Which line in the following SQL statement raises an error? 1. SELECT name, title 2. FROM books b, publisher p 3. WHERE books.pubid = publisher.pubid 4. AND 5. (retail >25 OR retail-cost >18.95); A. line 1 B. line 3 C. line 4 D. line 5

g

Which of the following SQL statements is not valid? A. SELECT b.isbn, p.name FROM books b NATURAL JOIN publisher p; B. SELECT isbn, name FROM books b, publisher p WHERE b.pubid = p.pubid; C. SELECT isbn, name FROM books b JOIN publisher p ON b.pubid = p.pubid; D. SELECT isbn, name FROM books JOIN publisher USING (pubid); E. None- all of the above are valid SQL statements

C. SELECT title, name FROM books NATURAL JOIN publisher

Which of the following SQL statements is not valid? A. SELECT isbn FROM books MINUS SELECT isbn FROM orderitems; B. SELECT isbn, name FROM books, publisher WHERE books.pubid(+) = publisher.pubid(+); C. SELECT title, name FROM books NATURAL JOIN publisher D. All of the above SQL statements are valid.

D. SELECT customer# FROM customers MINUS SELECT customer# FROM orders;

Which of the following SQL statements will display all customers who have not recently placed an order? 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;

D. SELECT title FROM books MINUS SELECT title FROM books NATURAL JOIN orderitems;

Which of the following SQL statements will display books that have not been ordered recently? 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;

C. SELECT gift FROM promotion, orderitems oi, books b WHERE retail BETWEEN minretail AND maxretail AND oi.isbn = b.isbn AND order# = 1003;

Which of the following SQL statements will display the gift or gifts that should be sent with order# 1003? A. SELECT gift FROM promotion WHERE order# = 1003; B. SELECT gift FROM promotion NATURAL JOIN books WHERE order# = 1003; C. SELECT gift FROM promotion, orderitems oi, books b WHERE retail BETWEEN minretail AND maxretail AND oi.isbn = b.isbn AND order# = 1003; D. none of the above

C. SELECT gift FROM promotion, books WHERE retail BETWEEN minretail AND maxretail AND title = 'SHORTEST POEMS';

Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled SHORTEST POEMS? A. SELECT gift FROM promotion WHERE gift = minretail; B. SELECT gift FROM promotion, books WHERE retail >= minretail AND title = 'SHORTEST POEMS'; C. SELECT gift FROM promotion, books WHERE retail BETWEEN minretail AND maxretail AND title = 'SHORTEST POEMS'; D. none of the above

D. none of the above

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? 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

B. SELECT UNIQUE name FROM books NATURAL JOIN publisher WHERE category = 'COMPUTER';

Which of the following SQL statements will display the name of each publisher that publishes a book classified in the COMPUTER category? A. SELECT UNIQUE name FROM books, publisher; B. SELECT UNIQUE name FROM books NATURAL JOIN publisher WHERE category = 'COMPUTER'; C. SELECT DISTINCT name FROM books JOIN publisher WHERE category = 'COMPUTER'; D. both b and c

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%';

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. 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

B. SELECT name, title, retail FROM books NATURAL JOIN publisher WHERE cost > 35.95;

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? 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

B. SELECT title, cost, contact, phone FROM publisher JOIN books USING (pubid);

Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table, as well as the name of the contact person and the phone number to call to reorder the book? A. SELECT title, cost, contact, phone FROM publisher, books; B. SELECT title, cost, contact, phone FROM publisher JOIN books USING (pubid); C. SELECT title, cost, contact, phone FROM publisher JOIN books USING (isbn); D. SELECT title, cost, contact, phone FROM publisher JOIN books USING (contact);

A. SELECT title FROM books NATURAL JOIN orderitems WHERE qty > 1;

Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order? 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);

B. SELECT title, name FROM publisher NATURAL JOIN books;

Which of the following SQL statements will display the title of each book in the BOOKS table and the name of its publisher? A. SELECT title, name FROM publisher, books; B. SELECT title, name FROM publisher NATURAL JOIN books; C. SELECT title, name FROM publisher, books WHERE p.pubid = b.pubid; D. both b and c

B. SELECT title FROM customers JOIN orders USING (customer#) JOIN orderitems USING (order#) JOIN books USING (isbn) WHERE customer# = 1003;

Which of the following SQL statements will display the title of the books ordered by customer# 1003? 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

B. SELECT lastname, firstname, order# FROM customers, orders WHERE orders.customer# (+) = customers.customer#;

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. SELECT lastname, firstname, order# FROM customers NATURAL JOIN ordersWHERE 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 ordersWHERE orders.customer# IS NULL;

B. SELECT lastname, firstname, order# FROM customers c LEFT OUTER JOIN orders o ON c.customer# = o.customer#;

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. SELECT lastname, firstname, order# FROM customers NATURAL JOIN orders; B. SELECT lastname, firstname, order# FROM customers c LEFT OUTER JOIN orders o ON c.customer# = o.customer#; C. SELECT lastname, firstname, order# FROM customers RIGHT OUTER JOIN orders; D. SELECT lastname, firstname, order# FROM customers JOIN orders USING (customer#);

D. both a and c

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. SELECT lastname, firstname, order# FROM orders RIGHT OUTER JOIN customers USING (customer#); B. SELECT lastname, firstname, order# FROM orders LEFT OUTER JOIN customers USING (customer#); C. SELECT lastname, firstname, order# FROM orders FULL OUTER JOIN customers USING (customer#); D. both a and c

B. SELECT lastname, firstname FROM customers NATURAL JOIN orders WHERE orderdate = '12-APR-03';

Which of the following SQL statements will return the names of all customers who placed an order on April 12, 2003? A. SELECT lastname, firstname FROM customers WHERE orderdate = '12-APR-03'; B. SELECT lastname, firstname FROM customers NATURAL JOIN orders WHERE orderdate = '12-APR-03';

a

Which of the following SQL statemtns is valid? A. SELECT books.title, orderitems. quantity FROM books b, orderitems o WHERE b.isbn=o.isbn; B. SELECT title, quantity FROM books b JOIN orderitems o; C. SELECT books.title, orderitems.quantity FROM books JOIN orderitems ON books.isbn = orderitems.isbn; D. none of the above.

B. NATURAL JOIN

Which of the following can only be used to link tables that have a common column? A. FULL OUTER JOIN B. NATURAL JOIN C. JOIN...ON D. CROSS JOIN

B. SELECT c.customer#, order#, orderdate, shipdate FROM customers c, orders c WHERE c.customer# = o.customer#;

Which of the following is a valid SQL statement? A. SELECT c.customer#, order#, orderdate, shipdate FROM customers c NATURAL JOIN orders c; B. SELECT c.customer#, order#, orderdate, shipdate FROM customers c, orders c WHERE c.customer# = o.customer#;

B. FROM orders o, customers c

Which of the following is an example of assigning "o" as a table alias for the ORDERS table in the FROM clause? A. FROM o orders, c customers B. FROM orders o, customers c C. FROM o.orders, c.customers D. FROM orders.o, customers.c

D. outer join operator (+)

Which of the following is used to create an outer join in a WHERE clause? A. FULL OUTER JOIN keywords B. RIGHT OUTER JOIN keywords C. LEFT OUTER JOIN keywords D. outer join operator (+)

C. JOIN...ON

Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column? A. NATURAL JOIN B. JOIN...USING C. JOIN...ON D. none of the above

C. CROSS JOIN

Which of the following keywords is used to create a Cartesian join? A. OUTER JOIN B. NATURAL JOIN C. CROSS JOIN D. JOIN...USING

D. all of the above

Which of the following keywords is used to create an equality join? A. NATURAL JOIN B. JOIN...USING C. JOIN...ON D. all of the above

f

Which of the following lists all books published by the publisher named Printing Is US? A. SELECT title FROM books NATURAL JOIN publisher WHERE name='PRINTING IS US'; B. SELECT title FROM books, publisher WHERE pubname=1; C. SELECT * FROM books b, publisher p JOIN tables ON b.pubid = p.pubid WHERE name='PRINTING IS US'; D. none of the above

r

Which of the following operators in not allowed in an outer join? A. AND B. = C. OR D. >

p

Which of the following queries contains a non-equality join? A. SELECT title, authorid FROM books, bookauthor WHERE books.isbn = bookauthor.isbn AND retail>20; B. SELECT title, name FROM books JOIN publisher USING (pubid); C. SELECT title, gift FROM books, promotion WHERE retail>=minretail AND retail <= maxretail; D. None of the above

q

Which of the following queries contains an equality join? A. SELECT title, authorid FROM books, bookauthor WHERE books.isbn = bookauthor.isbn AND retail>20; B. SELECT title, name FROM books CROSS JOIN publisher; C. SELECT title, gift FROM books, promotion WHERE retail >=minretail AND retail <=maxretail; D. None of the above

s

Which of the following queries creates a Cartesian join? A. SELECT title, authorid FROM books, bookauthor; B. SELECT title, name FROM books CROSS JOIN publisher; C. SELECT title, gift FROM books NATURAL JOIN promotion; D. All of the above

n

Which of the following queries is valid? A. SELECT b.title, b.retail, o.quantity FROM books b NATURAL JOIN orders od NATURAL JOIN orderitems o WHERE od.order#=1005; B. SELECT b.title, b.retail, o.quantity FROM books orders.od, orderitems o WHERE orders.order#=1005 = orderitems.order# AND orderitems.isbn=books.isbn AND od.order#=1005; C. SELECT b.title, b.retail, o.quantity FROM books b, orderitems 0 WHERE o.isbn = b.isbn AND o.order#=1005; D. None of the above

D. All of the above

Which of the following queries will display data from both the ORDERS and CUSTOMERS tables? 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

D. both a and b

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? 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

C. Both

Which of the following queries will return the same results as the following SQL statement? --- SELECT c.customer#, lastname, firstname, order# FROM customers c, orders o WHERE c.customer# = o.customer#; A. SELECT customer#, lastname, firstname, order# FROM customers NATURAL JOIN orders; B. SELECT customer#, lastname, firstname, order# FROM customers JOIN orders USING (customer#); (in this case they are both right C. Both

B. INTERSECT

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

A. UNION

Which of the following set operators will display only the unique results of the combined SQL statements? A. UNION B. INTERSECT C. UNION ALL D. MINUS

C. UNION ALL

Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows? A. UNION B. INTERSECT C. UNION ALL D. MINUS

d

Which of the following statements about an outer join between two tables is true? A. If the relationship between the tables is established with a WHERE clause, both tables can include the outer join operator. B. To include unmatched records in the results, the record is paired with a NULL record in the deficient table. C. The RIGHT, LEFT, AND FULL keywords are equivalent. D. all of the above E. none of the above

A. common column

Which of the following terms refers to a column with equivalent data that exists in two or more tables? A. common column B. inner columns C. equity column D. simple columns

C. equality join

Which of the following types of joins is created by matching equivalent values in each table? A. Cartesian join B. non-equality join C. equality join D. outer join

B. self-join

Which of the following types of joins refers to joining a table to itself? A. Cartesian join B. self-join C. equality join D. outer join

D. Cartesian join

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

C. SELECT title FROM orders o, orderitems oi, books b WHERE b.isbn = oi.isbn AND oi.order# = o.order# AND (orderdate-pubdate)/365 >= 3;

Which of the following will display all books that were published at least three years before they were ordered? A. SELECT title FROM customers NATURAL JOIN orders NATURAL JOIN orderitems NATURAL JOIN books WHERE orderdate - pubdate >= 3; B. SELECT title FROM orders o, orderitems oi, books b WHERE b.isbn = oi.isbn AND oi.order# = o.order# AND orderdate - pubdate >= 3; C. SELECT title FROM orders o, orderitems oi, books b WHERE b.isbn = oi.isbn AND oi.order# = o.order# AND (orderdate-pubdate)/365 >= 3; D. none of the above

A. SELECT title, pubdate, name FROM publisher JOIN books USING (pubid)

Which of the following will display the title, publication date, and publisher name of each book in the BUSINESS category? 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';

C. Set operators

__________ __________ are used to combine the results of two (or more) SELECT statements. A. Equality operators B. From keywords C. Set operators D. Mathematical operators


Related study sets

Objective E: El Nino, La Nina sets

View Set

Combo with CA LIFE STATE PRACTICE EXAM PT 2(FROM EXAM FX ONLINE TEST) and 1 other

View Set

Mechanical and Chemical Digestion

View Set

Module 5 Section A : Inventory Planning

View Set