What is ACID property?

Answers were Sorted based on User's Feedback



What is ACID property?..

Answer / rajendra prasad reddy penumall

ACID property related to transactions
i.e client server communication is called transaction.
A transaction is a sequence of operations performed as a
single unit of work.A logical unit of work must exhibit
four properties called ACID(Atomicity,Consistency,Isolation
and Durability)properties to qualify a transaction.

Atomicity:A transaction must be an atomic unit of work.i.e
either allof its data modificationsare performed ,or none
of them is performed.

Consistancy:when trasaction completed it must leave all data
in a consistant state.

Isolated:Modifications made by current transactions must be
isolated from the modifications made by other trasaction.

Durability: after transaction has completed ,it's effects
are permanently in place in the sytem.

Is This Answer Correct ?    187 Yes 21 No

What is ACID property?..

Answer / rahul

ACID property related to transactions
i.e client server communication is called transaction.
A transaction is a sequence of operations performed as a
single unit of work.A logical unit of work must exhibit
four properties called ACID(Atomicity,Consistency,Isolation
and Durability)properties to qualify a transaction.

Atomicity:A transaction must be an atomic unit of work.i.e
either allof its data modificationsare performed ,or none
of them is performed.

Consistancy:when trasaction completed it must leave all data
in a consistant state.

Isolated:Modifications made by current transactions must be
isolated from the modifications made by other trasaction.

Durability: after transaction has completed ,it's effects
are permanently in place in the sytem.

Is This Answer Correct ?    64 Yes 17 No

What is ACID property?..

Answer / imran badrampalli

ACID (an acronymn for Atomicity Consistency Isolation
Durability) is a concept that Database Professionals
generally look for when evaluating databases and
application architectures. For a reliable database all this
four attributes should be achieved.

Atomicity is an all-or-none proposition.

Consistency guarantees that a transaction never leaves your
database in a half-finished state.

Isolation keeps transactions separated from each other
until they’re finished.

Durability guarantees that the database will keep track of
pending changes in such a way that the server can recover
from an abnormal termination.

Above four rules are very important for any developers
dealing with databases

Is This Answer Correct ?    41 Yes 9 No

What is ACID property?..

Answer / chinmaya dash

ACID PROPOTIES;-
ACID STANDS FOR-
1)ATOMICITY
2)CONSISTENCY
3)ISOLATION
4)DURABILITY
BEFORE GOING TO ACID PROPOTIES WE MUST KNOW ABOUT
TRANSACTION-
A LOGICAL UNIT OF A WORK IS KNOWN AS TRANSACTION.
WHEN WE TRANSFER ANY DATA FROM ONE PLACE TO ANOTHER PLACE
AT A INTERMIDIATARY STATE IT MAY FAILUARE ,WHICH DATA WE
SEND THAT DATA MAY LOOSE FOR EVER.SO TO AVOID THAT PROBLEM
ACID PROPOTIES IS NEEDED,In computer science, ACID
(atomicity, consistency, isolation, durability) is a set of
properties that guarantee that database transactions are
processed reliably.
ATOMICITY-;IT MEANS ALL OR NOTHING,ALL THE TRANSACTION
PROCESSING MUST BE PERFORMED,OTHERWISE IT WILL NOT
PERFORM.NEVER IT STAY IN INTERMEDIATARY STATE.
CONSISTENCY;-IT MEANS A VALID DATA SHOULD INPUT,IF WE DONOT
INPUT PROPER INPUT THEN WE WILL FIND WRONG OUTPUT.
ISOLATION;- NO'S OF DEVICE WANT TO ACCESS ON SAME DATA,IT
IS IMPOSSIBLE TO ACCESS ON SAME DATA,BY ISOLATION0, IT
DECIDE WHICH DEVICE ACCESS THAT DATA,AT THAT TIME ANOTHER
DEVICES MUST STILL IN THEIR CRITICAL SECTION.
DURABILITY-;WHEN WE PROCESS SOMETHING ,IF THAT TIME POWER
FAILURE THEN ALL DATA WILL BE LOST,SO WE NEED TO RECOVER
THAT DATA.THERE IS TRANSACTION LOG TABLE WHICH DECIDES WHAT
TRANSACTION DONE ON WHICH DATA.OTHERWISE IT IS CALLED
RECOVERY OF DATABASE.

