Question
What is ACID property in database?
Answers
ACID property is used to ensure that the data transactions are processed reliably in a database system.
A single logical operation of a data is called transaction.
ACID is an acronym for Atomicity, Consistency, Isolation, Durability.
Atomicity: it requires that each transaction is all or nothing. It means if one part of the transaction fails, the entire transaction fails and the database state is left unchanged.
Consistency: the consistency property ensure that the data must meet all validation rules. In simple words you can say that your transaction never leaves your database without completing its state.
Isolation: this property ensure that the concurrent property of execution should not be met. The main goal of providing isolation is concurrency control.
Durability: durability simply means that once a transaction has been committed, it will remain so, come what may even power loss, crashes or errors.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q What is the use of combiners in the hadoop framework?
  • Q What are some examples of beings of the phylum Arthropoda that present a high level of behavioral sophistication?
  • Q Importance of CDMA in today’s cellular world?
  • Q What is a Material Master?
  • Q Where do you register data and layout templates?
  • Q What is the full ipv6 address represented by ff02::130f:5?
  • Q What is fork and how does it work in Linux?
  • Q There is a concern over the increase in harmful algal blooms in the seawaters of India. What could be the causative factors for this phenomenon ? 1. Discharge of nutrients from the estuaries 2. Run-off from the land during the monsoon. 3. Upwelling in the seas Select the correct answer from the codes given below:
  • Q What is the highest rank of officer in the RAF?
  • Q How often are trades made?
  • Q No possession can surpass, or even equal a good library, to the lover of books. Here are treasured up for his daily use and delectation, riches which increase by being consumed, and pleasures that never cloy.