试题详情
单项选择题You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes 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);

  • D
  • 关注下方微信公众号,在线模考后查看

热门试题