There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
- 2 Answers
- 3840 Views
- Maruti Suzuki, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dinesh
This is depends on which type of trigger we have create.If Statement level then it will fire 2 times and for row level it will fire 10 time maximum and depends on number of record updated.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / abhishek jee
Please provide details on the contents of the triggers. That way, we will be able to figure out what the triggers do and how many times they would execute.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is left join same as inner join?
What are analytic functions in sql?
How do I add a primary key to a table?
Is there any restriction on the use of union in embedded sql?
can we call a procedure into another procedure?If yes means how you can pass the perameters for the two procedures?
What is use of package in pl sql?
What is a database trigger ? Name some usages of database trigger ?
how many groups of data types? : Sql dba
Do ddl statements need commit?
Differentiate between syntax and runtime errors.
Why do we need cursor in pl sql?
i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
