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
| 1: | Is SQL a procedural or non-procedural language? |
| 2: | What are some of the reasons differences in SQL exist? |
| 3: | What are the three basic operations of a cursor, outside of declaring the cursor? |
| 4: | Procedural or non-procedural: With which does the database engine decide how to evaluate and execute SQL statements? |
Exercises
| 1: | Try some research about the SQL variations among the various vendors. Go to a library or bookstore and look for vendor-specific books on SQL. Compare various SQL statements, such as Data Manipulation Language (DML). Compare the INSERTs, DELETEs, and UPDATEs for the differences. You might also look for an ANSI SQL book in which to make comparisons. |
| 2: | Using the EMPLOYEE_TBL (see Appendix D, "CREATE TABLE Statements for Book Examples"), write the interactive SQL statement that returns the name of all employees who have a ZIP code of 46234. |
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.