Interested to Buy Any Domain ? << Click Here >> for more details...
what are different types of locks?
- 6 Answers
- 8614 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 can a view based on another view?
Can a parameter be passed to a cursor?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What are the tools for Oracle ?
What is the difference between sharding and partitioning?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
Explain the characteristics of oracle dba?
How will you differentiate between varchar & varchar2?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Oracle General 
