Which syntax turns an existing constraint on?

The correct answer is C. ALTER TABLE table_name. ALTER TABLE statement with ENABLE CONSTRAINT keywords is correct answer to enable an existing constraint. Incorrect Answers A: This statement is missing CONSTRAINT keyword. B: "STATUS =" is incorrect syntax to enable constraint for the table. D: There is no STATUS keyword in…

Creating and Managing Schema Objects

Question

Options

AALTER TABLE table_name
BALTER TABLE table_name
CALTER TABLE table_name
DALTER TABLE table_name
EALTER TABLE table_name
FALTER TABLE table_name

How the community answered

(16 responses)

C
75% (12)
D
6% (1)
E
6% (1)
F
13% (2)

Explanation

ALTER TABLE statement with ENABLE CONSTRAINT keywords is correct answer to enable an existing constraint. Incorrect Answers A: This statement is missing CONSTRAINT keyword. B: "STATUS =" is incorrect syntax to enable constraint for the table. D: There is no STATUS keyword in the command to enable constraint. E: There is no TURN ON keywords in the command to enable constraint. F: There is no TURN ON keywords in the command to enable constraint.

Topics

#ALTER TABLE#ENABLE CONSTRAINT#constraint management#DDL syntax

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice