CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 22

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;