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 |
Which table is left in join?
What is prepared statement in sql?
Is progress software supports to ( pl/sql )?
What is the use of & in pl sql?
How do we use distinct statement? What is its use?
What are the types of SQL Statement?
Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
What is numeric function sql?
find the third highest salary?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Explain 3 basic parts of a trigger.
Difference between IN and EXISTS
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)