Which of the following DML operations use a significant portion of the PGA? (Choose all that apply.)

Answer: A,B,D,E

Explanation: In addition to hash joins, bulk load operations, bitmap merge, and bitmap create operations, the PGA is used for sorting operations triggered by ORDER BY, GROUP BY, and ROLLUP, any of which are used in a SELECT statement. C is incorrect because full table scans use an insignificant amount of memory in the PGA but a significant amount of memory in the SGA buffer cache.