CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 24

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); INSERT INTO promotion( gift, minretail, maxretail) VALUES(' FREE BOOK ', 75.01, 89.99);

INSERT INTO promotion VALUES( FREE BOOK, 75.01, 89.99);

INSERT INTO promotion( gift, minretail)