A user issues the below query, 1. Select * from table1 lock table At the same time DBA is trying to modify this table table1 using alter command, will he able to do that or not?

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 22nd, 2012

DDL lock are exclusive locks. It shared the data. Means anyone can select data from same table.

anil

• Mar 13th, 2012

There dba can break the lock given to table.
but in real time, no dba has the right to break the lock given by the user

Answer Question  Select Best Answer