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 normalization? Explain different levels of normalization? : Sql server database administration

1318

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1130

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1034

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

923

what are user defined datatypes and when you should go for them? : Sql server database administration

1017

what are constraints? : Sql server database administration

1056

what is the difference between delete table and truncate table commands? : Sql server database administration

1033

what is the information that can be stored inside a bit column? : Sql server database administration

963

how to avoid cursors? : Sql server database administration

969

what is the maximum size of a row? : Sql server database administration

1014

what are the disadvantages of cursors? : Sql server database administration

1029

what is a transaction? : Sql server database administration

992

what are candidate key, alternate key and composite key? : Sql server database administration

917

what is a self join? : Sql server database administration

1038

why would you use sql agent? : Sql server database administration

1210

Un-Answered Questions { SQL Server }

how you can list all the tables in a database?

1026

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

163

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1263

What is a system database and what is a user database?

1086

How to set a database state to offline in ms sql server?

1046

What is the report model project?

141

What is raid, and how it can influence database performance?

1054

What are the properties of the transaction?

1004

What is mssql?

985

How do I shrink an ldf file?

980

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1916

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

How does Report Builder support Analysis Services cubes?

153

What is a rollup clause?

968

What are system databases in ms sql server?

1056

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