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