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


Please Help Members By Posting Answers For Below Questions

What is meant by temporal data?

709


What is execution plan in sql?

760


What is a rank in sql?

714


What is the difference between sql and t sql?

717


How do you truncate?

660






what are the authentication modes in sql server? How can it be changed? : Sql dba

956


What is the purpose of design view?

727


What is user defined functions?

746


What is a primary key? Explain

736


what are null values? : Sql dba

708


Can we call procedure in select statement?

732


Why do we use procedures in pl sql?

721


Explain what is a database?

815


Explain how exception handling is done in advance pl/sql?

732


Can we use join in subquery?

779