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?

1128

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

1001

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

1103

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?

1148

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

961

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

1073

How you can minimize the deadlock situation?

1089

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

1169

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?

1166

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

1069

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

1104

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

1046

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

955

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

928

Explain active/passive and active/active cluster configurations?

1110

Un-Answered Questions { SQL Server }

What is table value parameters (tvp)?

1154

what is a schema in sql server 2005? : Sql server database administration

1086

What is a dataset and what are the different types of datasets?

141

What is user-defined function?

1035

What are different types of views?

990

What is partition index in sql server?

1176

What is merge join?

1240

How to select all columns of all rows from a table with a select statement in ms sql server?

1200

What happens to a statement batch if there is a compilation error?

1013

Explain cursor as data base object?

1099

What are indexes in sql?

1355

Why union all is faster than union?

981

Explain what is it unwise to create wide clustered index keys?

1027

Why should we go for stored procedures? Why not direct queries?

1160

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

985

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