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

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.

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.

introduction to transaction in dbms

What is the primary role of the Storage Management component in a database system?Processing SQL queriesEnsuring data consistency and integrityOrganizing and managing storage structures like tables and indexesHandling user authentication

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