what are different types of locks?

Answer Posted / shanmugavelu

row level and table level locks,
dont try share update lock its failure in table lelvel ..

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a cusotmer as a supplier in ORACLE R12

1728


How many anonymous blocks can be defined?

589


How to select an oracle system id (sid)?

594


How to run the anonymous block again?

599


What are the major difference between truncate and delete?

519






Explain the use of log option in exp command.

538


Explain the use of indexes option in exp command.

597


What is merge in oracle?

564


How to use regular expression in pattern match conditions in oracle?

580


What is varray?

589


What is difference between sid and service name in oracle?

520


Give the different types of rollback segments.

583


What is an oracle function?

603


Explain table?

656


How to manage transaction isolation level?

567