What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
Answer / monal
Live Lock occurs when exclusive lock is denied continuously
by series of overlapping shared locks keep on interfering
each other and they keep changing status further preventing
them to complete the task.
Is This Answer Correct ? | 2 Yes | 1 No |
What types of replication are supported in sql server? : sql server DBA
How do you resize a data file?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Where would you look for errors from the database engine?
Give two examples of referential integrity constraints.
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is replication? : sql server DBA