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 using clause and give example?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to count duplicated values in a column in oracle?
What is the purpose of save points in oracle database?
What are the differences between interval year to month and interval day to second?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
How to define default values for formal parameters?
Explain the family trees and connection by clause
How to divide query output into groups in oracle?
what is main def between plsql/table and array?
how to clone 9i Database on to 10g Database.