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?

941

What does ss stand for sexually?

1039

Why do we use trigger?

937

Can we write trigger for view?

976

Why we should not use triggers?

935

What does it mean to normalize data?

912

What is delete query?

915

Can we call future method from trigger?

898

What is b tree index?

873

What does truncate do?

898

What is 1nf 2nf and 3nf?

860

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

986

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

1000

What are the grouping functions?

906

What is triggers and its types?

972

Un-Answered Questions { SQL Server }

Explain aggregate functions?

1041

What is row_number()?

949

Explain the difference between primary keys and foreign keys?

967

Are resultset updatable?

909

What is mscorsvw.exe - process - microsoft .net framework ngen?

921

how to create a scrollable cursor with the scroll option? : Sql server database administration

1044

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

980

What is table constraint?

951

How to grant a permission in ms sql server using "grant execute" statements?

1053

If the job running very slow what is the action you do

1849

What are the five characteristics of good data?

889

How to convert a table data in XML format in sql server?

2502

Why use identity in sql server?

1041

Difference between Sql server reporting services and Crystal reports?

164

Why we should not use triggers?

935

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