CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 12

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 COL