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

Are left and right joins the same?

0 Answers  


what is collation? : Sql dba

0 Answers  


How do I find duplicates in two columns?

0 Answers  


what is msql? : Sql dba

0 Answers  


How do I view a table in sql?

0 Answers  






how to convert character strings to numeric values? : Sql dba

0 Answers  


How you improve the performance of sql*loader? : aql loader

0 Answers  


What is an emotional trigger?

0 Answers  


Difference between table function and pipelined function?

0 Answers  


Can we use out parameter in function?

4 Answers   Infosys,


What are the different types of dbms?

0 Answers  


What are the set operators in sql?

0 Answers  


Categories