what are different types of locks?

Answer Posted / a.brahmam

mainly two types of locks
1.Row Level Locks
2.Table Level Locks

Table Level Locks Are Two Types
-------------------------------------------------
1.Share Lock
2.Exclusive Lock

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do we create privileges in oracle?

669


Will you be able to store pictures in the database?explain.

617


How to experiment a data lock in oracle?

679


What is a sub query? Describe its types?

642


What is procedure overloading in oracle?

632






What happens if you lost a data file?

670


Explain the characteristics of oracle dba?

730


What is the usage of synonyms?

684


How to build data dictionary view an new database?

641


What is an oracle and why it is used?

694


What is Data Dictionary Cache in Oracle?

757


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1700


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1743


How do I find the database name in oracle?

672


How to pass parameters to procedures?

637