You work as a Database Administrator for Domain.com. You have created a table named
Students in a database. You want to add a PRIMARY KEY constraint to the Student_ID column of
the Students table. Which of the following statements will you use to accomplish the task?
A.
UPDATE TABLE Students
ADD CONSTRAINT Stu_ID_pk PRIMARY KEY (Student_ID);
B.
ADD CONSTRAINT Stu_ID_pk PRIMARY KEY (Student_ID);
C.
ALTER TABLE Students
ADD CONSTRAINT Stu_ID_pk PRIMARY KEY (Student_ID);
D.
MODIFY CONSTRAINT Stu_ID_pk PRIMARY KEY (Student_ID);