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 are the advantages of using stored procedures? : Sql dba
Which software is used for pl sql programming?
What is a record in a database?
Explain what is table in a database?
what is single byte over head in oracle..?
Can a view be mutating? If yes, then how?
List the ways to get the count of records in a table?
What is the difference between execution of triggers and stored procedures?
How do you modify a trigger?
What is keys and its types?
what are rollup and cube in t-sql? : Transact sql
How do I find duplicates in the same column?
What is mutating error in pl sql?
How do I install microsoft sql?
What is primary key secondary key alternate key candidate key?