Database lock basically signifies the transaction about the current status of the data item i.e. whether that data is being used by other transactions or not at that point of time.
Two types of Database lock are present:
Hey, @ Sudhir,
This is regarding your statement:
The LOCK TABLE statement allows you to explicitly acquire a shared or exclusive table lock on the specified table. The table lock lasts until the end of the current transaction.
When a statement modifies data, its transaction holds an exclusive lock on data that prevents other transactions from accessing the data.
This lock remains in place until the transaction holding the lock issues a commit or rollback. Table-level locking lowers concurrency in a multi-user system.
Database locks can actually be placed at different levels – also known as lock granularity – within the database. Here is the list of lock
Hope this is helpful!!
There are 3 types of relationships in ...READ MORE
Atomicity is the condition where either all the ...READ MORE
You can refer to the following definitions ...READ MORE
There are mainly 5 types of Keys, ...READ MORE
What you want to accomplish isn't possible ...READ MORE
You can connect your Java code with ...READ MORE
you need to use OMS to read ...READ MORE
Browse to sonarqube web instance to access ...READ MORE
The cursor is a temporary work area ...READ MORE
Data Independence refers to the ability to ...READ MORE
Already have an account? Sign in.