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

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 7035

how to get max salary with employee number by using one select query and max function ??

Genpact,

3 8836

What are the difference between data length and length in SQL Server-2008?

Scio Healthcare,

3 6508

Why foreign key column allowing null values even a parent tables reference key column not having null value..

IBM,

2 6307

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 5055

Write a query to get all details of employee who has maximum salary from employee table

AON, Genpact,

8 17037

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

Broadridge,

6 12446

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

HCL,

2452

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

Cognizant, HCL, Value Labs,

1 8289

how many non clustered index in sql server 2008,2010,2012

Accenture,

2 7255

what is the difference between table and view

1 3372

plss anybody specify tha constrian management system in dbms

Police Constable,

2205

How to genrate automaticlly empid like gt001

4 5868

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

Apple,

3 6904

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

IBM, L&T,

3 7217

Un-Answered Questions { SQL Server }

We need to perform what steps in the following order to work with a cursor?

1273

What function does a database engine serve in the sql server?

1079

How can you list all the table constraints in a database?

980

Explain about service Broker functions?

1086

How to delete existing rows in a table?

1245

How can sql injection be stopped? : sql server security

1100

What do mean by xml datatype?

1175

Is INSTEAD OF trigger directly applicable to Table ?

1064

How to create user defined functions with parameters?

1293

What is the purpose of the model database?

1065

What is a trigger? Why we need it?

1053

What is the size of transaction log file?

985

How do you use a subquery to find records that exist in one table and do not exist in another?

1087

What are Row versions of DataRow?

1080

What is a trace frag? Where do we use it?

1150

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