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 a job?

3 6169

What are primary keys and foreign keys?

4 8145

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 11482

If a stored procedure is taking a table data type, how it looks?

1 6449

How m-m relationships are implemented?

2 8313

How do you know which index a table is using?

4 12912

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 8432

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 8980

How can you get @@error and @@rowcount at the same time?

9 24289

What are sub-queries? Give example? In which case sub-queries are not feasible?

Infosys,

4 11955

What are the type of joins? When do we use Outer and Self joins?

3 10239

Which virtual table does a trigger use?

TCS,

8 27411

How do you measure the performance of a stored procedure?

Infosys,

3 16191

Questions regarding Raiseerror?

1 6873

Questions on identity?

Infosys,

2 7019

Un-Answered Questions { SQL Server }

How do you implement session management in SQL Server mode?

1103

How to insert and update data into a table with "insert" and "update" statements?

987

What is a data source or ds? : sql server analysis services, ssas

1006

Which are ddl commands?

1047

What is a data collection table?

1008

What is buffer cash and log cache in sql server?

1122

Tell me what are the essential components of sql server service broker?

941

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

945

Do you know nested transaction?

958

Explain activity monitors

1076

Explain why variables called the most powerful component of ssis?

1097

Explain Capacity planning to create a database? and how to monitor it?

4204

What is the difference between clustered and a non-clustered index?

1028

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

943

Is foreign key unique?

995

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