Oracle
1Z0-007 · Question #186
1Z0-007 Question #186: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #186. The question stem and answer options stay visible for context.
Question
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?
Options
- AALTER TABLE students ADD PRIMARY KEY student_id;
- BALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
- CALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
- DALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
- EALTER TABLE studentsMODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.