Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the concentration, in parts per billion, of a solution that contains 1 microgram of solute per liter?
What are koh and hcl?
What is an object server in client server environment?
What are the advantages of infrared technology?
How do you convert oxygen gas to liquid oxygen?
Explain the term distribution coefficient in organic chemistry
round the following number to four significant figures and express the result in standard exponential notation: 0.006543210?
What is structured query langauge (sql)?
The ideal fuel for fuel cell use is?
Is thin client different from web client?
What is the common name of the molecule dihydrogen dioxide?
Which of the instruments would typically be used to measure the smallest quantities of mass:
How many moles of hcl are present in .70 l of a .33 m hcl solution?
I have source having single column C1 RAM KRISHNA I have to load that data in to one target . that target contain two columns C1 and C2 I want the out put like C1 C2 RAM KRISHNA that means in 1st column RAM and Second column Krishna ok by using informatica only . single space in between ram krishna in soucre column ok?
Where does arsenic come from?
