Database Reference
In-Depth Information
11.13 Review Questions
1.
What are the commonly used SQL definition statements?
2.
Use the Oracle DBCA component to create a database.
Practice writing SQL statements to create simple databases.
3.
Practice writing SQL statements to modify different aspects of
a database.
4.
Write SQL statement to add a tablespace to your database.
Create a second tablespace to hold the tables described in
your sample college database.
5.
Practice writing SQL statements to modify different aspects of
a tablespace.
6.
Write SQL statements to create the tables described in the
sample college database described in Chapter 7 (Figure 7-1).
7.
Write appropriate SQL statements to do the following:
•
Add a constraint to a table.
•
Modify a constraint.
•
Enable or disable a constraint.
8.
Write SQL statements to define indexes on your database
tables.
9.
Practice writing SQL statements to modify or drop indexes.
10.
By considering the
Student
table in your sample college
database, write SQL statement to create a sequence for this
table. Describe and demonstrate how this sequence could be
used.
11.
What is a synonym and how is it used in a database? Practice
writing SQL statements to create and drop a synonym.
11.14 References and/or Recommended
Readings
[Connolly, 2002] Connolly, Thomas and Carolyn Begg.
Database Systems: A Practical
Approach to Design, Implementation and Management
3
rd
ed. New York, NY: Addison-
Wesley, 2002. See Chapter 6.
[Couchman, 1999] Couchman, Jason and Christopher Allen.
Oracle Certified Professional:
Application Developer Guide
. New York, NY: Osborne/McGraw-Hill, 1999. See Chapters 3
and 4.
[Elmasri, 2007] Elmasri, Ramez and Shamkant B. Navathe.
Fundamentals of Database
Systems
5
th
ed. Reading, MA: Addison-Wesley, 2007. See Chapter 8.
