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 sql key?
What is the difference between cross join and natural join?
write an sql query to find names of employee start with 'a'? : Sql dba
What are the qualities of 2nf?
Can dml statements be used in pl/sql?
What is a design view?
what is a database transaction? : Sql dba
how to concatenate two character strings? : Sql dba
What are sql commands?
What is the use of primary key?
What is cte?
what is datawarehouse? : Sql dba
Why we use cross join?
explain commit and rollback in mysql : sql dba
What is a recursive stored procedure?