-
why and how the deadlock situation arises
If one user is already updating the table and it has a lock, the other user cannot access the table to update. then why and how the deadlock situation arises ?please explain with example.
-
Why use materialized view instead of a table
If Materialized view contains the actual data and has to be re-created every time the original table data is changed and we intent to refresh the data in the view.then what is the actual use of materialized view, why can't we create another table by itself by running the same query ?