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 does the report manager work in SSRS?

158

Can you always create a cache of a report?

178

Difference between Logical Page and Physical Page in SSRS.

491

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

168

What type of Index will get created after executing the above statement?

1150

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1088

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1141

What do you think of this implementation? Can this be implemented better?

1002

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1249

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

1222

What is the New in SQL server 2008?

1017

What are the types of indexes?

1138

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1175

Explain four layers of abstraction microsoft architectured?

147

What are the advantages of sql azure?

140

Un-Answered Questions { SQL Server }

Do you know what guidelines should be followed to help minimize deadlocks?

1018

What is 1nf normalization form?

1086

What is ddl and dml commands?

961

what is create database syntax? : Sql server database administration

1173

What is a recursive stored procedure in sql server?

1254

How to generate create procedure script on an existing stored procedure?

1073

Can I delete event logs?

980

How to create an identity column?

1306

What is Sqlpaging in SqlServer 2005 ?

1118

How many types of schemas are there?

1098

Relational calculus is what type of language?

1100

What is store procedure? When do you use?

993

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

1035

What is replication and database mirroring?

1093

How to start sql server browser service?

1186

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