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 the most important ddl statements in sql are?

523


What is natural join in sql?

537


What is left join in postgresql?

544


Explain how can you save or place your msg in a table?

597


What is use of term?

626






can a stored procedure call itself or recursive stored procedure? : Sql dba

581


What is the usage of sql functions?

547


What are records give examples?

566


Enlist some predefined exceptions?

586


Why we use join in sql?

533


Is it possible for a table to have more than one foreign key?

582


Which join is like inner join?

564


What is trigger point?

540


Is it possible to create startup or shutdown trigger for on-schema?

587


How much ram can sql express use?

513