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

Identify the correctly constructed ALTER TABLE statement to add a UNIQUE constraint to the column user_number with the constraint name user_number_unique on the table called 'user'.
a.)
ALTER TABLE user ADD CONSTRAINT user_number UNIQUE (user_number_unique);
b.)
ALTER TABLE user ADD CONSTRAINT user_number UNIQUE (user_number);
c.)
ALTER TABLE user ADD UNIQUE user_number CONSTRAINT (user_number_unique);
d.)
ALTER TABLE user ADD CONSTRAINT user_number_unique UNIQUE (user_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!