Oracle
1Z0-071 · Question #212
1Z0-071 Question #212: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #212. The question stem and answer options stay visible for context.
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 NOY NULL(ename)); Identify two reasons for the error.
Options
- AThe NOT NULL constraint on the ENAME column must be defined as the column level
- BFOREIGN KEY defined on the DEPT_ID column must be at the table level only
- COnly one LONG column can be used per table
- DThe FOREIGN KEY keyword is missing in the constraint definition
- EThe PRIMARY KEY constraint in the EMP_ID column must have a name and must be defined at
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.