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 |
what's the difference between a primary key and a unique key? : Sql dba
How do you identify a primary key?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is foreign key sql?
What is nosql vs sql?
how is myisam table stored? : Sql dba
Why does sql need a server?
What is the difference between delete and truncate commands?
what are the types of join and explain each? : Sql dba
what is the difference between a local and a global temporary table? : Sql dba
How do you declare a variable in pl sql?
Explain scalar functions in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)