Hour 24, Extensions to Standard SQL

Team-Fly    

 
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.


Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net