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

How the authentication mode can be changed?

1176

Mention the differences between substr and charindex in sql server.

1112

Write an sql query to find first weekday of the month?

975

What do you understand by triggers and mention the different types of it?

998

When do you think a developer should use sql server-based cursors?

1102

Mention the differences between having and where clause.

1120

Explain the usage of floor function in sql server.

1018

What do you understand by replication in sql server?

1126

What do you understand by hotfixes and patches in sql server?

1030

Mention the different authentication modes in sql server.

1105

Mention the 3 ways to get a count of the number of records in a table.

1025

Mention a few common trace flags used with sql server?

980

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1018

What do you understand by coalesce in sql server?

1127

What do you understand by mirroring and mention the advantages of the mirroring?

1112

Un-Answered Questions { SQL Server }

What are clustered and non-clustered index?

1049

What is a select query statement in ms sql server?

1129

What is abstracting periodical?

991

What is the difference between commit and rollback?

986

Explain in details security in SQL azure?

123

Explain error handling in ssis?

1070

What is database white box testing?

1176

how we use window authentication connection with sql server.?

1211

how can you check the level of fragmentation on a table? : Sql server administration

1037

What are the rendering extensions of ssrs?

160

How to automatically create a log when an exception is being received into SQL Server?

1359

How can you ensure that the database and sql server based application perform well?

1123

How do I find the transaction log size in sql server?

1002

Give me a SQL Query to find out the second largest company?

1227

What objects does the fn_my_permissions function reports on? : sql server security

1084

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