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 profile and what is level of profile option and it's hierarchy
What is workflow?Explain with a example?
1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function
how many sections are there in report?
In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?
what are the sql attributes?
wht is format triger?
Explain the multi-organization structure.
can we use commit in trigger? If yes how?
what is pay run id ?
what are the prerequisite set ups for inter organization transaction?
tell me the scenarios of between pages in reports