> > >

Oracle SQL 9i MCQs

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?

ALTER TABLE students ADD PRIMARY KEY student_id;

ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id); <br>

Answer

Correct Answer: ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle SQL 9i Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it