Types of locks in database ?

Answer Posted / naveen reddy mavuluri

shared locks, exclusive locks , intent locks like intent
shared, intent exclusive,
schema locks like schema modification,stability,
bulk update locks.

Is This Answer Correct ?    15 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is oracel sql developer written in java?

837


What are sql triggers used for?

722


What is a schema? How is it useful in sql servers?

792


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

712


What are different types of keys?

737






Which are the different case manipulation functions in sql?

734


How to select 10 records from a table?

841


Is coalesce faster than isnull?

703


Is there a way to automate sql execution from the command-line, batch job or shell script?

746


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

869


What is the purpose of my sql?

684


Explain the difference in execution of triggers and stored procedures?

748


Explain what is a subquery ?

853


Why do we use triggers?

718


Does sql between include endpoints?

748