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

To implement Virtual Private Database (VPD) policy initialization, a logon trigger is needed. This is classified as a database system event trigger (specifically AFTER LOGON ON DATABASE or SCHEMA), rather than a standard DML, INSTEAD OF, or application trigger.

Keep practicing — related questions