Exam 1z0-071 All QuestionsBrowse all questions from this exam
Question 169

Examine the description of the ORDER_ITEMS table:

Examine this incomplete query:

Which two can replace so the query completes successfully?

    Correct Answer: A, C

    The query involves calculating the total amount paid (quantity * unit_price) and naming this calculation total_paid. To order the results by this calculated column, you can use either the expression (quantity * unit_price) or the alias (total_paid) in the ORDER BY clause. Therefore, the correct replacements for <clause> to successfully complete the query are 'quantity * unit_price' and 'total_paid'.

Discussion
lucemqyOptions: AC

AC is the answer checked

kesammy9Options: AC

AC is correct