BIS 345 MENTOR Think Big /bis345mentor.com BIS 345 MENTOR Think Big /bis345mentor.com | Page 13
Question 2.2. (TCO 1) Which of the following operators uses wildcard
characters to search for patterns or characters in a character string?(Points
: 5)
SEARCH
LIKE
BETWEEN
EQUAL TO
Question 3.3. (TCO 1) Which of the following characters is used to merge
the output of two columns into one? (Points : 5)
AND
PLUS
+
;
Question 4.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'
Question 5.5. (TCO 1) Assume you have a table called CourseTable. You
would like to extract all courses that were developed in June and July of
2008. Which of the following operators would be of most use to you in your
WHERE clause? (Points : 5)
BETWEEN
LIKE
IS NULL
None of the above