Database Reference
In-Depth Information
•
SQL can be used at the command prompt, or embedded in other
high-level language programs.
•
SQL brings a number of significant advantages to the software
engineering industry.
SQL is not without a fair amount of limitations. In order to fully understand the
limitations, you need to have a working knowledge of the language first. With this in
mind, a discussion of these limitations is left for chapter 15.
The next chapter discusses the main DDL statements of SQL. As you will see, they
are easy to learn and use.
10.4 Review Questions
1.
What are the most common DDL statements of SQL? Briefly
explain the purpose of each.
2.
What are the main DML statements of SQL? Briefly explain
the purpose of each.
3.
Explain the three categories of DCL statements in SQL.
4.
Identify some of the advantages of SQL.
10.5 Recommended Readings
[Eisenberg, 2000] Eisenberg, Andrew and Jim Melton. “SQL Standardization: The Next
Step.”
SIGMOD Record
Vol.29, no.1, March 2000. pp. 63 - 67.
[Kulkarni, 2003] Kulkarni, Krishna.
Overview of SQL:2003
. San Jose, CA: Silicon Valley
August 2008).
[WISC, 2008] Whitemarsh Information Systems Corp.
SQL.
http://www.wiscorp.com/
SQLStandards.html
(accessed August 2008).
