Which UPDATE statement is valid?

View the Exhibit and examine the structure of the ORDERS table.
Which UPDATE statement is valid?

A. UPDATE ordersSET order_date = 12-mar-2007 order_total IS NULL WHERE order_id = 2455;
B. UPDATE ordersSET order_date = 12-mar-2007′, order_total = NULL WHERE order_id = 2455;
C. UPDATE ordersSET order_date = ’12-mar-2007’AND order_total = TO_NUMBER(NULL)WHERE order_id = 2455;
D. UPDATE ordersSET order_date = TO_DATE(’12-mar-2007,l,dd-mon-yyyy’)l SET order_total = TO_NUMBER(NULL) WHERE order id = 2455;

Download Printable PDF. VALID exam to help you PASS.