1Z0-149: Oracle Database Program with PL/SQLDemo

By Oracle · Question Mode

QuestionQ37

PL/SQL Language Fundamentals

Which three statements can process a dynamic multi-row query?

Choose three
  • A DECLARE
  • B OPEN
  • C INTO
  • D OPEN-FOR
  • E FETCH
  • F WHEN
Explanation

A dynamic multi-row result set uses a declared cursor variable. An OPEN FOR statement associates that variable with the dynamic SELECT, and FETCH retrieves rows from its result set. The cursor should subsequently be closed; CLOSE is not available among the listed choices.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!