Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock ? Explain .
- 1 Answers
- 5894 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 |
What is translate in oracle?
What are the four Oracle system processes that must always be up and running for the database to be useable?
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
What is a relational database management system?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to generate query output in html format?
How to list all indexes in your schema?
What WHERE CURRENT OF clause does in a cursor?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to retrieve first and last records from a table?
How to select some columns from a table in oracle?
what is the syntax of INSERT command?
Oracle General 
