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

What does trigger mean in psychology?

528


How many clustered indexes can be created on a table?

577


Does pl sql work in mysql?

524


Can unique keys be null?

475


What is varchar sql?

603






How can I see all tables in sql?

533


Which kind of parameters cannot have a default value in pl sql?

585


What is the difference between left outer join and left join?

502


How do I save a stored procedure?

512


What is rename command in sql?

456


Can we create foreign key without primary key?

525


what is 'mysqlcheck'? : Sql dba

561


What is sql*loader and what is it used for?

567


Will truncate release space?

508


What are the different ways to optimize a sql query?

479