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 scan table/view and seek table/view when its occurs? : sql server database administration

1038

How to truncate the log in sql server 2012? : sql server database administration

1278

What is the difference between lock, block and deadlock? : sql server database administration

1037

Explain the different types of backups available in sql server? : sql server database administration

917

What stored by the master? : sql server database administration

1100

What stored by the msdb? : sql server database administration

1001

What are the joins in sql server? : sql server database administration

998

Describe the left outer join & right outer join. : sql server database administration

992

What is data compression? : sql server database administration

964

What is blocking and how would you troubleshoot it? : sql server database administration

1041

What is sql profiler. What are the default templates with it? : sql server database administration

1028

Where the sql logs gets stored? : sql server database administration

960

What stored by the model? : sql server database administration

948

How do you test your database? : sql server database administration

1009

How to view the error log for any specific instance? : sql server database administration

1031

Un-Answered Questions { SQL Server }

Can you roll back the ddl statement in a trigger?

958

How to rebuild the master database?

1076

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1039

What is transaction server isolation?

1032

What is sharding?

116

Do you think BCNF is better than 2NF & 3NF? Why?

1273

What is the data type of time?

961

What is sql server english query?

1114

Do you know what is sql service broker?

1074

What are distributed partitioned views?

1062

Explain what is public role in sql server?

1117

What is SQL Azure Federations?

112

What is meant by referential integrity?

1006

How do I start sql server?

966

Difference between Sql server reporting services and Crystal reports?

168

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