Oracle Scenarios Question:
Download Questions PDF

Explain What is mutated trigger, is it the problem of locks. In single user mode we got mutated error, as a DBA how you will resolve it?

Answer:

mutated trigger: example:Table A has an insert trigger.In that Trigger: There is a statement like insert into Table A, which caues mutated trigger.Avoid to have those kind of triggers in the database.

Download Oracle Scenarios Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is bulk SQL?Explain How to do the scheduled task/jobs in Unix platform?