77.What is the Dirty Read Problem in DBMS?Dirty Read Vs Non Repeatable read Vs Phantom Read|Database

Dirty Read – A Dirty read is a situation when a transaction reads data that has not yet
been committed. For example, Let’s say transaction 1 updates a row and leaves it
uncommitted, meanwhile, Transaction 2 reads the updated row. If transaction 1 rolls
back the change, transaction 2 will have read data that is considered never to have
existed.
● Non Repeatable read – Non Repeatable read occurs when a transaction reads the
same row twice and gets a different value each time. For example, suppose
transaction T1 reads data. Due to concurrency, another transaction T2 updates the
same data and commit, Now if transaction T1 rereads the same data, it will retrieve a
different value.
● Phantom Read – Phantom Read occurs when two same queries are executed, but the
rows retrieved by the two, are different. For example, suppose transaction T1 retrieves
a set of rows that satisfy some search criteria. Now, Transaction T2 generates some
new rows that match the search criteria for transaction T1. If transaction T1
re-executes the statement that reads the rows, it gets a different set of rows this time.
------------------------------------------------------------------------------------------------------------------------------------------
Download App to Learn SQL & Python: https://play.google.com/store/apps/details?id=com.studyit.learners
Please subscribe to my other channel too: http://www.youtube.com/c/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: https://www.facebook.com/mpandeyguruji/
Instagram: https://www.instagram.com/pandey_guruji/
Linkedin: https://www.linkedin.com/in/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
---------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------
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

Видео 77.What is the Dirty Read Problem in DBMS?Dirty Read Vs Non Repeatable read Vs Phantom Read|Database канала Pandey Guruji