What is a transaction and how transaction is managed in DBMS?

To answer your question is beyond the scope of this discussion.

You need to read books for all those clarifications.

how can transaction can be closed and then changes occur ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.