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

Explain logical operators in sql server?

1185

What methods do you follow to protect from sql injection attack?

1075

List some major differences between triggers and stored procedures?

980

What is a cursor, index in sql?

1130

Explain trigger and its types?

1118

What are the types of stored procedures in an sql server?

1040

What are the two modes of authentication in sql server?

1139

What is mssql?

1035

What are the advantages of using a stored procedure?

1065

What are the differences between stored procedure and view in sql server?

1322

What is filter index?

996

What are types of subqueries?

1140

What do you mean by collation recursive stored procedure?

1112

When would you use the stored procedures or functions?

1056

How will you optimize a stored procedure optimization?

1118

Un-Answered Questions { SQL Server }

Explain few examples of stored procedure over triggers?

1124

What is data source in connection string?

958

What is difference between count (*) and count column?

950

How to create a simple table to test triggers in ms sql server?

1039

What is difference between standardization and normalization?

1166

Tell me what is sql profiler?

1087

What is indexing a document?

1094

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1074

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1005

What is a unique index?

979

mention different types of relationships in the dbms?

1094

Does hive support indexing?

1004

What are indexes in sql?

1356

Explain four layers of abstraction microsoft architectured?

147

What is index fragmentation in ms sql server?

1150

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