Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock ? Explain .
- 1 Answers
- 5999 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 |
How to use null as conditions in oracle?
What is oracle database client?
How to shutdown your 10g xe server?
What is a Schema ?
What are the types of partitions in oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What is a Data Dictionary ?
How to login to the server without an instance?
How do I limit the number of rows returned by an oracle query after ordering?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What do you know about normalization? Explain in detail?
What is save point in oracle database?
Oracle General 
