Database Interview Questions - L&T Infotech.

1. How to find deadlock in database systems?
2. What is DBCC?
3. Explain some DBCC commands used in SQL?
4. What does the command Dbcc shrinkdatabase() do?
5. What is importance of dbcc showcontig()?
6. What are linked servers?