Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock ? Explain .
- 1 Answers
- 5898 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 oracle 12c new features for developers?
What is recycle bin in Oracle?
How do I spool in oracle?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
difference between procedures and function?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
Describe the types of sub query?
What is the difference between a primary key & a unique key?
What are the differences between number and binary_float in oracle?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
Explain what are clusters?
When system tablespace is created?
Oracle General 
