Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock ? Explain .
- 1 Answers
- 5781 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
definition of cluster and non-clustered index?
How to display First 4 rows From Database Table?
How to concatenate two text values in oracle?
What is tns entry?
How to grant create session privilege to a user in oracle?
Explain about functional dependency and its relation with table design?
How to download oracle database 10g xe?
How to use group functions in the select clause using oracle?
What is the difference between normal and corelated subqueries?
What is the difference between Sleep and Wait? (Java)
how to see the data (in unix) using dataset in datastage?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
Oracle General 
