1. Explain about your SQL Server DBA Experience.
§ This is a generic question often asked by many
interviewers. Explain what are the different SQL Server Versions you have
worked on, what kind of administration of those instances has been done by you.
Your role and responsibilities carried out in your earlier projects that would
be of significance to the potential employer. This is the answer that lets the
interviewer know how suitable are you for the position to which you
are being interviewed.
2.
What are the different SQL Server Versions you have worked on?
§ The answer would be depending on the versions you
have worked on, I would say I have experience working in SQL Server 7, SQL
Server 2000, 2005 and 2008. If you have worked only the some version be honest
in saying that, remember, no one would be working on all versions, it varies
from individual to individual.
3. What are the different types of Indexes available in SQL Server?
§ The simplest answer to this is “Clustered and Non-Clustered Indexes”. There are other types of Indexes what can be mentioned such as Unique, XML, Spatial and Filtered Indexes. More on these Indexes later.
