+2 votes
362 views
in Database Management Systems by

1 Answer

+1 vote
by (user.guest)
 
Best answer

Transaction

First, we need to understand the term database transaction.

When a multiple database operations are grouped together as one logical unit, we refer to the entire group as one transaction. Transactions are important in databases for two main reasons:

1. It allows for recovery from failure and this keeps the database consistent. Consider a  situation where the operations within a transaction fails partially or completely, the system is able to roll back to the last consistent state before the transaction was initiated.

2. It allows for isolation between programs accessing the database concurrently. This prevents one program from making updates to columns already read by another program, or reading data that another program is updating within a transaction. This reduces the chances that a program output is flawed with errors.


Related questions

+1 vote
1 answer 214 views
+1 vote
1 answer 170 views
asked Sep 13, 2021 in Database Management Systems by anonymous
+1 vote
1 answer 224 views
+1 vote
1 answer 119 views
+1 vote
1 answer 371 views
+1 vote
1 answer 57 views
asked Nov 17, 2021 in Database Management Systems by (user.guest)
+1 vote
1 answer 88 views
+1 vote
1 answer 179 views
+2 votes
1 answer 536 views
0 votes
1 answer 146 views
+1 vote
1 answer 206 views
+1 vote
1 answer 236 views
+2 votes
1 answer 510 views
+2 votes
1 answer 588 views
+1 vote
1 answer 3.9k views
+2 votes
1 answer 1.2k views
+1 vote
1 answer 1.6k views
+2 votes
1 answer 1.0k views
+1 vote
1 answer 620 views
+1 vote
1 answer 598 views
+1 vote
1 answer 966 views
+3 votes
1 answer 1.0k views
+1 vote
1 answer 124 views
0 votes
1 answer 143 views
0 votes
1 answer 113 views
asked Sep 23, 2021 in Database Management Systems by (user.guest)
+1 vote
1 answer 305 views
+1 vote
1 answer 237 views
0 votes
0 answers 130 views
+1 vote
1 answer 103 views
+1 vote
1 answer 161 views
+1 vote
1 answer 385 views
Welcome to CPENTalk.com
Solution-oriented students of computer engineering on one platform to get you that

ONE SOLUTION

...