Which statement explicitly names a constraint?

The correct answer is C. ALTER TABLE student_grades. This statement provides correct syntax to add a foreign key constraint to the existing table. Incorrect Answers A: The ADD FOREIGN KEY is wrong construction to add a foreign key constraint to the existing B: The ADD CONSTRAINT NAME is wrong construction to add a foreign key…

Monitor and Troubleshoot a XenDesktop 7 Environment

Question

Options

AALTER TABLE student_grades
BALTER TABLE student_grades
CALTER TABLE student_grades
DALTER TABLE student_grades
EALTER TABLE student_grades

How the community answered

(27 responses)

A
4% (1)
B
15% (4)
C
74% (20)
E
7% (2)

Explanation

This statement provides correct syntax to add a foreign key constraint to the existing table. Incorrect Answers A: The ADD FOREIGN KEY is wrong construction to add a foreign key constraint to the existing B: The ADD CONSTRAINT NAME is wrong construction to add a foreign key constraint to the D: The ADD NAMED CONSTRAINT is wrong construction to add a foreign key constraint to the E: The ADD NAME is wrong construction to add a foreign key constraint to the existing table.

Topics

#SQL constraints#ALTER TABLE#named constraints#SQL DDL

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice