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 '