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?

1087

Can two tables share the same primary key?

980

Can a table have 2 foreign keys?

953

What is meant by datasource?

982

How do I make a resultset scrollable?

1012

Is resultset an interface?

1037

What is the meaning of resultset type_scroll_insensitive?

989

What is difference between createstatement and preparedstatement?

1172

Which is faster statement or preparedstatement?

1001

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

1109

What is the return type of executeupdate ()?

950

What is create statement?

1007

What program is used to store the data source file?

1004

What is a data source file?

1020

What is difference statement and preparedstatement?

1031

Un-Answered Questions { SQL Server }

What is page in sql server?

995

Explain log shipping and mention its advantages.

1086

What is constraints and its types?

997

what is datawarehouse?

1155

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1935

Can you create a logon trigger in sql server 2005 express edition?

1119

What is simple indexing method?

1083

What are the restrictions applicable while creating views? : SQL Server Architecture

1082

What does it mean to manipulate data?

1050

What is standby servers? Explain types of standby servers.

1051

Write a sql query to sort on different column name according to the parameters passed in the function?

958

What is report rendering ?

162

What are clustered and non-clustered index?

1049

New concepts of sql server 2005 use in your project.

2399

How do I view a stored procedure in sql server query?

978

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