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

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

How can use stored procedures in sql?

0 Answers  

---

define sql update statement ? : Sql dba

0 Answers  

---

What is correlated sub-query?

7 Answers   Oracle,

---

what is variable in package specification

3 Answers  

---

Explain how to use transactions efficiently : transact sql

0 Answers  

---

What are triggers, and when would you use them?

3 Answers  

---

Define tables and fields in a database

0 Answers  

---

What is the maximum number of rows in sql table?

0 Answers  

---

please explain database architecture..

1 Answers   Infosys,

---

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

---