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'