Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?

The correct answer is B. CREATE TABLE EMP. This statement provides correct syntax to define the FOREIGN KEY constraint on the DEPTNO column of the EMP table. Incorrect Answers A: There is incorrect syntax, because list of columns and column for the constraint need to be surrounded with the brackets. C: It is incorrect…

Creating and Managing Schema Objects

Question

Options

ACREATE TABLE EMP
BCREATE TABLE EMP
CCREATE TABLE EMP
DCREATE TABLE EMP (empno NUMBER(4),

How the community answered

(42 responses)

A
7% (3)
B
76% (32)
C
14% (6)
D
2% (1)

Explanation

This statement provides correct syntax to define the FOREIGN KEY constraint on the DEPTNO column of the EMP table. Incorrect Answers A: There is incorrect syntax, because list of columns and column for the constraint need to be surrounded with the brackets. C: It is incorrect to use FOREIGN KEY keywords to define constraint on the table. It can be used to add integrity constraint to existing table. D: It is incorrect to use FOREIGN KEY keywords to define constraint on the table. It can be used to add integrity constraint to existing table.

Topics

#FOREIGN KEY#CREATE TABLE#REFERENCES clause#constraint definition

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice