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

Mention the differences between local and global temporary tables.

1043

What do you understand by check constraint in sql server?

945

What is the tcp/ip port on which sql server runs?

1160

What do you understand by intent locks?

1012

Explain log shipping and mention its advantages.

1044

Explain log shipping?

1017

What do you understand by the analysis services in sql server?

939

What are the steps you must follow to hide sql server instances?

978

What are the advantages of mirroring?

995

What do you understand by user-defined function in the sql server?

951

What are the differences between having and where clause.

966

What are the options which must be set to allow the usage of optimistic models?

963

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

985

Mention the command used to rename the database.

1006

Mention the differences between sql server and mysql.

1014

Un-Answered Questions { SQL Server }

What is acid mean in sql server?

1119

What is rtm version in sql server?

1051

What do you mean by a dependent functionality in a build?

1154

How do I setup a sql server database?

1073

Tell me what is normalization? Explain different forms of normalization?

1030

How do I find the default sql server instance?

943

What is attribute hierarchy? : sql server analysis services, ssas

1020

How to drop an existing user defined function in ms sql server?

1025

How to update muliple row in single query?

1058

Give an example of SQL injection attack ?

1006

How do we know if any query is retrieving a large amount of data or very little data?

975

How do I install only the client tools of sql server 2000?

1067

Explain the dirty pages?

1006

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

904

What do you understand by triggers?

922

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