TCS, Hyderabad - SqlServer/MSBI Interview Questions asked by Companies

I have started posting a series of sqlserver/MSBI interview questions asked by companies.

       I attended TCS, Hyderabad Company’s interview in Dec 2015. 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.        What is the use of Recompilation of stored procedures? How do we use this?

3.        What is Statistics? Is statistics update automatically when recompile the procedure?

4.        What is the use of execution plan?

5.        What are the logical operators and physical operators?

6.        What is the use of Merge, Hash, Bookmark, Row locator and nested loop operators?

7.        How do you identify the slowly running queries?

8.        What are the events that you select in the profiler?

9.        If you find the query is slow running then what are the possible causes?

10.     What are the logical reads and physical reads?

11.     What is the difference between Table variables and temporary tables?

12.     What are the differences in terms of Transactions in temporary tables and table variables?

13.     How will you identify the active transaction count?

14.     Can primary key be created in the table variable?

15.     What are the isolation levels? What is the default isolation level of sqlserver? What is the fastest and slowest isolation level?

16.     What is the use of indexes? Why we use indexes? What are the types of indexes? How to re-organise and re-build indexes?

17.     What is the fill factor? What is the advantage and disadvantage of setting fill factor?

18.     Is downtime required for Re-build of indexes?

19.     Difference between functions and stored procedures? Can I use GETDATE() inside the function?

20.     What is the view? What is the use of indexed view and disadvantages of indexed view?

21.     What is the difference between STUFF & REPLACE functions?

22.     What are the types of triggers? What is the use of DML triggers?

23.     What is the use of DDL triggers? What are the changes that are coming under schema changes?

24.     What is the disadvantage of SendMail task in SSIS?

25.     What is the user of LOOKUP transformation?

26.     What is the use of Cache & default caching in SSIS?

27.     What is the advantage of “FAST LOAD” option in OLEDB destination?

28.     What are the early arriving facts & late arriving dimensions?

29.     I have one scenario

Emp ID	Login	Logout
1	9:00 AM	10:00 AM
1	10:20 AM	12:20 PM
1	02:00 PM	07:30 PM

How to find out how much time an employee spent in the office using sql query?

30.     What are the cascaded parameters in SSRS?

31.     How do you create sub-reports?

32.     What are the difference between sub reports and linked reports?

33.     How do you deploy the reports into the server? How many type of it?

34.     How do you open SSRS report in separate window?

35.     How will you restrict the rendering options?

36.     What is the use of “Internal” option in SSRS parameters?

37.     What is the OUTPUT clause in Sqlserver?