CIS 336 STUDY Extraordinary Life/cis336study.com CIS 336 STUDY Extraordinary Life/cis336study.com | Page 12

2 . ( TCO 7 ) Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column ? ( Points : 4 )
NATURAL JOIN 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 lower-case . ( Points : 4 )
CONVERT MIN LESS LOWER

2 . ( TCO 7 ) Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column ? ( Points : 4 )

NATURAL JOIN 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 lower-case . ( Points : 4 )

CONVERT MIN LESS LOWER