Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 200

Examine this statement:

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

The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.

The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.

The primary key constraint on EMP_ID must have a name.

One of the LONG columns must be changed to a VARCHAR2 or CLOB.

The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.

Correct Answer: B, D

For the CREATE TABLE statement to execute successfully, two changes must be made. First, the NOT NULL constraint on ENAME must be defined at the column level instead of the table level. This is because NOT NULL constraints are typically specified immediately following the column definition. Second, only one LONG column is allowed per table in Oracle SQL. Therefore, one of the LONG columns must be changed to a VARCHAR2 or CLOB.

Discussion

jfc1Options: 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) );

amizhOptions: DE

Only one LONG column is allowed per table. refer: https://docs.oracle.com/cd/A58617_01/server.804/a58241/ch5.htm#418225

yaya32Options: BD

BD correct answer

lucemqyOptions: BD

Must be BD NOT NULL must be declared at column level and only one Long column is allowed

zouveOptions: BD

BD only one Long per table