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 data source document?

1085

Can two tables share the same primary key?

977

Can a table have 2 foreign keys?

949

What is meant by datasource?

979

How do I make a resultset scrollable?

1010

Is resultset an interface?

1035

What is the meaning of resultset type_scroll_insensitive?

988

What is difference between createstatement and preparedstatement?

1167

Which is faster statement or preparedstatement?

999

What is the difference between executequery () and executeupdate ()?

1105

What is the return type of executeupdate ()?

947

What is create statement?

1003

What program is used to store the data source file?

1002

What is a data source file?

1020

What is difference statement and preparedstatement?

1030

Un-Answered Questions { SQL Server }

List some major differences between triggers and stored procedures?

977

What is indexed view?

1019

What is a transact-sql statement?

1121

explain different types of cursors? : Sql server database administration

1139

in the physical file layout, where should the transaction log be stored in relation to the data file?

1038

What do you mean by an execution plan? Why is it used?

1073

What's the information that can be stored inside a bit column?

1067

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1196

What is the chart in report?

163

What is the process of normalization?

1178

What is data compression? : sql server database administration

1011

What are the different sql server versions?

1028

What are some examples of schemas?

1018

Explain few examples of stored procedure over triggers?

1109

How would you use user_constraints table in DB?

1054

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