1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How well can multiple sessions access the same data
simultaneously ?

Question Posted / swapna


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

Post New Answer

More SQL PLSQL Interview Questions

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

Can a primary key be a foreign key?

0 Answers  

Can a select statement fire a trigger?

0 Answers  

What is a sql instance vs database?

0 Answers  

Why do we use triggers?

0 Answers  




What are the types of operators available in sql?

0 Answers  

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

What does <> sql mean?

0 Answers  

What are the possible values for the boolean data field?

0 Answers  

What is left join in postgresql?

0 Answers  

What does data normalization mean?

0 Answers  

What is trigger types of trigger?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories