Answer Posted / 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

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1057

---

Does truncate remove indexes?

1018

---

How do you clear the screen in sql?

1059

---

Is postgresql a nosql database?

1149

---

What is a constraint? Tell me about its various levels.

1146

---

What is user in sql?

1011

---

What is transaction control language (tcl)?

1128

---

Name the different types of indexes in sql and define them.

1131

---

What is memory optimized?

1073

---

what are all the common sql function? : Sql dba

1053

---

How do I find duplicates in sql?

924

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1011

---

What are field types?

984

---

What is a database event trigger?

1145

---

what is innodb? : Sql dba

1097

---