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 are the 3 modes of parameter?
What is the difference between the conventional and direct path loader? : aql loader
How do you modify a trigger?
What is a self join ?
How many null values can be inserted in a coulmn whihc is unique constraint
What is rownum in sql?
i want run a sql query query? which phases are run in a back ground? pls tell me the answer
how would you get the current date in mysql? : Sql dba
What is before trigger?
What is loop in pl sql?
what are the different type of sql's statements ? : Sql dba
What is pl/sql and what is it used for?
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)