Interview question on DatabaseHi,
Recently I attended an interview call for .net developer position. I answered most of the questions.
But Interviewer asked me 2 database related questions and I am not able to convince him.
Can you give me proper explanation of below questions:
1. Explain different database optimization techniques with proper example?
2. During select queries we use locks for tables. So definitely it degrade the performance. So is there any other method available instead of locking table?