What is a deadlock ? Explain .
- 1 Answers
- 5147 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 |
Explain how you would restore a database using RMAN to Point in Time?
What is the simplest tool to run commands on oracle servers?
What is the difference between sharding and partitioning?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
What are the different types of partitions in oracle?
How to convert a date to char in oracle? Give one example.
Can we connect to ORACLE db using Windows Authentication?
Can you use a commit statement within a database trigger?
What is Hash Cluster ?
Why we use bulk collect in oracle?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
How many anonymous blocks can be defined?
Oracle General 
