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 trigger and types?
What is difference between inner join and cross join?
Are subqueries faster than joins?
What are the types of index in sql?
How do I pipe the output of one isql to another?
How many parts of a pl sql block are optional?
What does dml mean?
What is flag in sql?
What does trigger mean in slang?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
what is a trigger? : Sql dba
Is postgresql a nosql database?
What is the need of merge statement?
What does the file extension accdb stand for?
What are all the ddl commands?