CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 14

SELECT DISTINCT COUNT ( category ) FROM books ; SELECT DISTINCT ( COUNT ( category )) FROM books ; SELECT DISTINCT COUNT ( category ) FROM books ;

4 . ( TCO 8 ) The _____________ function can be used to display upper-case characters in lower-case . ( Points : 4 )

CONVERT MIN LESS LOWER

5 . ( TCO 8 ) Which of the following statements will produce the value 21.1 ? ( Points : 4 )

SELECT ROUND ( 21.12 , 1 ) FROM dual ; SELECT ROUND ( 21.12 , -1 ) FROM dual ; SELECT ROUND ( 21.12 , 0 ) FROM dual ; SELECT ROUND ( 21.12 , 0 +) FROM dual ;

6 . ( TCO 9 ) The column to be updated by the UPDATE command is specified in the ______ clause . ( Points : 4 )

UPDATE SET WHERE

SELECT DISTINCT COUNT ( category ) FROM books ; SELECT DISTINCT ( COUNT ( category )) FROM books ; SELECT DISTINCT COUNT ( category ) FROM books ;

4 . ( TCO 8 ) The _____________ function can be used to display upper-case characters in lower-case . ( Points : 4 )

CONVERT MIN LESS LOWER

5 . ( TCO 8 ) Which of the following statements will produce the value 21.1 ? ( Points : 4 )

SELECT ROUND ( 21.12 , 1 ) FROM dual ; SELECT ROUND ( 21.12 , -1 ) FROM dual ; SELECT ROUND ( 21.12 , 0 ) FROM dual ; SELECT ROUND ( 21.12 , 0 +) FROM dual ;

6 . ( TCO 9 ) The column to be updated by the UPDATE command is specified in the ______ clause . ( Points : 4 )

UPDATE SET WHERE