Question

To include integrity constraint in an existing relation use :

(a) Create table

(b) Modify table

(c) Alter table

(d) Drop table

I got this question in an online quiz.

Question is from Integrity Constraints in chapter SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Correct option is (c) Alter table

Best explanation: SYNTAX – alter table table-name add constraint, where constraint can be any constraint on the relation.