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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is the difference between online and offline backups?
How to get execution statistics reports on query statements?
How do I know if oracle is installed on windows?
various types of hints and their usage
What happens to the current transaction if the session is killed?
What do you understand by database schema and what does it hold?
What are joins, explain all types of joins?
How do we get field details of a table?
What are the attributes that are found in a cursor?
What is the quickest way to export a table to a flat file?
What is the difference between alert log file and tarce file ?
How to retrieve the count of updated rows?
What is the max number of columns in an oracle table?
How to drop a stored procedure in oracle?