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