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?

5.      What is the purpose of Execute SQL statement in Sqlserver?

6.       I am calling a stored procedure from another stored procedure.  What will happen if the transaction failed in the second Stored Procedure? And, when will the rollback will happen?

7.          What are the new data types introduced in Sqlserver 2008?

8.     What is the use of CTE?

9.      . What is the use of Merge?

10.       What are the different Isolation levels in Sqlserver 2008?

11.       What are the different types of precedence constraints in SSIS 2008?

12.        What is the use of MaxConcurrent Executable property in SSIS 2008?

13.   What is the use of Write back feature in SSAS?

14.   How many levels of Hierarchies we can apply in SSAS?

15.   What is Fact relationship?

16.      How to provide security for perspectives?

17.   Whether we need perform partition first or aggregation first while creation of the cube in SSAS 2008?

18.  What are the similarities between partitions or aggregations in SSAS 2008?

19.  How to change the color of alternate rows in SSRS 2008?

20. What is the confirmed dimension in data warehouse?

21. How to create a temporary table in SSIS 2008?

22. What is the use of Checkpoints and how to enable them in SSIS?

23. What is the difference between Union All & merger transformations?

24. What is the late arrival dimension?

25. How many levels granularity can we apply in SSAS attributes?

26. What are the cascaded parameters in SSRS?

27. What is the difference between Drill down & Drill through reports in SSRS?