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

What is usually the first word in a sql query?

1128

How do I install only the client tools of sql server 2000?

1061

What is logshipping and its purpose?

989

What are the dmvs?

1010

What is xml datatype?

1074

Can sql servers linked to other servers like oracle?

943

When a primary key constraint is included in a table, what other constraints does this imply?

983

Does a sql server 2005 select statement require a from?

1016

How many databases instances are there in sql server 2000?

1094

What are four major operators that can be used to combine conditions on a where clause?

1039

What are the advantages of using stored procedures?

944

What is the command to change the recovery model?

1040

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1024

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

981

Will count(column) include columns with null values in its count?

1088

Un-Answered Questions { SQL Server }

How to create an index on a view?

1064

What are the restrictions while creating batches in sql server?

1059

Explain ranking functions?

1041

How to list all stored procedures in the current database using ms sql server?

1127

What is collation?

1136

Explain different types of self contained sub query?

1023

What are database states in ms sql server?

1175

How sql server executes a statement with nested subqueries?

1024

Can a trigger be created on a view?

951

Why is replication required on the sql server?

1056

Explain features and concepts of analysis services?

970

What is single-user mode?

924

What is model database in sql server?

1047

Explain transaction server distributed transaction?

971

How does a profiler work?

920

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