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?

1043

Can two tables share the same primary key?

927

Can a table have 2 foreign keys?

905

What is meant by datasource?

924

How do I make a resultset scrollable?

961

Is resultset an interface?

970

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

1042

What is the return type of executeupdate ()?

907

What is create statement?

958

What program is used to store the data source file?

961

What is a data source file?

975

What is difference statement and preparedstatement?

981

Un-Answered Questions { SQL Server }

What happens if null values are involved in comparison operations?

977

Explain Normalization and DE normalization

1114

What are different types of subquery?

1245

Where in ms sql server is ’100’ equal to ‘0’?

1091

What is mscorsvw.exe - process - microsoft .net framework ngen?

955

Explain table valued parameters in sql server? Why tvp used?

1020

What are locks in sql?

984

What is filestream?

1001

Write a SQL query in order to merge two different columns into single column?

1036

How to recover from sql injection? : sql server security

1018

How to return the date part only from a sql server datetime datatype?

1103

What is the difference between substr and charindex in the sql server?

1102

What are ddl (data definition language) statements for tables in ms sql server?

1104

What are the underflow and overflow behaviors on float literals?

1113

What are approximate numeric data types in ms sql server?

1060

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