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
Do you know what are triggers and rules?
Why are elements arranged as they are in the periodic table?
What are some examples of a reversible reaction?
What types of insulators are there?
In order to compare two different gas samples, scientists use what is called the stp. What does stp stand for?
Until the early 1960s, what group of elements were called the inert gases?
What is the protocol used by server and client?
A patient in the emergency room required 20 grams of a clotbusting drug based on his body weight of 150 pounds. The weight per volume (w/v) of the drug solution is 10%. How many milliliters of the drug solution should be administered?
What are the properties of carbohydrates?
What kind of bond does hcl have?
What is the only known substance for which there is no triple point?
What is the chemical formula for dichromate?
What are substrates?
What are the cons of eating organic foods?
An atom has 18 protons and 22 neutrons. What is its mass number?
