CIS 336 STUDY Extraordinary Life/cis336study.com CIS 336 STUDY Extraordinary 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 )