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
The tyndall effect can be demonstrated when light is passed through which of the following?
Explain what are called non-gui clients, gui clients and ooui clients?
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?
Knowing that iron has an atomic number of 26, how many protons and how many electrons does fe+2 have?
Is hcl an acid or a base?
What element does the symbol au stand for?
Is hcl polar or non-polar?
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 is the ionic equation for hcl-naoh?
In RMI ,server object is first loaded into memory and then the stub reference is sent to the client. true or false?
What is the direction of the dipole moment expected for hydrogen bromide?
What are the differences between organic and inorganic chemistry?
How reactive is trimethylindium towards oxygen and water?
What are the properties of carbohydrates?
What is a substituted hydrocarbon?