Oracle Exam 1Z0-071 Topic 6 Question 43 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 43
Topic #: 6

[All 1Z0-071 Questions]

Examine these statements:

CREATE TABLE dept (

deptno NUMBER PRIMARY KEY,

diname VARCHAR2(10) ,

mgr NUMBER ,

CONSTRAINT dept_fkey FOREIGN KEY(mgr) REFERENCES emp (empno));

CREATE TABLE emp (

Empno NUMBER PRIMARY KEY,

Ename VARCHAR2 (10) ,

deptno NUMBER,

CONSTRAINT emp_fkey FOREIGN KEY (deptno) REFERENCES dept (deptno) DISABLE);

ALTER TABLE emp MODIFY CONSTRAINT emp_fkey ENABLE;

Which two are true?

AThe MGR column in the DEPT table will not be able to contain NULL values.

BThe CREATE TABLE EMP statement must precede the CREATE TABLE DEPT statement for all threestatements to execute successfully.

CBoth foreign key constraint definitions must be removed from the CREATE TABLE statements, andbe added with ALTER TABLE statements once both tables are created, for the two CREATE TABLEstatements to
execute successfully in the order shown.

DThe DEFT FKEY constraint definition must be removed from the CREATE TABLE DEF statement.and be added with an AITER TABLE statement once both tables are created, for the two CREATE TABLE statements
to execute successfully in the order shown.

EThe Deptno column in the emp table will be able to contain nulls values.

FAll three statements execute successfully in the order shown

Show Suggested Answer

Suggested Answer: D, E

by Yolando at May 03, 2022, 10:46 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Nghi Nguyen

3 years ago

D, E is correct. I tested statement 2 alone and it did not work even with the DISABLE keyword.

upvoted 1 times

...