Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock ? Explain .
- 1 Answers
- 5752 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 |
Without giving condition how to retrieve the unmatched records from table.
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
How to execute the package in oracle?
What is PL/SQL ?
what is the syntax of DELETE command?
What is oracle analytical function?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
What is a cursor variable?
Is insert autocommit in oracle?
Explain the family trees and connection by clause
Difference between an implicit & an explicit cursor.?
What is a Schema ?
Oracle General 
