Database Reference
In-Depth Information
14.7 Review Questions
1.
Discuss the importance of the system catalog in a
database system.
2.
State some commonly referenced catalog tables.
3.
Discuss three important catalog tables, and explain how their
use can help in the management of a database.
4.
The PL/SQL
Describe
statement allows you to view the
structure of a database table. Write an equivalent
Select
statement on the system catalog, that provides the same
information. Use one of the tables in the sample college
database as your frame of reference.
5.
Review the as many of the catalog views listed in Figure
14-6
as possible, and practice writing
Select
statements on them.
6.
Explain clearly, how the system catalog is maintained. Provide
useful examples.
14.8 References and/or Recommended Readings
[Couchman, 1999] Couchman, Jason and Christopher Allen.
Oracle Certified Professional:
Application Developer Guide
. New York, NY: Osborne/McGraw-Hill, 1999. See Chapter 3.
[Martin, 1995] Martin, James, and Joe Leben.
Client/Server Databases: Enterprise
Computing
. Upper Saddle River, NJ: Prentice Hall, 1995. See Chapter 5.
[Oracle, 2008] Oracle Corporation.
SQL Reference
.
http://www.oracle.com/technology/index.html
(accessed August 2008).
[Ullman, 1997] Ullman, Jeffrey D., and Jennifer Widom.
A First Course in Database
Systems
. Upper Saddle River, NJ: Prentice Hall, 1997. See Chapter 7.
