Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sawant
Two processes wating to update the rows of a table which
are locked by the other process then deadlock arises.
In a database environment this will often happen because
of not issuing proper row lock commands. Poor design of
front-end application may cause this situation and the
performance of server will reduce drastically.
These locks will be released automatically when a
commit/rollback operation performed or any one of this
processes being killed externally.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Is postgres faster than oracle?
State some uses of redo log files?
Explain a segment?
What happens to the current transaction if the session is ended?
How to create a single index for multiple columns?
What's dateware house and what's clustor with practicle example
What is a subquery in oracle?
What do you mean by group by clause?
How to rename an existing table?
What are the uses of synonyms?
Define oracle database
How does oracle handle read consistency?
What is a user account in oracle?
What is a sub query? Describe its types?
What are the four Oracle system processes that must always be up and running for the database to be useable?
