1. What are the two types of tables that can be created in a RDBMS?   Local and Global   Static and Dynamic   Permanent and Temporary   Hint Half-n-half Clue   2. What are the type of temporary tables that can be created in a RDBMS?   Local and Global   Static and Dynamic   No sub-types of temporary tables exist   Persistent and Non-Persistent   Half-n-half Clue   3. The ON COMMIT clause can be applied to _______ tables.   permanent   temporary   both temporary and permanent   Half-n-half Clue   4. Which of the following are valid column constraints: A. NULL B. DISTINCT C. CHECK D. FOREIGN KEY   A   C   C, D   All of the above   Half-n-half Clue   5. Which of the following are valid table constraints: A. PRIMARY KEY B. UNIQUE C. CHECK D. FOREIGN KEY   A and D   B and C   A, C and D   All of the above   Half-n-half Clue   6. Table constraints can be applied to individual columns and groups of columns.   True   False   7. Which of the following are valid referential integrity constraint optional clauses for ON DELETE: A. NO ACTION B. CASCADE C. SET NULL D. SET DEFAULT   A and B   A, B and C   A, B and D   All of the above   Half-n-half Clue