Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock ? Explain .
- 1 Answers
- 5897 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 |
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Give the various rollback segment states.
Whats the benefit of dbms_stats over analyze?
How do we create privileges in oracle?
What are the execution control statements?
How to load a large xml file?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is a dead lock in oracle?
Is a rollback possible to any savepoint?
how to handle exceptions in post production
Explain the types of exception?
Oracle General 
