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 6669

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

Genpact,

3 8555

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

Scio Healthcare,

3 6196

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

IBM,

2 6112

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 4762

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

AON, Genpact,

8 16333

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 11958

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,

2335

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 7982

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

Accenture,

2 7048

what is the difference between table and view

1 3215

plss anybody specify tha constrian management system in dbms

Police Constable,

2082

How to genrate automaticlly empid like gt001

4 5558

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

Apple,

3 6655

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

IBM, L&T,

3 6918

Un-Answered Questions { SQL Server }

What are the approximate numeric data types?

877

can a database be shrunk with users active? : Sql server administration

953

What are different types of raid configurations? : SQL Server Architecture

1008

what kind of lan types do you know? : Sql server database administration

927

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1037

What do you mean by collation recursive stored procedure?

1013

What is the difference between a unique key and primary key?

897

How to enforce security in sql server? : sql server security

1043

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

996

What is the default order of an order by clause?

946

Where are full-text indexes stored?

948

What are the types of normalization?

972

How can sql server instances be hidden? : sql server security

1055

How to create an inline table-valued function?

909

What is the difference between local and global temporary tables?

1078

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