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);
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.