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
| 1: | Try some research ... |
Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
