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)