SQL Server Interview Questions

SQL Server is a relational database management system (RDBMS) developed by Microsoft. It is primarily designed and developed to compete with MySQL and Oracle database. So as a SQL Server professionals you might have faced these interview questions or going to face in your next job interview. So you can try these and prepare well.

Q.1 What is the role of SQL Server Configuration Manager?
Following are the roles of a SQL Server Configuration Manager. 1. to start, stop, pause, and restart SQL Server services 2. to configure the use of network protocols to access SQL Server 3. to configure SQL Server Native Client connectivity
Q.2 Which operating system is not compatible with SQL Server 2008 for installation?
Windows Server NT 4.0 is not compatible with SQL Server 2008
Q.3 Which software system is needed for SQL Server 2008 installation?
.NET Framework 3.5 is need for SQL Server 2008 installation
Q.4 What is the minimum amount of memory needed to run SQL Server 2008?
512MB of memory is at least needed to run SQL Server 2008
Q.5 Which shape is used to represent an entity in E-R diagram?
Rectangle is used to represent an entity in E-R diagram.
Get Govt. Certified Take Test