How well can multiple sessions access the same data
simultaneously ?
Answer / 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 |
What is the use of index in hive?
why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.
How do I restart sql?
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
What is a call statement? Explain with an example.
Differences between UNIQUE and DISTINCT in select statements
26 Answers ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
What is a sql profiler?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is meant by cursor in sql?
select sal from emp group by sal
Is vs as in pl sql?
Can we use having without group by in sql?