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?

  

WIPRO, Bangalore - SqlServer/MSBI Interview Questions asked by Companies

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

I gathered some of the most important questions that are asked in Wipro’s walk in 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.        Tell me about yourself?

2.        Suppose in my table i have 300 records. In that 300 records i want to update first 100 records with today's date. 101 to 200 records with yesterday's date and 201 to 300 records with tomorrow’s date. How can we do this?

3.        We have 10 sheets in Excel File and 10 sheets contain error data. How to load 9 sheets data in to 1 destination and other error data in to other destination?

4.        Without using multiple sorts how we can sort the data in SSIS ?

5.        Can we declare a variable in SSRS ? If Yes, How ?

6.        What is the connection manager for Loggings in SSIS? Where can we check for the connection managers for all tasks in SSIS?

7.        Suppose I have 10 Packages in Prod Server and now we got one new package created in Development Server and got to be deployed in Prod Server. How to do this? (Without effecting the previous packages)

8.        Difference between 2008R2 and 2012 Deployment process in SSIS and major differences between them.

9.        i have one table in one column

empid

1

2

3

4

5

6

            Now,  I want to show the output as below using SSIS package.  

Empid

'1','2','3','4','5',6'

10.     What are the configurations in SSIS that are stored in local server?

11.     Which type of authentication (protection level) is used in SSIS dts utility deployment?

12.     How to find system user passwords and usernames in Sqlserver?

13.     NOLOCK is similar to which isolation level in sqlserver?

14.     How to delete duplicate records from given table without using CTE?

15.     In my SSIS package, I am using Foreachloop container to load multiple flat files.

Now my requirement is that I want to load only those file which contains %vendor%.

In source folder, I have many files but I am interested in to load only those file which

contains the string %vendor% in file name. How to load it?

16.     I have a table with only one column like

Column A

2000

-1000

4000

-3000

                  Now, I want to show the nagitive and possible values in separate columns without using                    case and decode functions..

17.     I have one package and that package is already scheduled is it possible to apply the transaction for that package?

18.     Suppose, I have one folder with 5 text files. By using for each file enumerator, we store each file in to one folder. But, suddenly tomorrow one more file adds to that folder how to store the file into same destination?

19.     Suppose I have one destination table with some data suddenly 2 excel files data want to insert into the destination table but how to know this data is already inserted into the destination and only new data is inserted into the destination?

20.     My input is

Col

Shashi@gmail.com

Reddy.gmail.com

            My output should be as below. Write a query in sqlserver

Col

sxxxxx@gmail.com

Rxxxx@gmail.com

21.     T1(table)

ID	Name
1	A
2	B
3	C
4	D

T2(table)

ID	Name
1	A
2	B
3	C

          I have 2 tables. But I want to show the output only 4  D row? How to do that in SSIS?

22.     How to truncate a table in dataflowtask ? (without using sql task?)