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?

1210

Explain Normalization and DE normalization

iNautix,

1160

Is INSTEAD OF trigger directly applicable to Table ?

1068

difference between Clustered index and non clustered index ?

Infosys,

1037

What are indexers?

1134

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

1060

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

1057

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

1102

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

1214

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

1190

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

1107

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

1175

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?

1108

What is DCL?

1104

What are the commands used in DCL?

1082

Un-Answered Questions { SQL Server }

what is the system function to get the current user's user id? : Sql server database administration

1071

what are user defined datatypes? : Sql server database administration

1015

What is self contained sub query?

1120

What is meant by indexing?

1085

List the different index configurations possible for a table?

983

How to change a login name in ms sql server?

1134

How to delete existing rows in a table?

1246

What is clustered vs nonclustered index?

1003

What are dml (data manipulation language) statements in ms sql server?

1025

How to create a user to access a database in ms sql server using "create user" statements?

996

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1116

Can we hide the definition of a stored procedure from a use?

1296

What is data set in report?

147

What types of Joins are possible with Sql Server?

1191

How to test subquery results with the exists operator?

1167

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