| | Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens | | Table of Contents | | | | Appendix C. Answers to Quizzes and Exercises |
Hour 24, "Extensions to Standard SQL" Quiz Answers | 1: | Is SQL a procedural or non-procedural language? | | A1: | SQL is non-procedural, meaning that the database decides how to execute the SQL statement. The extensions discussed during this hour were procedural. | | 2: | What are some of the reasons differences in SQL exist? | | A2: | Differences exist in SQL among the vendors because of storage requirements, advantages over competitors , ease of use, and performance considerations. | | 3: | What are the three basic operations of a cursor, outside of declaring the cursor? | | A3: | OPEN, FETCH, and CLOSE. | | 4: | Procedural or non-procedural: With which does the database engine decide how to evaluate and execute SQL statements? | | A4: | Non-procedural. | Exercise Answers | Q1: | Try some research about the SQL variations among the various vendors. Go to the following Web sites and review the implementations of SQL that are available: www.oracle.com www.sybase.com www.microsoft.com www.mysql.com www.informix.com www.pgsql.com www.ibm.com www.sap.com/sabdb/ | | A1: | No specific answer. | |
|