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 the most important ddl statements in sql are?
What is natural join in sql?
What is left join in postgresql?
Explain how can you save or place your msg in a table?
What is use of term?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is the usage of sql functions?
What are records give examples?
Enlist some predefined exceptions?
Why we use join in sql?
Is it possible for a table to have more than one foreign key?
Which join is like inner join?
What is trigger point?
Is it possible to create startup or shutdown trigger for on-schema?
How much ram can sql express use?