Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

© examsnet.com

Question : 16 of 50

Marks: +1, -0

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?

Both execute successfully and give correct results.
Only the first query executes successfully but gives a wrong result.
Only the first query executes successfully and gives the correct result.
Only the second query executes successfully but gives a wrong result.
Only the second query executes successfully and gives the correct result.

Go to Question:

Advertisements