Database Practice Exercise: Character String Functions Several of the following questions refer to a demonstration table named Student. [For background on character string functions, refer to chapter 9.] 1. Project all columns from Student for the sName that sounds like 'foreman'. 2. Query the Student table for a list of names and majors. Use the LOWER(string) function to show the major column in lower case letters. 3. Apply the CONCAT(str1,str2,...) function to concatenate student name and class year which are to be listed under the synonym 'Advisees'. 4. Retrieve a list of student names and majors from Student. Apply the right pad function -- RPAD (string,length[,'chars'] -- to the string sName using length 30 and fill with period characters. 5. Query Student for name and name length. Determine the length with the LENGTH(string) function. Order by descending length value. 6. Apply LOCATE('charS',charVar[,start]) to find the column position for each student's initial (follows a comma) in the table named StudentWithInit (version having sName with lastName value then a comma followed by an initial). 7. Project student initial and last name from StudentWithInit. Extract with SUBSTRING(strVar,startPos[,len]) nesting LOCATE() to point to the position of the initial. Last name starts in position 1 and ends before the comma.