DB2 Universal Database V8.1 Certification Exam 700 Study Guide
| Nineteen percent (19%) of the DB2 UDB V8.1 Family Fundamentals certification exam (Exam 700) is designed to test your ability to identify the data types and constraints that are available with DB2 Universal Database, as well as to test your knowledge of when and how each one should be used in a table definition. The questions that make up this portion of the exam are intended to evaluate the following:
This chapter is designed to introduce you to the data types and constraints that are available with DB2 Universal Database and to show you how to construct DB2 UDB base tables using any combination of each. Terms you will learn: Small Integer SMALLINT Integer INTEGER INT Big Integer BIGINT Decimal Sign Precision Scale DECIMAL DEC NUMERIC NUM Single-Precision Floating-Point REAL Double-Precision Floating-Point DOUBLE DOUBLE PRECISION FLOAT Fixed-Length Character String CHARACTER CHAR Varying-Length Character String CHARACTER VARYING CHAR VARYING VARCHAR Long Varying-Length Character String LONG VARCHAR Fixed-Length Double-Byte Character String GRAPHIC Varying-Length Double-Byte Character String VARGRAPHIC Long Varying-Length Double-Byte Character String LONG VARGRAPHIC Date DATE Time TIME Timestamp TIMESTAMP Binary Large Object BLOB Character Large Object CLOB Double-Byte Character Large Object DBCLOB DataLinks DB2 Extender User-Defined Data Type NOT NULL Constraint Default Constraint Check Constraint Unique Constraint Referential Integrity Constraint Referential Constraint Foreign Key Constraint Unique Key Primary Key Foreign Key Parent Key Parent Table Parent Row Dependent Table Child Table Dependent Row Child Row Descendant Table Descendant Row Referential Cycle Self-Referencing Table Self-Referencing Row ON UPDATE NO ACTION ON UPDATE RESTRICT ON DELETE CASCADE ON DELETE SET NULL ON DELETE NO ACTION ON DELETE RESTRICT "Check Pending" Base Table Declared Temporary Table Techniques you will master: Recognizing the available built-in data types and understanding when each is to be used. Understanding how NOT NULL constraints, default constraints, check constraints, unique constraints, and referential constraints are defined. Understanding what NOT NULL constraints, default constraints, check constraints, unique constraints, and referential constraints are used for. Understanding how a base table is created. Recognizing how operations performed on the parent table of a referential integrity constraint are reflected in the child table of the constraint. |