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 all the ddl commands?
How do you optimize a query?
what is a unique key ? : Sql dba
Is primary key always clustered index?
Define implicit and explicit cursors.
What is the difference between a database and a relational database?
Why we use sql profiler?
What is nosql db?
What is difference between pls_integer and integer?
what are the different tables present in mysql? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Is sql difficult?
What is sqlite used for?
Are null values same as that of zero or a blank space?
What is trigger in pl sql with examples?