Multiple choice technology databases

User_Source table contains code for which all Objects?

  1. Functions

  2. Package body

  3. Triggers

  4. Cursor
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

The Oracle data dictionary view USER_SOURCE stores the source code for stored PL/SQL objects including Functions, Package bodies, Procedures, and Triggers. Cursors are not stored objects - they are declared within PL/SQL blocks and are not stored in USER_SOURCE. The question tests understanding of which code objects have their source persisted in the data dictionary.

Keep practicing — related questions