Trigger in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

Trigger in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

Trigger is a PLSQL block structure which is automatically fired when an event occurs in the database.

The event can be DDL, DML or system events.

A trigger code is automatically fired when an associate event occurs in the database.

Types of Triggers:

1) DML Trigger

2) DDL Trigger

3) System Trigger

4) Instead of Trigger

5) Compound Trigger

Purpose of the Trigger :

1) Trigger is used for auditing the data.

2) Enforcing complex referential integrity

Whatever the integrity constraints which we can not enforce through primary key, foreign key constraints that can be enforced through the trigger.

3) Logging

Whenever you want to capture who changed the particular data then we can use the trigger for logging the information.

4) Enforcing security for the transactions

Please do check our daily posts, videos for beneficial informations, in case of any additional queries please do contact us, we are happy to assist you.

Please Do SUBSCRIBE our Youtube Channel and Support us :-
https://www.youtube.com/a4uofficial

If any difficulties regarding our posts, videos or other problem you can direct contact us:- allforyoucreators@gmail.com

If you found this post was helpful then please don't forget to SUBSCRIBE our channel.

Subscribe us for more such posts, videos and updates.. It's Free!!

Subscribe here : https://www.youtube.com/a4uofficial

For Businesses Inquiries :- allforyoucreators@gmail.com

_____________________________________________________________________________

Join Us on Social Media -

Like our Facebook Page :- https://www.facebook.com/a4u0fficial/

Follow me on Instagram :- https://www.instagram.com/allforyouofficial.01/

Twitter :- https://twitter.com/a4uofficial

Website :- https://allforyouofficial.com/

PLEASE SUBSCRIBE US FOR MORE POSTS, VIDEOS AND STAY TUNED..

CREATIVE, INFORMATIVE & BENEFICIAL CONTENTS TO BE FOUND ON OUR CHANNEL!!

BECAUSE WE KEEP UPLOADING VIDEOS ON YOUTUBE FOR YOU..

ALL WE NEED IS YOUR SUPPORT ❤

=▶ Thanks for your Love and Support ◀=

Copyright ©All For You Official