UHG, 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 Xchange, Bangalore interview Questions.

       I attended UHG Software Company’s interview in April 2012.  I have given all the questions which I faced during interview. 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 primary key and foreign key?

2.       What is the difference between unique key and primary key?

3.       What is a stored procedure? How can you declare input parameters and output parameters?

4.       One scenario: There is an employee table. And, I am moving employee table data to employee1 table. Next, I am deleting employee table. Now, I am getting the error. How can I handle this situation?

5.       How many reports have you created till now? What type of reports have you developed?

6.       What kind of charts have you developed?

7.       How can you fetch the data from the stored procedure and display in the report?

8.       From how many data sources have you fetched the data till now?

9.       Have you fetched the data ever from the Access data source?

10.   How do you get the data from the oracle data source?

11.   I have a report with currency values. If the currency is more than 1000 then need to show the value in green and less than 1000 need to display in red.

12.   What is the difference between CAST and Convert functions in sqlserver?

13.   Have you worked on the subscriptions? If yes, then see below scenario

14.   I have a report with city parameter. The cities are HYD, Chennai, Mumbai and Bangalore. I have to send this report in the mail to HYD people with HYD data and Chennai people with Chennai data and so on. Now, how can you achieve this functionality using subscriptions?

15.   How to pass parameter value dynamically to the report? How many datasets need to use to achieve this functionality? And How to change parameter value based on another parameter in the report?

16.   What is the LOOK UP function and uses in the reporting services?

17.   How to pass the parameter value to the MDX query?

18.   How to fetch the data from the cube and display it in the report?

19.   One scenario:  I have an access table with eno and ename are the columns? How can I access this data and display in the report?

20.   What is the @@parameters in sqlserver? like @@error,@@RowCount

21.   One Scenario : I have a table with one date. I need to fetch every time 3 months data whenever I run the report? How can you write query to achieve that functionality?

22.   How to use Excel as datasource in the report?

23.   How to get the current user ID who is running the report?

24.   What is CTE? And, tell me the syntax of the CTE function?