Exam 1z0-071 topic 1 question 209 discussion

Actual exam question from Oracle's 1z0-071

Question #: 209
Topic #: 1

[All 1z0-071 Questions]

Examine this statement:

Which two things must be changed for it to execute successfully? (Choose two.)

A. The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.
B. The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.
C. The primary key constraint on EMP_ID must have a name.
D. One of the LONG columns must be changed to a VARCHAR2 or CLOB.
E. The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.

Show Suggested Answer

Suggested Answer: BD 🗳️

by jfc1 at Feb. 16, 2023, 2:59 p.m.

Comments

Submit Cancel

jfc1

Highly Voted 1 year, 10 months ago

Selected Answer: BD

BD is the correct answer. You can test this : Create table hr.test_employees (emp_id number (5) primary key, Ename varchar2(15) not null, Email varchar2(40) unique, Address long, Resume clob, Department_id number(4) constraint emp_dept_id_fx references hr.departments(department_id) );

upvoted 8 times

...