Answer Posted / pratap dixit
Pessimistic and Optimistic lock
Pessimistic- at the time of reading , locking the row
Optimistic- at time of updating , locking the row.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert raw data type into text in oracle? Explain
Explain the use of grant option in imp command.
Explain the use of parfile option in exp command.
What are the uses of synonyms?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain an integrity constrains?
What is an oracle function?
What is bind variable in oracle 11g?
How do I recompile a procedure in oracle?
what happened to the global index when I truncate the data in one of the partition?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Can sub procedure/function be called recursively?
Is there a function to split a string in plsql?
What are the differences between char and nchar in oracle?
What is proxy method?