1Z0-082 Exam Dumps | View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables. You want to display PROD

<< Prev Question Next Question >>

Question 5/41

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?

A. It executes successfully and gives the required result

B. It gives an error because the ALL keyword is not valid

C. It executes successfully but does not give the required result

D. It gives an error because the GROUP BY clause is not valid

Question 5/41

LEAVE A REPLY

Download PDF File