What is a deadlock?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

193. What is a deadlock?

Explain . Two processes waiting 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.

(Continued on next question...)

Other Job Interview Questions

• Can you have more than one content canvas view attached with a window?
• What are the different type of Segments?
• Find out nth highest salary from emp table
• What are the steps involved in Database Startup?
• What is the purpose of the product order option in the column property sheet?
• How do you reference a Parameter?
• What is a Sequence?
• Explain the use of table functions.
• How can you tell if a database object is invalid?
• How do you execute a UNIX command in the background?
• More...