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?

1132

Mention the differences between substr and charindex in sql server.

1050

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

917

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

925

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

1047

Mention the differences between having and where clause.

1057

Explain the usage of floor function in sql server.

964

What do you understand by replication in sql server?

1061

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

991

Mention the different authentication modes in sql server.

1055

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

977

Mention a few common trace flags used with sql server?

929

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?

958

What do you understand by coalesce in sql server?

1069

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

1068

Un-Answered Questions { SQL Server }

How to create a view with data from multiple tables?

1012

What is Cross Join and in which scenario do we use Cross Join?

1013

What is difference between order by and group by?

1006

How to check parameter value in stored procedure sql server?

971

What are out-of-range errors with date and time literals?

1030

What is an index. What are the types?

1090

What is the purpose of the master database?

1129

How to divide query output into multiple groups with the group by clause in ms sql server?

1037

Explain the Ways to improve the performance of a sql azure database?

How to provide values to user defined function parameters?

1008

What is key attribute?

933

What is a functions and types in sql server?

1087

How to find related tables in sql server?

944

How to connect ms access to sql servers through odbc?

1028

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2076

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