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 the importance of three tier architecture?

QuestPond,

1141

What is the difference between functions and scalar functions?

EXL,

1278

How to call a function from a stored procedure in SQL Server ?

HCL,

1085

What is 'Join' and explain its various types.

Genpact,

1211

What do you do in data exploration

EXL,

1050

Difference between 2NF &3NF ?

Cap Gemini,

1132

What will happen when a Rollback statement is executed inside a trigger?

Flextronics, Hexaware,

1 2047

What do you mean by a dependent functionality in a build?

HCL,

1197

How do you create type- insensitive operator?

EXL,

1099

Give me a SQL Query to find out the second largest company?

Ernst Young,

1227

Explain different types of Normalization.

HPCL, Hughes Systique Corporation, Ittiam Systems,

1 1901

What is the difference between Triggers and Stored Procedure?

HCL,

1155

Explain the concept of view and Types of views in SQL server?

HCL,

1034

How to connect of datebase with sql express.?

MCN Solutions,

1145

What do you mean by a Composite primary key?

Genpact,

1187

Un-Answered Questions { SQL Server }

Write a SQL query to delete a table?

1185

What is left outer join in sql server joins?

1106

How to connect to SQL Azure Database by using sqlcmd?

140

How can we get count of the number of records in a table?

996

How do I find the transaction log size in sql server?

1002

What is 2nf normalization form?

1200

Can one drop a column from a table?

1067

What is trigger and different types of Triggers?

1199

What are trace flags and mention a few common trace flags used with sql server?

1137

what exactly sql injuction.how to overcome.....

2595

Do you know what are various aggregate functions that are available?

1215

What are unicode character string data types in ms sql server?

1344

What is service broker? : sql server database administration

1029

What is conditional split?

1141

what's the information that can be stored inside a bit column? : Sql server database administration

1086

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