1Z0-071 Web TestEngine demo

Examine this statement:

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

Select all that apply.

• 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.