What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
How do you troubleshoot errors in a SQL Server Agent Job?
What is the default Port No on which SQL Server listens?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
What is DCL?
What are the commands used in DCL?
What is the default fill factor value?
Where do you find the default Index fill factor and how to change it?
What is a system database and what is a user database?
What are the recovery models for a database?
What is the importance of a recovery model?
What is Replication?
What the different types of Replication and why are they used?
What the different components of Replication and what is their use?