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?

1040

Can two tables share the same primary key?

913

Can a table have 2 foreign keys?

905

What is meant by datasource?

924

How do I make a resultset scrollable?

958

Is resultset an interface?

967

What is the meaning of resultset type_scroll_insensitive?

956

What is difference between createstatement and preparedstatement?

1090

Which is faster statement or preparedstatement?

945

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

1039

What is the return type of executeupdate ()?

906

What is create statement?

951

What program is used to store the data source file?

961

What is a data source file?

974

What is difference statement and preparedstatement?

978

Un-Answered Questions { SQL Server }

What is the difference between clustered index and primary key?

921

When to use Inner join & when to use subquery?

1161

What do you mean by a Composite primary key?

1103

How to use clusters?

945

What are the types of subquery?

1040

What is triggers in ms sql server?

1118

How do I connect to sql server database?

1010

What is history table in sql server?

971

What command is used to rename the database?

1011

What is trace flag in sql server?

1018

How do I find information about the install locations for the various instances running on a computer?

1085

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

944

Can we write trigger for view?

1009

What are the transaction properties?

1014

Name the different type of indexes in sql?

965

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