How well can multiple sessions access the same data
simultaneously ?
Answer Posted / 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 |
Post New Answer View All Answers
What is a dynamic query?
Can we use threading in pl/sql?
What is the difference between a query and a report?
What is date functions?
What is a ddl command?
Who is the owner of mysql database?
what is self join and what is the requirement of self join? : Sql dba
Explain what is a database?
What are the different operators available in sql?
When do we use triggers?
How would you pass hints to the sql processor?
What is sqlite used for?
Which is faster union or join?
Can we use view in stored procedure?
What are three advantages to using sql?