SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is the difference between a "where" clause and a "having" clause?

1160

Explain Normalization and DE normalization

iNautix,

1102

Is INSTEAD OF trigger directly applicable to Table ?

1010

difference between Clustered index and non clustered index ?

Infosys,

989

What are indexers?

1084

What are the different SQL Server Versions you have worked on?

999

What are the different types of Indexes available in SQL Server?

1001

What is the difference between Clustered and Non-Clustered Index?

1052

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1158

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1136

How do you troubleshoot errors in a SQL Server Agent Job?

1053

What is the default Port No on which SQL Server listens?

1119

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?

1053

What is DCL?

1047

What are the commands used in DCL?

1019

Un-Answered Questions { SQL Server }

What are the steps you can take to avoid “deadlocks”?

971

What is the significance of null value and why should we avoid permitting null values?

980

What is key set driven?

950

Explain about sql server login?

1079

What is optimistic concurrency?

1034

How do I open port 1433?

930

How to create a stored procedure with a statement block in ms sql server?

1067

What is query processing?

932

How to disconnect from a sql server using mssql_close()?

1102

Can you tell me some of the common replication dmv's and their use? : sql server replication

920

What is primary key, unique key, and foreign key?

968

Is there any difference between primary key and unique with the not null condition?

942

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1192

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

970

What are the requirements to use odbc connections in php scripts?

1114

For More Un-Answered { SQL Server } Questions Click Here