what are different types of locks?

Answer Posted / bibhuti bhusan patra

implicit locks & explicit locks
implicit locks are maintained by oracle internally.
&explicit locks are performed by user manualy.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to insert a new row into a table in oracle?

581


How to drop a stored procedure in oracle?

586


Explain oracle instance.

680


What is the sql query to concatenate column values from multiple rows in oracle?

557


What is java oracle used for?

523






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

1656


What is a trigger and what are its types in oracle?

532


What is blob data type in oracle?

555


What are the execution control statements?

610


Explain the use of parfile option in exp command.

519


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2042


What is coalesce function?

567


what is the use of system.effective.date variable in oracle?

669


What is query image?

580


What are the varoius components of physical database structure of oracle database?

563