| 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: -
Your knowledge of the DB2 UDB data types available and your ability to demonstrate when and how each of the data types available with DB2 UDB should be used. -
Your knowledge of the constraints available and your ability to identify when and how NOT NULL constraints, default constraints, check constraints, unique constraints, and referential integrity constraints should be used. -
Your ability to create a database table, using data types and constraints. -
Your ability to identify how operations performed on the parent table of a referential integrity constraint are reflected in the child table of the constraint. 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. | 