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

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 4511

Is index a datbase objects in sql server?

2 5019

What is Dedicated Administrator Connection in sql server 2005?

2 5573

why SQL server is more used to store database rather than Access

2 4724

How many types of Joins in SQL Server 2005?

CarrizalSoft Technologies, HCL,

9 12238

What is Inner Join?

2 5275

What is Outter Join?

1 4051

How many types of Outer Joins?What are they?

1 3834

What is Left Outer Join?

2 4581

What is Right Outer Join?

2 4639

What is Full Outer Join?

3 6233

What is Cross Join

3 6676

Diff. b/w Full Outer Join And Cross Join?

3 7567

What is Self Join?

4 6731

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

Logitech, Mphasis,

1 16671

Un-Answered Questions { SQL Server }

What is use of except clause? How it differs from not in clause?

1065

Explain the concepts and capabilities of sql server?

1014

What is sql injection and why is it a problem? : sql server security

1192

What does null mean?

1054

What is the difference between a function and a stored procedure?

1128

Can we use trigger new in before insert?

971

Which are the olap features?

1013

Is mysql the same as sql server?

1034

What are the benefits and tasks of object explorer? : sql server management studio

1263

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

1005

What are points to remember while using the fillfactor argument?

1019

Can a synonym name of a table be used instead of a table name in a select statement?

1095

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1988

How to provide values to user defined function parameters?

1064

Can we deploy SSRS reports on our personal website?

176

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