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 4509

Is index a datbase objects in sql server?

2 5014

What is Dedicated Administrator Connection in sql server 2005?

2 5572

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

2 4718

How many types of Joins in SQL Server 2005?

CarrizalSoft Technologies, HCL,

9 12226

What is Inner Join?

2 5266

What is Outter Join?

1 4044

How many types of Outer Joins?What are they?

1 3829

What is Left Outer Join?

2 4580

What is Right Outer Join?

2 4637

What is Full Outer Join?

3 6226

What is Cross Join

3 6670

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

3 7566

What is Self Join?

4 6718

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 16661

Un-Answered Questions { SQL Server }

What is a mixed extent?

1079

How to return the second 5 rows in ms sql server?

1108

Explain what is the main purpose of having conversation group?

988

What is ddl and dml commands?

959

What is difference between join and natural join?

1061

You want to implement the one-to-one relationship while designing tables. How would you do it?

1014

What command must you use to include the not null constraint after a table has already been created?

1234

Can we write trigger for view?

1071

What is the maximum size of column in sql server?

944

Explain where clause?

1033

What is enhanced database mirroring in sql server 2008?

1035

Explain the Ways to improve the performance of a sql azure database?

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1012

Explain tablesample?

1040

What is a filestream?

1045

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