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 do you understand by concurrent programs?

0 Answers  


Types of cursors?

3 Answers  


what is instead of trigger. what is the use of that?

3 Answers  


how many sections are there in report?

1 Answers  


What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.

2 Answers   IBM,






How You Will display the key flexifields in your report

3 Answers   TCS,


Explain the multi-organization structure.

1 Answers   Accenture,


In support project one ticket alloted which steps follows manualy tell me ?

0 Answers   BEL, Questam,


Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.

3 Answers  


What is cursor?

3 Answers  


What does appl_top directory contain?

0 Answers  


how can we return morethan one parameters in procedure?

2 Answers  


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)