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?

916

Can a table have 2 foreign keys?

905

What is meant by datasource?

924

How do I make a resultset scrollable?

960

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 ()?

1040

What is the return type of executeupdate ()?

906

What is create statement?

954

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 use of partition by in sql server?

933

How many categories of functions based their return modes?

1103

What is an sql server agent?

1063

When to use Inner join & when to use subquery?

1162

what is difference between NULL and ISNULL in SQL Server 2008?

1014

How to locate and take substrings with charindex() and substring() functions?

1016

How many databases instances are there in sql server 2000?

1098

How to trouble shoot if unable to connect SQL Server

1992

What is logon trigger?

1096

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2362

Explain the relational database management system (rdbms)?

1098

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2785

What are a database and a data warehouse?

1022

what is unique and xaml nonclustered index

1051

What does dml stand for?

948

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