How well can multiple sessions access the same data
simultaneously ?
Answer / ganesh sawant from finacle
oracle allows many session to work simultaneously and store computer rescues. To have multiple session oracle has control concurrency i.e. maintain data integrity when multiple sessions access the same data at same time.
For example consider a railway reservation system where table is maintained and showing availability of reservation .
Oracle controls the concurrency using locking
Is This Answer Correct ? | 0 Yes | 0 No |
Are left and right joins the same?
what is collation? : Sql dba
How do I find duplicates in two columns?
what is msql? : Sql dba
How do I view a table in sql?
how to convert character strings to numeric values? : Sql dba
How you improve the performance of sql*loader? : aql loader
What is an emotional trigger?
Difference between table function and pipelined function?
Can we use out parameter in function?
What are the different types of dbms?
What are the set operators in sql?