BIS 345 MENTOR Great Stories Here/bis345mentor.com BIS 345 MENTOR Great Stories Here/bis345mentor.com

BIS 345 Final Exam Guide Set 1 FOR MORE CLASSES VISIT www.bis345mentor.com 1. (TCO 1) Which of the following sets of SQL clauses represent the minimum combination of clauses to make a working SQL statement? (Points : 5) SELECT, WHERE FROM, WHERE SELECT, FROM FROM, ORDER BY 2. (TCO 1) Which of the following would be considered a logical operator? (Points : 5) = >= AND IS NULL 3. (TCO 1) Which of the following is true about ORDER BY clauses? (Points : 5) The default order is ascending when none is specified. Numerical columns are sorted from highest to lowest where no sort order is specified. Columns on which sorting must be conducted cannot be identified by their position in their table. Character columns are evaluated from right to left. 4. (TCO 1) Which of the following would extract all rows containing the numbers 4 or 8? (Points : 5) WHERE number = 4 or number = 8 WHERE number BETWEEN 4 and 8 WHERE number = '4 or 8' Where number = '4' or '8'