MYSQL DATABASE INTERVIEW QUESTIONS

What is a database trigger in MySQL?

How do you create a simple trigger in MySQL?

What are the different types of triggers in MySQL?

Can you modify the data being inserted or updated using a trigger? If yes, how?

How do you ensure that a trigger only executes under certain conditions?

What happens if a trigger fails during execution?

Explain the differences between row-level and statement-level triggers. Does MySQL support both?

How can you use triggers to maintain an audit trail in MySQL?

Discuss potential performance implications of using triggers in MySQL.

Describe a scenario where using a trigger would be essential to enforce business rules, and provide an example of how you would implement it.