View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables.In the ORDERS table, ORDER_ID is the PRI

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables.In the ORDERS table, ORDER_ID is the PRI

Post by answerhappygod »

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 theDEFAULT value as SYSDATE.Evaluate the following statement:UPDATE orders -SET order_date=DEFAULT -WHERE order_id IN (SELECT order_id FROM order_itemsWHERE qty IS NULL);What would be the outcome of the above statement?

A. The UPDATE statement would not work because the main query and the subquery use different tables.
B. The UPDATE statement would not work because the DEFAULT value can be used only in INSERT statements.
C. The UPDATE statement would change all ORDER_DATE values to SYSDATE provided the current ORDER_DATE is NOT NULL and QTY is NULL
D. The UPDATE statement would change all the ORDER_DATE values to SYSDATE irrespective of what the current ORDER_DATE value is for all orders where QTY is NULL
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply