Interested to Buy Any Domain ? << Click Here >> for more details...
what are different types of locks?
- 6 Answers
- 8323 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bibhuti bhusan patra
implicit locks & explicit locks
implicit locks are maintained by oracle internally.
&explicit locks are performed by user manualy.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shanmugavelu
row level and table level locks,
dont try share update lock its failure in table lelvel ..
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
Answer / a.brahmam
mainly two types of locks
1.Row Level Locks
2.Table Level Locks
Table Level Locks Are Two Types
-------------------------------------------------
1.Share Lock
2.Exclusive Lock
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the use of owner option in exp command.
how to create a new database in oracle?
What is the string concatenation operator in oracle?
How to create a new table by selecting rows from another table?
How do I know if oracle client is installed on windows?
How to install oracle odbc drivers?
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is oracle used for?
What is recovery manager in Oracle?
What is a Public Synonyms ?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
Oracle General 
