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 is pl sql block in dbms?
Can we perform dml on view?
How can we schedule the procedure to run automatically ?
how to fetch alternate records from a table? : Sql dba
What is sql comments?
Can we use joins in subquery?
Is sql scripting language?
What is cross join sql?
What is the difference between microsoft access and sql server?
how many tupples can insert in 1 second in sql
What is the left table in sql?
Why do we use joins?
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)