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?

1116

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

997

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

1097

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?

1144

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

957

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

1062

How you can minimize the deadlock situation?

1081

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

1158

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?

1156

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

1060

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

1097

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

1041

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

947

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

922

Explain active/passive and active/active cluster configurations?

1106

Un-Answered Questions { SQL Server }

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1076

What is ms sql server triggers?

1070

How to delete duplicate rows?

1036

What is database mirroring?

1172

Is it safe to delete log files?

969

Explain different forms of normalization?

1001

What is surrogate key? : sql server analysis services, ssas

1158

what is the main function of a query parameter?

155

What is a hint?

1056

What are sql server functions?

1026

List out some of the requirements to set up a sql server failover cluster?

1074

What are the advantages of sql stored procedure?

1121

What are sql dirty pages?

1081

How many levels of sp nesting is possible?

1099

Explain in brief how sql server enhances scalability of the database system?

1024

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