Multiple choice technology databases

Oracle engine creates Cursors for every SELECT statements.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle does NOT create cursors for every SELECT statement. Cursors are created only for SELECT statements that return rows (queries, not SELECT...INTO statements). SELECT statements used in INTO clauses (singleton selects) or SQL embedded in PL/SQL that don't return multiple rows don't necessarily create cursors in the same way. Also, some SELECT operations may be optimized differently. The blanket statement 'every SELECT' is too broad and incorrect.

Keep practicing — related questions