76.ACID Properties in DBMS With Examples|Atomic,Consistency,Isolation,Durability
Download App to Learn SQL & Python: https://play.google.com/store/apps/de...
Please subscribe to my other channel too: / studyiteducation
------------Join my Real-time Job Oriented Courses -------------------
Website: https://www.studyiteducation.com/
Download Complete SQL Training Materials: http://bitly.ws/torp
Download SQL Interview Questions with Answers: http://bitly.ws/torx
Download SQL Training Videos, Notes,& Interview Questions:https://bit.ly/3pjcRPX
Practice Real-time SQL Interview Questions: https://bit.ly/3C6FQhF
One-to-One Live Training with Interview Preparation: https://bit.ly/3QryIR0
--------Connect on Social Media---------------------------------------------
Facebook: / mpandeyguruji
Instagram: / pandey_guruji
Linkedin: / mukesh-pandey-1a151634
Telegram: https://t.me/pandeyguruji
---------------Top Playlist-----------------------------------------------------------------
SQL Tutorial for Beginners in Hindi: https://bit.ly/3CwfnGB
SQL Tutorial for Beginners in English: https://bit.ly/3qVI3GQ
SQL Practice Exercises with Solutions: https://bit.ly/3Eb5tNg
SQL Interview Questions: http://bit.ly/2CR6wCZ
Advanced SQL Interview Questions: https://bit.ly/3HnMrnN
Crack SQL Interview: https://bit.ly/3caxIyb
SQL Live Training: https://bit.ly/3kXqOl1
Career Guidance: https://bit.ly/3FffkRf
IT Technology News & Updates: https://bit.ly/3FeNQvc
---------------------------------------------------------------------------------------------------
Atomic(ity) - The principle that each transaction is 'all-or-nothing', i.e., it either succeeds or it
fails, regardless of external factors such as power loss or corruption. On failure or success,
the database is left in either the state in which it was in prior to the transaction or a new valid
state. The transaction becomes an indivisible unit.
Consistency - The principle that the database executes transactions in a consistent manner,
obeying all rules (constraints).
Isolation - This property means that each transaction is executed in isolation from others, and
that concurrent transactions do not affect the transaction. SQL Server has five levels of
transaction isolation depending on the requirements of the database.
Durability - This property means that the data written to the database is durable, i.e. it is
guaranteed to be in storage and will not arbitrarily be lost, changed or overwritten unless
specifically requested. More formally, it means that once a transaction is committed, no event
can 'un-commit' the transaction - it is written and cannot be changed retrospectively unless by
another transaction.
---------------------------------------------------------------------------------------------------
Disclaimer - This video is just for educational purposes.
Copyright Disclaimer under Section 107 of the Copyright Act 1976, allowance for the "fair use".
All the images, music, and graphics used in this video belong to their respective owners and I or this channel do not claim any right over them.
Copyright Disclaimer under section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing
