What is a deadlock ? Explain .
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 |
What is the fastest query method to fetch data from the table?
 What are the oracle DML commands possible through an update strategy?
Is there a function to split a string in plsql?
In oracle there is column command, how will you explain that?
What is object data modeling?
Respected sir, Please send me technical questions related to oracle apps..
What are the oracle built-in data types?
What is a SNAPSHOT ?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
What is the use of Redo Log Information ?
Differnce between view and index
How to start a new transaction in oracle?