Multiple choice technology databases

what is anonymous block in pl/sql?

  1. consists of procedures and functions stored in database as standalone.

  2. block that is associated with an event that occurs in database

  3. constructed dynamically and executed once.

  4. none if these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

An anonymous block in PL/SQL is a block of code that is not stored in the database with a name. It is constructed dynamically, compiled, and executed once during a session. Producures/functions are stored blocks, while triggers are associated with database events.

Keep practicing — related questions