Oracle Exam 1Z0-082 Topic 1 Question 29 Discussion

Actual exam question for Oracle's 1Z0-082 exam

Question #: 29
Topic #: 1

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.

You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.

Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

AIt gives an error because the ALL keyword is not valid

BIt gives an error because the GROUP BY clause is not valid

CIt executes successfully but does not give the required result

DIt executes successfully and gives the required result

Show Suggested Answer

Suggested Answer: D

by Leatha at May 03, 2022, 05:51 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!