Oracle Database: Advanced PL/SQL — Question 50

Which three statements can process a dynamic multi-row query? (Choose three.)

Answer options

• A. DECLARE
• B. OPEN
• C. INTO
• D. OPEN-FOR
• E. FETCH
• F. WHEN
• G. CLOSE

Correct answer: D, E, G

Explanation

The correct answers are D, E, and G because OPEN-FOR initiates the execution of the dynamic query, FETCH retrieves the rows of data, and CLOSE terminates the query execution. The other options, DECLARE, OPEN, INTO, and WHEN, do not directly process a dynamic multi-row query.