Question:You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.
Which of the following statements will accomplish this task? 

A ALTER TABLE students ADD PRIMARY KEY student_id; 
B ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id); 
C ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id; 
D ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id); 
E ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id); 

+ Answer
D 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description