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?

1069

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

949

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

1044

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?

1109

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

921

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

1034

How you can minimize the deadlock situation?

1048

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

1113

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?

1126

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

1026

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

1053

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

1007

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

912

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

888

Explain active/passive and active/active cluster configurations?

1065

Un-Answered Questions { SQL Server }

Can we use max in where clause?

939

What is the difference between a primary key and a unique key? Are they the same?

1081

how to do partition in sqlserver

2484

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

949

what is a traditional network library for sql servers? : Sql server database administration

963

What is the difference between ddl and dml?

1058

Give an example of why you would want to denormalize a database

982

What is abstracting periodical?

953

What is the difference between stored procedure and functions?

1142

How to specify the collation for a character data type in ms sql server?

1037

What is optimistic concurrency?

1044

How to list all schemas in a database?

1069

What purpose does the model database server?

1105

What do we have to check in database testing?

1026

How to provide default values to stored procedure parameters?

1071

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