Question

You need to add a FOREIGN KEY constraint to the line_item_id column in the curr_order table to refer to the id column in the line_item table.

Which statement should you use to achieve this result?

	A.	ALTER TABLE curr_order ADD CONSTRAINT curr_order_fk FOREIGN KEY (line_item_id) REFERENCES line_item(id);
	B.	ALTER TABLE curr_order MODIFY (CONSTRAINT curr_order_fk FOREIGN KEY (line_item_id) REFERENCES line_item(id));
	C.	ALTER TABLE line_item ADD CONSTRAINT line_item_fk FOREIGN KEY (id) REFERENCES curr_order(line_item_id);
	D.	ALTER TABLE line_item MODIFY (CONSTRAINT line_item_fk FOREIGN KEY (id) REFERENCES curr_order(line_item_id);

Answer 1

Ans)

a)

ALTER TABLE curr_order ADD

CONSTRAINT curr_order_fk FOREIGN KEY (line_item_id) REFERENCES line_item(id);

_____________________Thank You