View the Exhibit and examine the structure of the ORDERS table.
Which UPDATE statement is valid?
A.
UPDATE orders
SET order_date = 12-mar-2007\ order_total IS NULL WHERE order_id = 2455;
B.
UPDATE orders
SET order_date = 12-mar-2007′, order_total = NULL WHERE order_id = 2455;
C.
UPDATE orders
SET order_date = ’12-mar-2007′
AND order_total = TO_NUMBER(NULL)
WHERE order_id = 2455;
D.
UPDATE orders
SET order_date = TO_DATE(’12-mar-2007,
l
,dd-mon-yyyy’)l SET order_total =
TO_NUMBER(NULL) WHERE order id = 2455;