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 explicit mode in sql server?

1068

What is logon trigger?

1105

How to Update from select query in sql server?

1067

What is system stored procedures?

1048

What is sql injection? How to protect against sql injection attack?

1003

What is repeatable read?

1024

What is a rollup clause?

974

How can I know what locks are running on which resource?

957

When I delete any data from a table, does the sql server reduce the size of that table?

1024

What is user-defined functions? What are the types of user-defined functions that can be created?

1039

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1084

How to find the list of fixed hard drive and free space on server?

1205

What is difference in performance between insert top (n) into table and using top with insert?

1054

What is change data capture (cdc) in sql server 2008?

1030

Where are sql server usernames and passwords stored in the sql server?

1118

Un-Answered Questions { SQL Server }

What is nested transaction?

1106

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1149

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1961

Can we use pragma autonomous_transaction in trigger?

963

Which are new data types introduced in sql server 2008?

1057

What causes index fragmentation?

999

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2227

What are the dmvs? : sql server database administration

1067

What is query processing?

942

Explain Normalization and DE normalization

1116

What does nvl stand for?

946

what is an extended stored procedure? : Sql server database administration

1063

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1044

What is purpose of normalization?

952

What are the differences between substr and charindex in sql server.

1123

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