View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables. In the ORDERS table, ORDER_ID is the PRIMARY KEY and ORDER_DATE has the DEFAULT value as SYSDATE. Evaluate the following statement:

UPDATE orders SET order_date=DEFAULT WHERE order_id IN (SELECT order_id FROM order_items WHERE qty IS NULL); What would be the outcome of the above statement?

Question

View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables. In the ORDERS table, ORDER_ID is the PRIMARY KEY and ORDER_DATE has the DEFAULT value as SYSDATE. Evaluate the following statement:

UPDATE orders SET order_date=DEFAULT WHERE order_id IN (SELECT order_id FROM order_items WHERE qty IS NULL); What would be the outcome of the above statement?

Accepted Answer

D. The UPDATE statement would change all the ORDER_DATE values to SYSDATE irrespective of what

Answer

A. The UPDATE statement would not work because the main query and the subquery use different tables.

Answer

B. The UPDATE statement would not work because theDEFAULTvaluecan be used only in INSERT statements.

Answer

C. The UPDATE statement would change all ORDER_DATE values to SYSDATE provided the current

View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables. In the ORDERS table, ORDER_ID is the PRIMARY KEY and ORDER_DATE has the DEFAULT value as SYSDATE. Evaluate the…

Question

Exhibit

Options

How the community answered

Community Discussion