SQL Server Interview Questions & Answers – # 4

On last Sunday, I have given a technical interview for a company based out from Hyderabad. So with out further delay I will list the questions-

1. Write a SQL script to implement Fibonacci series in SQL Server up to 200.
2. You have given a requirement? How do you start DB design for it?
3. What are column store indexes? How they are better for performance?
4. How to find 2nd highest number from a integer array in C#/C language?( Yes its not related to SQL :))
5. What are Spools in Execution Plan? What are the types of Spools in execution plans?
6. How SQL Server handles concurrency in SQL 2014?
7. What is a Partition Column in SQL Server?
8. If the partition column value is NULL, then in which partition rows are inserted or will the insert statement will give error on insertion?
9. What is Range right and range left in SQL Server?
10. What is the Partition Scheme?
11. How you can achieve high availability in SQL SERVER, Your database should be up all the time, 0% downtime is required.
12. How you can achieve high availability in applications, Your application should be up all the time,0 downtime is required.

Shall update the answers tomorrow-

Cheers, Thanks for reading !

-Pawan Khowal

MSBISkills.com