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 are sql commands classified?

0 Answers  

---

What is acid property in a database?

0 Answers  

---

What are all types of user defined functions?

0 Answers  

---

Why is stored procedure faster than query?

0 Answers  

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

What is the sql case statement?

0 Answers  

---

What is scope of pl sql developer in future?

0 Answers  

---

How much does sql certification cost?

0 Answers  

---

how to write date and time literals? : Sql dba

0 Answers  

---

What is data modelling in sql?

0 Answers  

---

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

explain about mysql and its features. : Sql dba

0 Answers  

---