Quiz

1. What is wrong with this statement?

   CREATE TABLE new_table (
   first_col number,
   second_col date
   third_col number default sysdate);
   

2. Describe a SQL statement that might result in the following Oracle error message?

   ORA-02266: unique/primary keys in table referenced by
   Âenabled foreign keys
   

3. What is the difference between a column and table check constraint?

Exercise

The Instructor table has a column named Position. In the current design of this table, there is a CHECK constraint on the Position column that restricts the value to ASSISTANT PROFESSOR, ASSOCIATE PROFESSOR, and FULL PROFESSOR. Modify the database design so that an additional table, INSTRUCTOR_POSITION, is used to specify legal values for instructor position.