What is Isolation Levels?
Submitted by: AdministratorIsolation keeps the transactions of multiple users isolated from each other. Transaction isolation level controls the degree of locking which occurs when selecting data. This is necessary to avoid situations like:
► Lost updates- when two transactions read the same data.
► Dirty read- Occurs when a transaction reads data that has not been updated.
► Non repeatable reads- occur when different results are read multiple times.
► Phantoms- Occurs when row data matches the first time but does not match subsequent times.
Submitted by: Administrator
► Lost updates- when two transactions read the same data.
► Dirty read- Occurs when a transaction reads data that has not been updated.
► Non repeatable reads- occur when different results are read multiple times.
► Phantoms- Occurs when row data matches the first time but does not match subsequent times.
Submitted by: Administrator
Read Online SQL Notification Services Job Interview Questions And Answers
Top SQL Notification Services Questions
☺ | Explain OPENQUERY function and OPENROWSET function? |
☺ | Define data, entity, domain and referential integrity? |
☺ | Define transaction and transaction isolation levels? |
☺ | How does Notification Services Work? |
☺ | What is Isolation Levels? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |