Sonata Software Solutions,Bangalore - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted Capgemini, Hyderabad interview Questions

       I gathered Sonata Software Solutions, Bangalore Company’s interview questions in Dec 2013. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

(1)   Tell me about yourself?

(2)   Tell me about your current project?

(3)   Out of 3 tools, which one is more comfortable?

(4)   What do you mean by type 2 SCD?

(5)   What do you mean by type 1 SCD?

(6)   What do you mean by type 3 SCD?

Capgemini,HYD - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted Hitachi Consulting, Hyderabad.

       I gathered Capgemini Consulting, Hyderabad Company’s interview questions in Dec 2013. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

1.       What is the difference between Delete - Truncate: in terms of transaction rollback?

2.       Write a Query to get maximum 5th salaried employee?

3.       Write a single DML statement to replace 0 with 1 & 1 with 0?

4.       How to call a Query which is in a variable?

Hitachi Consulting,HYD - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies. Last post, I have posted L&T, Chennai interview Questions

       I gathered Hitachi Consulting, Hyderabad Company’s interview questions in Dec 2013. I will provide answers to the below questions shortly. Please keep on visit this page for more updates.

Happy Job Hunt!! ALL THE BEST!!

1.       What is the difference between Delete - Truncate: in terms of transaction rollback?

2.       Write a Query to get maximum 5th salaried employee?

3.       Write a single DML statement to replace 0 with 1 & 1 with 0?

4.       How to call a Query which is in a variable?