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 are the advantages of paper records?

1010

What is the difference between sdf and mdf?

1348

What is acid db?

927

How do I find my localdb version?

1022

What are the 7 disadvantages to a manual system?

1028

What is a dbms wizard?

1068

What is advantage data architect?

973

What is field in algebra?

1092

What is a field name?

1017

Where is localdb stored?

990

How do I know if localdb is running?

993

What does normalization do to data?

1135

What are the five characteristics of good data?

969

What is data file in computer?

998

Why is normalisation important?

986

Un-Answered Questions { SQL Server }

What are policy management terms?

1036

what is the difference between Delete and Truncate command in SQL

1194

What is the synonym of join?

1011

What are the characteristics of modern DBMS?

1137

How does normalization work?

966

In what sequence sql statement is processed?

1052

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1447

How does index makes search faster?

1023

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1072

How can you find out how many rows returned in a cursor?

1079

What is lookup override?

1079

What is data source view or dsv? : sql server analysis services, ssas

1052

What is policy management?

1041

What is the purpose of optimization?

1054

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1086

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