Is This Answer Correct ?    29 Yes 8 No

What is ACID property?..

Answer / vinay mishra (ucc_uor)

The ACID model is one of the oldest and most important
concepts of database theory.

Atomicity states that database modifications must follow an
“all or nothing” rule. Each transaction is said to be
“atomic.” If one part of the transaction fails, the entire
transaction fails. It is critical that the database
management system maintain the atomic nature of transactions
in spite of any DBMS, operating system or hardware failure.

Consistency states that only valid data will be written to
the database. If, for some reason, a transaction is executed
that violates the database’s consistency rules, the entire
transaction will be rolled back and the database will be
restored to a state consistent with those rules. On the
other hand, if a transaction successfully executes, it will
take the database from one state that is consistent with the
rules to another state that is also consistent with the rules.

Isolation requires that multiple transactions occurring at
the same time not impact each other’s execution. For
example, if Joe issues a transaction against a database at
the same time that Mary issues a different transaction, both
transactions should operate on the database in an isolated
manner. The database should either perform Joe’s entire
transaction before executing Mary’s or vice-versa. This
prevents Joe’s transaction from reading intermediate data
produced as a side effect of part of Mary’s transaction that
will not eventually be committed to the database. Note that
the isolation property does not ensure which transaction
will execute first, merely that they will not interfere with
each other.

Durability ensures that any transaction committed to the
database will not be lost. Durability is ensured through the
use of database backups and transaction logs that facilitate
the restoration of committed transactions in spite of any
subsequent software or hardware failures.

Is This Answer Correct ?    19 Yes 7 No

What is ACID property?..

Answer / imran siddiqui

A transaction is an atomic unit of work that must be
completed in its entirety.The transaction succeeds if it
committed and fails if it is aborted.

Database theory has a more rigorous definition of a
transaction and states that a transaction has four
fundamental properties, known as ACID properties:

A(Atomicity):-The sequence of operations must be atomic,
either all or no operations are performed.

C(Consistency):- When completed, the sequence of operations
must leave data in consistent mode. All the defined
relations/constraints must me Maintained.

I(Isolation): A Transaction must be isolated from all other
transactions. A transaction sees the data defore the
operations are performed , or after all the operations has
performed, it can't see the data in between.

D(Durability): All oprtaions must be permanently placed on
the system. Even in the event of system failure , all the
operations must be exhibit.

Is This Answer Correct ?    10 Yes 2 No

What is ACID property?..

Answer / hi

ACID properties
When a transaction processing system creates a transaction, it will ensure that the transaction will have certain characteristics. The developers of the components that comprise the transaction are assured that these characteristics are in place. They do not need to manage these characteristics themselves. These characteristics are known as the ACID properties. ACID is an acronym for atomicity, consistency, isolation, and durability.

Atomicity

The atomicity property identifies that the transaction is atomic. An atomic transaction is either fully completed, or is not begun at all. Any updates that a transaction might affect on a system are completed in their entirety. If for any reason an error occurs and the transaction is unable to complete all of its steps, the then system is returned to the state it was in before the transaction was started. An example of an atomic transaction is an account transfer transaction. The money is removed from account A then placed into account B. If the system fails after removing the money from account A, then the transaction processing system will put the money back into account A, thus returning the system to its original state. This is known as a rollback, as we said at the beginning of this chapter..

Consistency

A transaction enforces consistency in the system state by ensuring that at the end of any transaction the system is in a valid state. If the transaction completes successfully, then all changes to the system will have been properly made, and the system will be in a valid state. If any error occurs in a transaction, then any changes already made will be automatically rolled back. This will return the system to its state before the transaction was started. Since the system was in a consistent state when the transaction was started, it will once again be in a consistent state.

Looking again at the account transfer system, the system is consistent if the total of all accounts is constant. If an error occurs and the money is removed from account A and not added to account B, then the total in all accounts would have changed. The system would no longer be consistent. By rolling back the removal from account A, the total will again be what it should be, and the system back in a consistent state.

Isolation

When a transaction runs in isolation, it appears to be the only action that the system is carrying out at one time. If there are two transactions that are both performing the same function and are running at the same time, transaction isolation will ensure that each transaction thinks it has exclusive use of the system. This is important in that as the transaction is being executed, the state of the system may not be consistent. The transaction ensures that the system remains consistent after the transaction ends, but during an individual transaction, this may not be the case. If a transaction was not running in isolation, it could access data from the system that may not be consistent. By providing transaction isolation, this is prevented from happening.

