Which two statements are true about the rules of precedence for operators? (Choose two.)

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

Which three object types support deferred segment creation? (Choose three.)

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?

Which two statements are true regarding a SAVEPOINT? (Choose two.)