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
What is the difference between I and G in Oracle?
What are the differences between primary key and unique key?
What is save point in oracle database?
Respected sir, Please send me technical questions related to oracle apps..
What is proxy method?
What is Java Pool in Oracle?
Can you assign multiple query result rows to a variable?
Explain the use of record option in exp command.
How to create a single index for multiple columns?
How to write date and time interval literals in oracle?
How to pass parameters to procedures in oracle?
What are the different types of failures that occur in Oracle database?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is oracle datasource?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.