Which statement would you use to add a primary key constraint to the patient table using the id_number column, immediately enabling the constraint?
Answer options
A
ALTER TABLE patient ADD CONSTRAINT pat_id_pk PRIMARY KEY(id_number);
B
ALTER TABLE patient ADD PRIMARY KEY;
C
CREATE CONSTRAINT pat_id_pk PRIMARY KEY ON patient(id_number);
D
ALTER patient ADD CONSTRAINT pat_id_pk PRIMARY KEY(id_number);
Correct answer: ALTER TABLE patient ADD CONSTRAINT pat_id_pk PRIMARY KEY(id_number);
Explanation
Quick AnswerThe correct answer is ALTER TABLE patient ADD CONSTRAINT pat_id_pk PRIMARY KEY(id_number); because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.