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 3nf normalization?

995

What does ss stand for sexually?

1084

Why do we use trigger?

971

Can we write trigger for view?

1009

Why we should not use triggers?

963

What does it mean to normalize data?

940

What is delete query?

940

Can we call future method from trigger?

937

What is b tree index?

915

What does truncate do?

936

What is 1nf 2nf and 3nf?

891

What is the difference between a stored procedure and a user defined function?

1020

What is the difference between a view and a stored procedure?

1037

What are the grouping functions?

934

What is triggers and its types?

1009

Un-Answered Questions { SQL Server }

What happens if strings are casted into wrong code pages in ms sql server?

1113

How to resolve the orphan use problem? : sql server security

1014

What is the difference between a fill factor of 100 and 0?

981

How to create a testing table with test data in ms sql server?

1083

What is the new security features added in sql server 2016? : sql server security

1116

Do you know what is sql service broker?

1086

Do you know what is similarity and difference between truncate and delete in sql?

1007

What is the difference between seek predicate and predicate?

1060

What is join query?

893

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1069

How do I save a stored procedure in sql server?

996

How to create function with parameter in sql server?

1105

What is a trigger? Why we need it?

996

What are indexes in sql?

1281

How do we Backup SQL Azure Data?

108

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