CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 23

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)
COUNT
NUMBER
LENGTH
DECODE
6. (TCO 9) Which of the following is not a valid SQL
command? (Points : 4)
UPDATE acctmanager SET WHERE ;
UPDATE acctmanager SET (amname);
UPDATE acctmanager SET (amname) WHERE ;
UPDATE acctmanager WHERE ;
7. (TCO 9) Using the promotion table shown below, which
of the following SQL statements will insert a new row into
the PROMOTION table?
(Points : 4)
INSERT INTO promotion (gift, minretail, maxretail)
VALUES (FREE BOOK, 75.01, 89.99);