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

How do you update sql?

0 Answers  

---

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

---

What is sql profiling in oracle?

0 Answers  

---

What program will open a mdb file?

0 Answers  

---

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

---

What is the difference between syntax error and runtime error?

0 Answers  

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

---

there are .......different types of serializability

1 Answers   Wipro,

---

what is constraining table?

2 Answers  

---

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

what is 'mysqladmin' in mysql? : Sql dba

0 Answers  

---

What is pl sql variable?

0 Answers  

---