Installations:

1. Difference between various versions of SQL Server 2000/2005/2008/2008 R2 /2012/2014 and 2016 ?

2.Difference between various editions of SQL Server Express/Evolution edition, Developer/work group/Mobile edition and Standard/Enterprise/Data center edition ?

3. What is Hot fix,Cumulative update and Service Pack ? what are latest service packs for each version of SQL Server ?

Ans:

Hot fix –

Cumulative updates –

Service Pack  –

4. What are Software and Hardware prerequisites to install SQL Server ?

5.what are the SQL Server Services  and their purpose ?

6.what are the SQL Server protocols ?

7. what is the default port number for SQL Server?

8.What is Collation ? what is Default collation of SQL Server ?

Can Instance Level Collation be different from Database Collation ?

How to change collation settings of Database and Instance ?

9. What is difference between Server and Instance ?

10.How many SQL Server Instances can be installed on one Server?

11.How many databases can we create on one Instance ?

12. How many database files(mdf/ldf/ndf) can we create for one database ?

11.What is Service Account in SQL Server?

12.How would you determine the version and Edition of SQL Server Instance you are working on?

SQL Server Architecture:

Ref: http://udayarumilli.com/sql-server-architecture-qa-3/

Databases:

What are the best practices to place data files, log files and tempdb on Storage?

 

 

Advertisements