LOCKS?



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

Post New Answer

More Oracle Apps Technical Interview Questions

what is difference between API and Interface?

2 Answers   Infogain,


Sys Admin Module?

1 Answers  


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?

2 Answers   Cap Gemini,


how i can create temporary table?

1 Answers   Zensar,


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

3 Answers   IBM,






In what situation u create the BPA.

2 Answers   Accenture,


what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,


How can u find custom top? where its located? How to find custom top in front end?

1 Answers  


What are the validations you don in .CTL file in inbound interface process?

1 Answers  


name all status attributes.

1 Answers   Scan Steel,


which parameters passed in report in oracle developer how to pass

3 Answers  


What is the use of format trigger?

4 Answers   Cap Gemini, IBM,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)