CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your Life/cis336study.com | Page 24

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)

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)