Answer Posted / lakshminarayana reddy
2 types
1. Implicit locks: oracle automatically locks the rows
whenever user performs DML operations.
2. Explicit locks: provided by user.
2 tpyes a) Row level locks: used to lock selected rows
of table.It is imposed by "for update" clause in select.
b) Table level locks: used to lock compleate
table. 3 models 1) share mode
2) share update
3) exlcusive mode
| Is This Answer Correct ? | 92 Yes | 26 No |
Post New Answer View All Answers
What is sql clause?
Is it possible to read/write files to-and-from PL/SQL?
Why do we use joins in sql?
What is the use of pl/sql table?
How to create your own reports in sql developer?
How many sql statements are used?
How to add, remove, modify users using sql?
What is view explain with example?
How can I see all tables in sql?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is mutating error in pl sql?
What is pl/sql table? Why it is used?
What is pl sql record in oracle?
What are %type and %rowtype for?
What is a common use of group by in sql?
