Interested to Buy Any Domain ? << Click Here >> for more details...
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 output spooling in sql*plus?
Which sql statement is used to delete data from a database?
What are actual parameters and formal parameters?
What is the sql case statement?
What is the syntax to add a record to a table?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is dbo in sql?
What is the benefit of foreign key?
What are the different tcl commands in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is the file extension for sql database?
What is update query?
What is query optimization in sql?
what is the difference between $message and $$message? : Sql dba
what are the authentication modes in sql server? How can it be changed? : Sql dba
