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 ;