JOIN... ON JOIN... USING JOIN... WHERE
3.( TCO 8) Based upon the contents of the BOOKS table shown below, which of the following SQL statements will return the number of categories contained in the table?
( Points: 4) SELECT COUNT( DISTINCT category) FROM books; 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 lowercase.( 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