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

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1058

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

939

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1028

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1098

If a table does not have a unique index, can a cursor be opened on it?

911

Indexes are updated automatically is the full-text index also updated automatically?

1020

How you can minimize the deadlock situation?

1035

Can a database be shrunk to 0 bytes, if not, why?

1095

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1117

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1019

Why should one not prefix user stored procedures with ‘sp_’?

1038

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

988

What are the new data types are introduced in sql 2000?

896

List some of the rules that apply to creating and using a ‘view’

883

Explain active/passive and active/active cluster configurations?

1057

Un-Answered Questions { SQL Server }

How you can minimize the deadlock situation?

1035

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1046

Difference between connected and disconnected database in .net with sql server?

1092

what purpose does the model database serve? : Sql server database administration

971

What is a not null constraint?

1024

What is sub-query in sql server?

1199

What is the difference between Normalization and De-normalization?

1085

What is the sql server 2000 version number?

1074

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

977

What is purpose of normalization?

943

Benefits of Stored Procedures?

963

What is importing utility?

981

What is mssql?

980

Difference between aggregate functions of sql?

1100

What is the need for group functions in sql?

1081

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