You executed the following CREATE TABLE statement that resulted in an error: SQL

Question

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 NOT NULL (ename)): Identify two reasons for the error. D A) The FOREIGN KEY keyword is missing in the constraint definition. ? B) The NOT NULL constraint on the ENAME column must be defined at the column level tne enstralt the to cmmust have a namdust be dae at the table level only D D) FOREIGN KEY defined on the DEPT_ID column must be at the table level only. E) Only one LONG column can be used per table.

Explanation / Answer

The answer is option B and C.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.