📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    Question

    What is the primary purpose of a PL/SQL

    `CURSOR`?
    A To execute DDL statements dynamically within a PL/SQL block. Correct Answer Incorrect Answer
    B To process a set of rows returned by a `SELECT` statement one by one. Correct Answer Incorrect Answer
    C To define a transaction boundary for `COMMIT` and `ROLLBACK` operations. Correct Answer Incorrect Answer
    D To handle exceptions and errors in PL/SQL blocks. Correct Answer Incorrect Answer
    E To create temporary tables for complex query results. Correct Answer Incorrect Answer

    Solution

    To process a set of rows returned by a `SELECT` statement one by one.

    Practice Next
    More SQL Questions
    ask-question