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 |
difference between imlicit cursor and explicit cursor ?
What is an oracle database table?
Explain the use of grant option in exp command.
How to restrict the duplicate records in table valuesets
How to convert characters to dates in oracle?
What is a package in oracle?
How to convert dates to characters in oracle?
Can select statements be used on views in oracle?
How to insert a record into a table?
what are the advantages of running a database in archive log mode?
How to select some columns from a table in oracle?
What is clustered table in Oracle?