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 program global area (pga) in oracle?
Can we commit inside a function in oracle?
Explain the use of owner option in exp command.
how to get count of tables in particular database in Oracle?
What is a system tablespace and when it is created?
How to drop a tablespace?
The join defined by the default data link is an outer join yes or no ?
Give the constructs of a package, function or a procedure.
What is the difference between a user and a schema in oracle?
find the second highest salary of the emp table
what is difference between DBMS and RDBMS?
what is view?