Durability

A transaction is durable in that once it has been successfully completed, all of the changes it made to the system are permanent. There are safeguards that will prevent the loss of information, even in the case of system failure. By logging the steps that the transaction performs, the state of the system can be recreated even if the hardware itself has failed. The concept of durability allows the developer to know that a completed transaction is a permanent part of the system, regardless of what happens to the system later on.

Is This Answer Correct ?    7 Yes 3 No

What is ACID property?..

Answer / kushal samanta

Question :-> What is ACID property ?
Ans:->
ACID PROPOTIES;-
ACID STANDS FOR-
1)ATOMICITY
2)CONSISTENCY
3)ISOLATION
4)DURABILITY
BEFORE GOING TO ACID PROPOTIES WE MUST KNOW ABOUT
TRANSACTION-
A LOGICAL UNIT OF A WORK IS KNOWN AS TRANSACTION.
WHEN WE TRANSFER ANY DATA FROM ONE PLACE TO ANOTHER PLACE
AT A INTERMIDIATARY STATE IT MAY FAILUARE ,WHICH DATA WE
SEND THAT DATA MAY LOOSE FOR EVER.SO TO AVOID THAT PROBLEM
ACID PROPOTIES IS NEEDED,In computer science, ACID
(atomicity, consistency, isolation, durability) is a set of
properties that guarantee that database transactions are
processed reliably.
ATOMICITY-;IT MEANS ALL OR NOTHING,ALL THE TRANSACTION
PROCESSING MUST BE PERFORMED,OTHERWISE IT WILL NOT
PERFORM.NEVER IT STAY IN INTERMEDIATARY STATE.
CONSISTENCY;-IT MEANS A VALID DATA SHOULD INPUT,IF WE DONOT
INPUT PROPER INPUT THEN WE WILL FIND WRONG OUTPUT.
ISOLATION;- NO'S OF DEVICE WANT TO ACCESS ON SAME DATA,IT
IS IMPOSSIBLE TO ACCESS ON SAME DATA,BY ISOLATION0, IT
DECIDE WHICH DEVICE ACCESS THAT DATA,AT THAT TIME ANOTHER
DEVICES MUST STILL IN THEIR CRITICAL SECTION.
DURABILITY-;WHEN WE PROCESS SOMETHING ,IF THAT TIME POWER
FAILURE THEN ALL DATA WILL BE LOST,SO WE NEED TO RECOVER
THAT DATA.THERE IS TRANSACTION LOG TABLE WHICH DECIDES WHAT
TRANSACTION DONE ON WHICH DATA.OTHERWISE IT IS CALLED
RECOVERY OF DATABASE.

Is This Answer Correct ?    8 Yes 8 No

What is ACID property?..

Answer / lipak

acid is nothing so did not require to study please ignore it

Is This Answer Correct ?    24 Yes 56 No

Post New Answer

More Client Server General Interview Questions

What is ACID property?

9 Answers   IBM, Tech Mahindra,


what is infrared technology?

2 Answers  


The use of electricity to decompose molten sodium chloride into its component elements is an example of?

0 Answers  


Which are not carbonate minerals?

0 Answers  


Which dominates the gasses in the earths atmosphere, making up some 78% of the air by volume?

0 Answers  






Which of the instruments would typically be used to measure the smallest quantities of mass:

0 Answers  


What is an object server in client server environment?

0 Answers  


What are called Fat clients and Fat servers?

1 Answers   Cisco,


Why chemists have not created a periodic table of compounds?

0 Answers  


Element a is a nonmetal with an electronegativity value of 3.0 and element b is a nonmetal with an electronegativity value of 2.5. What kind of bonding will occur between these two elements?

0 Answers  


The general term for the removal of salts from brackish water or seawater to make it usable is called?

0 Answers  


Name the two most abundant elements in the universe?

0 Answers  


Categories
  • Client Server Architecture Interview Questions Client Server Architecture (26)
  • Client Server General Interview Questions Client Server General (262)
  • Client Server AllOther Interview Questions Client Server AllOther (45)