Explain MySQL locks?



Explain MySQL locks?..

Answer / amith

Table-level locks allow the user to lock the entire table,
page-level locks allow locking of certain portions of the
tables row-level locks are the most granular and allow
locking of specific rows.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is difference between function and procedure in mysql?

0 Answers  


What is row level locking in mysql?

0 Answers  


What are the similarities between a function and a procedure?

0 Answers  


Restore database (or database table) from backup.

0 Answers  


in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 Answers  






How many queries can mysql handle?

0 Answers  


What is ibdata1?

0 Answers  


What do we use to remove duplicate records while fetching a data in mysql ?

0 Answers  


How do I insert multiple rows in a table?

0 Answers  


What is a trigger? How you can create a trigger in mysql?

0 Answers  


What is the difference Delete and Drop ?

6 Answers  


what is database black box testing? : Mysql dba

0 Answers  


Categories