View the exhibit and examine the description of SALES and PROMOTIONS tables.

You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low price as values.
Which three DELETE statements are valid? (Choose three.)

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index- organized table. (Choose two.)

Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

Which two statements are true about the SET VERIFY ON command?

Which two statements are true regarding the GROUP BY clause in a SQL statement?
(Choose two.)

View the exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement?