CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 22

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; SELECT order #, TO _ CHAR( shipdate, ' Month DD, YYYY ') FROM book _ order;