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?

934

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?

933

What is triggers and its types?

1009

Un-Answered Questions { SQL Server }

How to drop an existing user defined function in ms sql server?

1025

what is difference between view and Dip.

2409

What are the types of sql server?

1051

Can you leave a union at any time?

1061

What are different backups available in sql server?

1070

Can We Use Data-grids For Our Report In Ssrs?

184

How will you decide the active and passive nodes?

1128

Can we update data in a view?

1029

Define the one-to-one relationship while designing tables.

903

Explain user defined views?

963

Define full outer join?

955

What is coalesce and check constraint in sql server?

1121

What is linked report?

131

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2071

What are the hotfixes and patches in sql server?

1017

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