This chapter will prepare you for creating and using constraints to enforce business rules at the database layer. You will also learn how to use triggers and constraints to enforce data integrity rules. This chapter will introduce you to the key system catalog tables, which describe the physical and logical structure of the data stored in the database.
After the completion of this chapter, you will be able to demonstrate the ability to:
- Understand various constraints, such as NOT NULL, DEFAULT, CHECK, UNIQUE, referential integrity, and NOT ENFORCED informational constraints and to determine when and how to use them
- Create views with CHECK OPTION
- Use the SET INTEGRITY command
- Create and use triggers
- Understand constraint behavior in a column-organized database
- Examine the content of the system catalog tables
Certification test:
Number of questions...
Number of questions...