Oracle PL SQL interview question Maximum number of triggers on same table

What is trigger? kzbin.info/www/bejne/r3_XaIiYd8h5f80
Types of DML Trigger kzbin.info/www/bejne/hnbJeaivmJxssK8
---------------------------------------------------------------------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
kzbin.info
---------------------------------------------------------------------------------------------------------------------------
Home page: sivakacademy.blogspot.com/
List of all oracle SQL/PLSQL Interview questions sivakacademy.blogspot.com/p/sql-plsql-interview-questions.html
List of all PLSQL Scenario based Interview Questions sivakacademy.blogspot.com/p/plsql-scenario-based-interview-questions.html
List of all Subscriber questions and answers sivakacademy.blogspot.com/p/all-subscriber-questions-and-answers.html
---------------------------------------------------------------------------------------------------------------------------
Oracle Interview questions playlist kzbin.info/aero/PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm
Oracle 18C New features playlist kzbin.info/aero/PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW
Oracle 12C New features playlist kzbin.info/aero/PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx-
Oracle PLSQL records and collections playlist kzbin.info/aero/PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
---------------------------------------------------------------------------------------------------------------------------
My video courses at UDEMY www.udemy.com/user/2c29d781-3879-41b5-a304-ea8325f15806/
---------------------------------------------------------------------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 10 years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos
For any questions, please drop me a mail at [e-mail]
---------------------------------------------------------------------------------------------------------------------------

[@gurugopal9342]

Hi Siva, your videos are awesome!! I love to watch and learning from you. You awesome detailed 😊!!

[@SivaAcademy]

Thank you bro

[@ankursrivastava5148]

This que was asked in DBS intervoew

[@computerlearningbyargusaca5217]

🙏🙏It was fabulous . just provide 👍👍exact clarity . 😍😍what I was👍👍 looking for

[@SivaAcademy]

Welcome 💐👍🙏

[@naveenrajumeganathan8581]

Great work bro...thank you

[@SivaAcademy]

Welcome 👍

[@mohinithor3297]

If compound triggers are also there, when that triggers will get execute, what will be the order or execution?

[@masalhemant4255]

Nice explanation........ i faced this question in interview

[@SivaAcademy]

great

[@sumitbansal868]

Kindly tell,how many maximum trigger can fire in one table?

[@priyankatotala7881]

Hi, it is very informative video. Having one question related to trigger only. Table A having trigger to insert data into table B and table B having trigger to insert data into A to sync data. How we can achieve this?

[@vilaswaghmare8032]

Please send me the joins video link

[@khanaasif5606]

Please add video for how many index can be created on a table?

[@abheshkumar2232]

Unlimited Indexes can be created per Oracle Table Total number of columns per table that can be indexed is 32 for B-Tree index and 30 for Bit Map index.

[@shashank2004]

Nice explanation bro.what's cascadding trigger?.. Pls make a video on that

[@SivaAcademy]

Sure bro

[@rajulapatirajasekhar7741]

Hello bro can i get link for table partitioning in oracle if you did a video already

[@SivaAcademy]

Yet to post partitions, please stay tuned bro

[@omkarhurdale898]

Sir I want to learn PLSQL as beginner I have a knowledge of SQL plz guide me thank you

[@SivaAcademy]

Sure, pls drop mail to siva.k.academy@gmail on any doubts you have, whatever is possible, i can reply back

[@gurikarichinnavenkatesh8425]

hai sir i attented one interview in that they are asking per day how much data you can handle

[@imrankadiwala014]

Apart from 12 triggers on table we cab have 3 compound triggers as well, so total number of triggers should be 15.

[@miteshsaxena1987]

Select * from best_tutorial on youtube ---------output Siva academy

[@SivaAcademy]

😀😀 my pleasure 💐🤗👍