Sharing Couple of T SQL Questions frequently asked in Capgemini interviews:
1. What is the difference between SP and Functions?
2. Can we call SP from Function?
3. Can we write Functions in SP?
4. Given a scenario to define ER Model for the scenario like “A College is organizing a Band”.
5. Prepare the necessary Model with required attributes.
7. What is synonym & why we use synonym?
8. What is 'linked server' & use of 'linked server'?
9. Can we modify the table data after using the views for that table?
Tags: SQL Server Interview Questions and Answers At Capgemini, Capgemini, Interview Questions and Answers At Capgemini, SQL Server, SQL Server Interview Questions, SQL Server QA, SQL Server Interview Questions and Answers, SQL Server Tutorial, SQL Server books, SQL Server Interview Questions pdf, SQL Server experienced QA, interview questions, SQL Server interview questions for experienced, SQL Server interview questions for developers,SQL Server interview questions for freshers,SQL Server interview questions senior level, SQL Server Certification Questions, Basic SQL Server interview questions, SQL Server interview questions 2 3 4 5 6 years experienced, SQL Server Real time interview questions, SQL Server Interview Questions and Answers At Capgemini 2015, Latest SQL Server Questions At Capgemini Interview.
1. What is the difference between SP and Functions?
2. Can we call SP from Function?
3. Can we write Functions in SP?
4. Given a scenario to define ER Model for the scenario like “A College is organizing a Band”.
5. Prepare the necessary Model with required attributes.
7. What is synonym & why we use synonym?
8. What is 'linked server' & use of 'linked server'?
9. Can we modify the table data after using the views for that table?
10. Write a query to find the duplicate values & its count?
11. What is view & why we use views?
12. Write a query to find the all Employee names having 'ANZ SQL’?
13. How to create the dummy table?
14. After data loading, what will you test?
11. What is view & why we use views?
13. How to create the dummy table?
14. After data loading, what will you test?
15. What are transactions?