CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 23

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)
DECODE
6. (TCO 9) Which of the following is not a valid SQL
command? (Points : 4)