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 |
what is difference between API and Interface?
Sys Admin Module?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
how i can create temporary table?
While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions
In what situation u create the BPA.
what is the purpose of standard cost update?
How can u find custom top? where its located? How to find custom top in front end?
What are the validations you don in .CTL file in inbound interface process?
name all status attributes.
which parameters passed in report in oracle developer how to pass
What is the use of format trigger?