Multiple choice technology programming languages

What are the types of cursors available in plsql?

  1. user defined

  2. implied

  3. implicit and explicit

  4. Implied and user defined
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

PL/SQL has two types of cursors: implicit cursors (automatically created by Oracle for SQL statements like SELECT) and explicit cursors (declared and managed by the programmer for finer control over row processing). The terminology is 'implicit' and 'explicit', not 'implied' or 'user defined'.

Keep practicing — related questions