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?

990

Can two tables share the same primary key?

870

Can a table have 2 foreign keys?

860

What is meant by datasource?

880

How do I make a resultset scrollable?

920

Is resultset an interface?

914

What is the meaning of resultset type_scroll_insensitive?

919

What is difference between createstatement and preparedstatement?

1039

Which is faster statement or preparedstatement?

898

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

981

What is the return type of executeupdate ()?

870

What is create statement?

900

What program is used to store the data source file?

921

What is a data source file?

928

What is difference statement and preparedstatement?

939

Un-Answered Questions { SQL Server }

What is collation sensitivity?

1000

Explain transaction isolation levels in sql server?

1055

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

986

How to find the version of sql server? : sql server database administration

1057

What is named calculation? : sql server analysis services, ssas

946

What are the different sql server versions?

943

How to use user defined functions in expressions?

1023

How to start and end transact-sql statements?

986

Explain about temporary stored procedure?

946

What are functions in the sql server?

1145

How do you know if sql server is running on your local system?

991

How to enable/disable indexes?

1024

How can you start sql server in different modes?

934

what is a join and explain different types of joins? : Sql server database administration

923

How to convert numeric values to integers in ms sql server?

1025

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