FORUM on WEEK 8 and 9

Week 8

Week 8

by jugol kishor das -
Number of replies: 1

What is database transaction in DBMS?

A Database Transaction is a logical unit of processing in a DBMS which entails one or more database access operation. In a nutshell, database transactions represent real-world events of any enterprise. All types of database access operation which are held between the beginning and end transaction statements are considered as a single logical transaction in DBMS. During the transaction the database is inconsistent. Only once the database is committed the state is changed from one consistent state to another.

In reply to jugol kishor das

Re: Week 8

by Sweety Islam -

A Database Transaction is a logical unit of processing in a DBMS which entails one or more database access operation. In a nutshell, database transactions represent real-world events of any enterprise. ... Only once the database is committed the state is changed from one consistent state to another.