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

SELECT order #, TO _ DATE ( shipdate , ' Month DD , YYYY ') FROM book _ order ;

4 . ( TCO 8 ) Based upon the contents of the BOOK _ ORDER table shown below , which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323 ?

( Points : 4 ) SELECT order #, SUBSTR ( shipzip , 1 , 323 ) FROM book _ order ; SELECT order #, SUBSTR ( shipzip , 1 , 323 ) FROM book _ order WHERE ; SELECT order # FROM book _ order WHERE ( shipzip , 1 , 323 ); SELECT order # FROM book _ order WHERE SUBSTR ( shipzip , 1 , 3 ) = 323 ;

5 . ( TCO 8 ) Which of the following functions determines the number of characters in a character string ? ( Points : 4 )