Which statement is true regarding the above commands?

Examine the structure of the SHIPMENTS table: You want to generate a report that displays
the PO_ID and the penalty amount to be paid if the SHIPMENT_DATE is later than one
month from the PO_DATE. The penalty is $20 per day. Evaluate the following two queries:
Which statement is true regarding the above commands?

Examine the structure of the SHIPMENTS table: You want to generate a report that displays
the PO_ID and the penalty amount to be paid if the SHIPMENT_DATE is later than one
month from the PO_DATE. The penalty is $20 per day. Evaluate the following two queries:
Which statement is true regarding the above commands?

A.
Only the first query executes successfully but gives a wrong result.

B.
Only the second query executes successfully and gives the correct result.

C.
Only the first query executes successfully and gives the correct result.

D.
Both execute successfully and give correct results.

E.
Only the second query executes successfully but gives a wrong result.



Leave a Reply 0

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