Which UPDATE statement is valid?

Prev Question
Next Question

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

Exam 1Z0-047 - Which UPDATE statement is valid?
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′,’dd-mon-yyyy’), SET order_total = TO_NUMBER(NULL)
WHERE order_id = 2455;

Prev Question
Next Question

Leave a Reply

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