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 difference between cross join and Full outer join?

HP, Standard Bank,

1 7858

What are indexes? When do you need to create Indexes?

CarrizalSoft Technologies, HP,

4 8212

In which situation you use Self joins?

CarrizalSoft Technologies, HP, TCS,

1 7537

Describe about first three Normal forms.

HP,

1 6650

Write the Syntax for Cursors.

CarrizalSoft Technologies, HP,

2 6437

How to avoid cursors?

CarrizalSoft Technologies, HP,

3 8740

What are the various Isolation levels?

HP,

2 11386

wat is mean by trigger?.......normally wat use......when trigger used in sql........... plz cleary say with example.......

TCS, Wipro,

2 6207

wat is mean by normalization?......programing defination i need...(i know basic defination)

Wipro,

4 8707

If we use where clause in the left outer join then how the query would behave/act?

1 4098

write sql program to get the detail of student in a class?

2 10147

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

Cognizant, Infosys,

10 18398

What is Pointer ?

Cap Gemini, CarrizalSoft Technologies,

3 6641

what is call by value & call by reference ?

Cap Gemini,

2 13313

What is trigger ?

Cap Gemini, SQL,

7 12082

Un-Answered Questions { SQL Server }

What are points to remember while using the fillfactor argument?

970

What is the tcp/ip port on which sql server runs?

1159

What are orphan records?

932

What are the underflow and overflow behaviors on float literals?

1113

Explain transaction server implicit?

983

Do you know how to send email from database?

1005

What is service broker? : sql server database administration

993

What is a schema in ms sql server 2005?

969

How to find out what is the default collation in a database?

1122

What is the command used to check locks in microsoft sql server?

1044

What methods do you follow to protect from sql injection attack?

1028

What are triggers? How do you invoke a trigger on demand?

1318

What is the default value of an integer data type in sql server 2005?

952

How to create a local temporary stored procedure?

998

Do you know sql server 2008 introduces automatic auditing?

980

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