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 4428

Is index a datbase objects in sql server?

2 4890

What is Dedicated Administrator Connection in sql server 2005?

2 5477

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

2 4609

How many types of Joins in SQL Server 2005?

CarrizalSoft Technologies, HCL,

9 11996

What is Inner Join?

2 5152

What is Outter Join?

1 3959

How many types of Outer Joins?What are they?

1 3760

What is Left Outer Join?

2 4482

What is Right Outer Join?

2 4556

What is Full Outer Join?

3 6088

What is Cross Join

3 6534

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

3 7451

What is Self Join?

4 6592

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 16569

Un-Answered Questions { SQL Server }

what types of replication are supported in sql server? : Sql server database administration

1045

How do I connect to sql server database?

1011

Can you edit the .rdl code associated with a linked report?

163

What is the difference between mysql and mysqli?

1202

Can a trigger be created on a view?

956

Does order by actually change the order of the data in the tables or does it just change the output?

1146

What is check constraint in sql server?

1002

what are defaults? : Sql server database administration

1091

What are the steps to insert a table?

945

What are indexes in ms sql server?

1057

Explain system functions or built-in functions? What are different types of system functions?

979

Explain the flow of creating a cube? : sql server analysis services, ssas

1050

what are the different types of replication you can set up in sql server? : Sql server database administration

1023

Explain DBCC?

960

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1147

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