CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 12
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 ?
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 ;
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 ?