edited by
282 views

2 Answers

Best answer
3 votes
3 votes

The basic properties of transactions is called ACID properties .

In order to maintain consistency in a database, before and after transaction, certain properties are followed. These are called ACID properties.

A - Atomocity   ----> knows as All or Nothing rule

means either the entire transaction takes place at once or doesn’t happen at all.

C - Consistency  ------>means that integrity constraints must be maintained so that the database is consistent before and after the transaction.

I - Isolation  ------> ensures us multiple transactions can occur concurrently without leading to inconsistency of database state.

D - Durability ------> Durability ensures that once the transaction has completed execution, the updates and modifications to the database are stored in and written to disk and they persist even is system failure occurs.

selected by
Answer:

Related questions

0 votes
0 votes
1 answer
1
gatecse asked Mar 2, 2018
238 views
A table space is further broken down into ______ .BlocksExtentsFilesSegments
0 votes
0 votes
4 answers
2
gatecse asked Mar 2, 2018
606 views
Which of the following operation of relational algebra, selects certain columns from the table and discards the other columns?SELECTPROJECTDIVISIONNone of the above
0 votes
0 votes
1 answer
3
gatecse asked Mar 2, 2018
186 views
In a sequential file records are maintained in the logical sequence of theirprimary key valuestorage locationprimary and secondary key valueNone of the above
0 votes
0 votes
1 answer
4
gatecse asked Mar 2, 2018
217 views
Each row or record of a relational table is known asDomainAttributeTupleKey