View the exhibits and examine the structures of the COSTSand PROMOTIONStables.


Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs
WHERE promo_id IN (SELECT promo_id FROM promotions
WHERE promo_cost < ALL
( SELECT MAX(promo_cost) FROM promotions
GROUP BY (promo_end_date-
promo_begin_date)));
What would be the outcome of the above SQL statement?

View the Exhibit and examine the description for the SALES and CHANNELS tables. (Choose the best answer.)

You issued this SQL statement:

Which statement is true regarding the result?

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:

You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses.
Which SQL statement must you use?

Examine this SQL statement:

Which two are true?

Examine the structure of the PROMOTIONS table:

Management requires a report of unique promotion costs in each promotion category.
Which query would satisfy this requirement?