Multiple choice technology web technology

In order to have the VPD functionality a trigger is required to fire when user initiates a session in DB.What type of trigger needs to be created?

  1. DML trigger

  2. System event

  3. INSTEAD OF trigger

  4. Application Trigger
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Virtual Private Database (VPD) requires a system event trigger that fires when a user initiates a database session (LOGON event). This trigger sets up the security context and predicate policies for row-level security. DML triggers respond to data manipulation operations, INSTEAD OF triggers are for views, and there's no standard 'Application Trigger' type in this context. The LOGON system event trigger is specifically designed for session initialization tasks like VPD setup.

Keep practicing — related questions