what is transactional, required vs requires_new

Question

Accepted Answer

Transactional is a way to ensure data consistency in a database. Required and Requires_New are two types of transactional propagation.

Transactional ensures that a group of database operations are treated as a single unit of work.
Required propagation means that the transaction will join an existing transaction if one exists, otherwise a new transaction will be created.
Requires_New propagation means that a new transaction will always be created, even if an existing transaction exists.
Transactional is commonly used in enterprise applications to ensure data consistency.
Example: A bank transfer involves deducting money from one account and adding it to another. This should be treated as a single transaction to ensure data consistency.

Top TCS Assistant Consultant and Developer interview questions & answers