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

Tell me about the approaches which you used to counter the DI problems.

EXL,

1427

What is nolock hint in sql server 2008

HCL,

1181

What is normalization? Explain its different types?

GE, Maveric,

1152

Different types of keys in SQL?

Infosys,

1141

What are Spatial data types in SQL Server 2008

Infosys,

1072

Give main differences between "Truncate" and "Delete".

HCL,

1150

What method is used by the Command classes to execute SQL statements that return single values?

B-Ways TecnoSoft,

1115

How can you insert values in multiple rows using one Insert statement?

Flextronics, Thomson Reuters, Virtusa,

1150

What is CTE in SQL

Infosys,

994

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

Global Logic,

1051

What is NOT NULL Constraint in sql server 2012?

CDC,

1045

Tell me about pre-defined functions of sql?

EXL,

1158

Differentiate between SQL and ORACLE joins and write their syntax.

Global Logic,

1071

Explain about Views?

Infosys,

1123

How to create hyperlink from returned sql query ?

MCN Solutions,

1183

Un-Answered Questions { SQL Server }

What is the use of keyword with encryption. Create a store procedure with encryption?

998

What is default constraint?

1054

What is the definition for sql server 2000?

1137

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4457

write an SQL query to list the employees who joined in the month of January?

1737

Explain about service Broker functions?

1089

How to make conditional sum in ssrs?

183

where can you add custom error messages to sql server? : Sql server administration

1173

Why does sql studio use a single registered database repository? : sql server management studio

1036

Tell me what are the advantages of using stored procedures?

1062

what is a transaction and what are acid properties? : Sql server database administration

1089

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1125

What are the restrictions while creating batches in sql server?

1113

How many databases can we create in a single server?

209

Explain contrast amongst grouped and non-bunched records?

1089

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