You executed the following CREATE TABLE statement that resulted in an error:
SQL> CREATE TABLE employees(emp_id NUMBER(10) PRIMARY KEY, ename VARCHAR2(20), email NUMBER(3) UNIQUE, address VARCHAR2(500), phone VARCHAR2(20), resume LONG, hire_date DATE, remarks LONG, dept_id NUMBER(3) CONSTRAINT emp_dept_id_fk REFERENCES departments (dept_id), CONSTRAINT ename_nn NOY NULL(ename));
Identify two reasons for the error.
A. The NOT NULL constraint on the ENAME column must be defined as the column level
B. FOREIGN KEY defined on the DEPT_ID column must be at the table level only
C. Only one LONG column can be used per table
D. The FOREIGN KEY keyword is missing in the constraint definition
E. The PRIMARY KEY constraint in the EMP_ID column must have a name and must be defined at the table level only
|
Download Printable PDF. VALID exam to help you PASS. |
 |
AC
PK and FK constraints can be defined both at the table and column level, but NOT NULL constraint can be defined only at the column level
C is also true
“Foreign Key” keyword must be specified when table level, in this case is column level, so it’s OK.
Correct Answers are AC.
AD