BIS 345 MENTOR Keep Learning /bis345mentor.com BIS 345 MENTOR Keep Learning /bis345mentor.com | Page 12

WHERE
INSERT
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
Question 6.6. (TCO 1) Given Professors table with LastName,
FirstName, and MI fields, which of the following would select all fields
from the table? (Points : 5)
SELECT * FROM Professors;
SELECT * Professors;
SELECT Last Name, First Name, MI FROM Professors;
SELECT * ALL