Which UPDATE statement is valid?

View the Exhibit and examine the structure of the ORDERS table.

Which UPDATE statement is valid?

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;



Leave a Reply 0

Your email address will not be published. Required fields are marked *