Workshop
The following workshop is composed of a series of quiz questions and practical exercises. The quiz questions are designed to test your overall understanding of the current material. The practical exercises are intended to afford you the opportunity to apply the concepts discussed during the current hour, as well as build upon the knowledge acquired in previous hours of study. Please take time to complete the quiz questions and exercises before continuing. Refer to Appendix C, "Answers to Quizzes and Exercises," for answers.
Quiz
Match the Descriptions with the possible Functions.
| DESCRIPTIONS | FUNCTIONS | |
|---|---|---|
| a. | Used to select a portion of a character string. | || RPAD LPAD |
| b. | Used to trim characters from either the right or left of a string. | LENGTH UPPER |
| c. | Used to change all letters to lowercase. | LTRIM RTRIM LOWER |
| d. | Used to find the length of a string. | SUBSTR |
| e. | Used to combine strings. |
| 1: | True or false: Using functions in a select statement to restructure the appearance of data in output will also affect the way the data is stored in the database. |
| 2: | True or false: The outermost function is always resolved first when functions are embedded within other functions in a query. |
Exercises
| 1: | Use the appropriate function to convert the string hello to all uppercase letters. |
| 2: | Use the appropriate function to print only the first four characters of the string JOHNSON. |
| 3: | Use the appropriate function to concatenate the strings JOHN and SON. |
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.