YOU HAVE A TABLE NAMED ORDERS. YOU MUST MAKE SURE THAT THE ORDER D...

17. You have a table named Orders. You must make sure that the order date for each order occurs before the ship date. What is the best way to achieve this?A. Create a CHECK constraint using CHECK (OrderDate > ShipDate) statement.B. Create a CHECK constraint using CHECK (OrderDate < ShipDate) C. Create an INSTEAD OF INSERT, UPDATE trigger.D. Create a FOR INSERT, UPDATE trigger.