CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 20

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)
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?