What is the purpose of a compensating transaction?Question 23Select one:a.It helps to roll back a transaction without the risk of cascading rollbacks.b.It helps to compensate the user for slow database response.c.It helps to achieve a cascading rollback of a transaction.d.It helps to execute a set of subtransactions before they are committed.e.It helps to commit a set of subtransaction before they are executed.

4. Explain the role of transactions in database operations. How can you use the COMMIT and ROLLBACK statements to manage transactions effectively?

What is the primary purpose of transaction management in a distributed system?Question 13Select one:A.To simplify database queriesB.To enhance user interface designC.To speed up data retrievalD.To reduce storage costsE.To ensure database consistency during concurrent access and failures

Consider the following action:TRANSACTION.....Commit;ROLLBACK;What does Rollback do?Redoes the transactions before commitClears all transactionsUndoes the transactions before commitNo action

3. Discuss the importance of transaction management in JDBC for ensuring data consistency in database operations. Provide examples of scenarios where transaction management plays a crucial role and explain how JDBC facilitates transaction handling.

What is the primary role of the transaction manager in query processing?a)To ensure the atomicity and consistency of database transactions.b)To manage the physical storage of data.c)To enforce referential integrity constraints.d)To retrieve and manipulate data based on user queries.