CIS 336 STUDY It's Your Life/cis336study.com CIS 336 STUDY It's Your 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)