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

How do you exit in sql?

581


What are different joins used in sql?

548


What is sql in oracle?

613


What is flag in sql?

531


what is a join? : Sql dba

557






What is function and procedure in pl sql?

513


What is bitemporal narrowing?

715


What is record in pl sql?

587


Are left and right joins the same?

525


what is 'trigger' in sql? : Sql dba

547


what are the differences between require and include, include_once and require_once? : Sql dba

519


What does desc stand for?

584


Can we edit a view in sql?

539


discuss about myisam index statistics collection. : Sql dba

516


Is coalesce faster than isnull?

498