Question: Identify the correctly constructed ALTER TABLE statement to add a UNIQUE constraint to the column phone _ number with the constraint name phone _ number

Identify the correctly constructed ALTER TABLE statement to add a UNIQUE constraint to the column phone_number with the constraint name phone_number_unique on the table called 'customer'.
a.)
ALTER TABLE customer ADD UNIQUE phone_number CONSTRAINT (phone_number_unique);
b.)
ALTER TABLE customer ADD CONSTRAINT phone_number UNIQUE (phone_number_unique);
c.)
ALTER TABLE customer ADD CONSTRAINT phone_number UNIQUE (phone_number);
d.)
ALTER TABLE customer ADD CONSTRAINT phone_number_unique UNIQUE (phone_number);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!