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 are all the ddl commands?

622


How do you optimize a query?

534


what is a unique key ? : Sql dba

538


Is primary key always clustered index?

533


Define implicit and explicit cursors.

623






What is the difference between a database and a relational database?

558


Why we use sql profiler?

560


What is nosql db?

536


What is difference between pls_integer and integer?

515


what are the different tables present in mysql? : Sql dba

501


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

510


Is sql difficult?

742


What is sqlite used for?

525


Are null values same as that of zero or a blank space?

529


What is trigger in pl sql with examples?

519