CIS 336 All Assignments CIS 336 All Assignments | Page 18

Page 3 - Multiple Choice
1. (TCO 7) Using the BOOK_CUSTOMER and BOOK_ORDER tables shown below for references,
which SQL statement will return the same results as the following SQL statement?
SELECT * FROM book_customer, book_order;
(Points : 4)
SELECT * FROM book_order CROSS JOIN book_customer;
SELECT * FROM book_order, book_customer
WHERE book_order.customer# = book_customer.customer#;
SELECT * FROM book_order, book_customer
WHERE book_order.customer# >book_customer.customer#;
SELECT * FROM o book_order , c book_customer
WHERE o.customer# = c.customer#;
2. (TCO 7) If a Cartesian join is used to link table A which contains five rows to table B which
contains eight rows, there will be _______ rows in the results. (Points : 4)
8
13
5
40
3. (TCO 8) Based upon the contents of the BOOK_ORDER table shown below, which of the
following SQL statements will display the ship date for order 1006 as April 2, 2002?
(Points : 4)
SELECT order#, TO_CHAR(shipdate, 'fmMonth DD, YYYY')
FROM book_order;
SELECT order#, TO_DATE(shipdate, 'fmMonth DD, YYYY')
FROM book_order;