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

Can you name a few encryption mechanisms in sql server?

991

What are subqueries in sql server?

1192

What is the purpose of update statistics and scope_identity() function?

1158

what do you understand by change data capture?

1077

Mention the different types of triggers?

1202

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1222

Explain the properties of subqueries in sql server?

1139

How do you start single user mode in clustered installations?

986

What are the differences between sql server and mysql.

1139

Mention the different types of replication in sql server.

1070

Explain the steps to create and execute a user-defined function in the sql server?

1016

What do you understand by triggers?

977

mention different types of relationships in the dbms?

1087

What is the command used to check locks in microsoft sql server?

1096

What do you understand by recursive stored procedure?

986

Un-Answered Questions { SQL Server }

How exceptions can be handled in sql server programming?

1073

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1139

How important do you consider cursors or while loops for a transactional database?

1011

What is the difference between clustered and non-clustered indexes in ms sql server?

1051

What are the kinds of subquery?

1071

What does it mean to normalize a database and why would you do it?

1024

What is a natural primary key?

1108

What is 3nf normalization?

1051

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

999

Do you know the capabilities of cursors?

1217

What do you know about normalization and de- normalization?

970

How can sql server instances be hidden? : sql server security

1217

How can windows applications connect to sql servers via odbc?

1177

Why use triggers?

1068

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1059

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