1.( TCO 1) Which of the following portions of an SQL Statement indicate the columns that should be included in the result set?( Points: 5)
SELECT FROM 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