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?

1174

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

1126

What is logshipping and its purpose?

1066

What are the dmvs?

1072

What is xml datatype?

1129

Can sql servers linked to other servers like oracle?

1008

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

1021

Does a sql server 2005 select statement require a from?

1072

How many databases instances are there in sql server 2000?

1167

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

1090

What are the advantages of using stored procedures?

1004

What is the command to change the recovery model?

1092

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

1070

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?

1037

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

1148

Un-Answered Questions { SQL Server }

Can primary key be null?

983

Do you know what is normalization of database? What are its benefits?

1203

How to encrypt Strored Procedure in SQL SERVER?

1229

Do you know what is xpath?

1154

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1088

How do I setup a sql server database?

1129

How to scale out a federation by Sql statement?

118

Why it is recommended to avoid referencing a floating point column in the where clause?

1016

explain different levels of normalization? : Sql server database administration

1049

Can we call future method from trigger?

1004

please differentiate between delete and truncate?

1038

Describe and explain about SQL native client?

1157

Differentiate between a local and a global temporary table?

998

What are the requirements for sql server 2016?

932

How to connect to SQL Azure Database by using sqlcmd?

140

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