How well can multiple sessions access the same data
simultaneously ?



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

Post New Answer

More SQL PLSQL Interview Questions

What is the use of index in hive?

0 Answers  


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.

2 Answers  


How do I restart sql?

0 Answers  


Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,


What is a call statement? Explain with an example.

0 Answers  






Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,


What is a sql profiler?

0 Answers  


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

0 Answers  


What is meant by cursor in sql?

0 Answers  


select sal from emp group by sal

3 Answers   TCS,


Is vs as in pl sql?

0 Answers  


Can we use having without group by in sql?

0 Answers  


Categories