LOCKS?
Answer / kiran kumar
-- Is to reduce concurrency
1) share lock
---it allows the other users for only reading not to
insert or update or delete.
2) exclusive lock
--- only one user can have the privileges of insert
or update and delete of particular object
--- others can only read.
3) update lock
----multiple user can read, update delete
Lock levels :
1) table level 2) table space 3) data base level.
Is This Answer Correct ? | 1 Yes | 0 No |
tell me the scenarios of the independent in reports
what are the balancing segments in AR?
can we use anchor propery in XML reports?if yes?explain?
can we execute one concurrent program through another concurrent program?
how to make a parameter optional in the query?
Please let me know the differance between Master Item and organization Item in Inventory.
How to make Parameter as Mandatory?
How to move the one file from one instance to another instance? And your scripts also?
What is GLOBAL TEMPORARY TABLE and It's significance ?
What are triggers?
how to create a file in forms?
Can u attach Request set with in the Request set?