Satyam Dotnet Interview Questions

Hi Friends , One of my Friend Attend the Dotnet Interview With Satyam

1. What is your qualification?

2. How many years of experience you have? In vb.net?

3. Tell about the recent project? What is your role in that module?

4. Which architecture implemented in this project?

5. Explain about the three tier architecture?

6. How the data will be passed to business layer?

7. What is the inheritance? *How to give quick fixes when there is a change involved in 100 web pages developed?

8. *What is the difference between abstract class and interface?

9. When will we use keyword shadows?

10. What are the access specifiers?

11. What is the scope of Shared?

12. *What is the difference between finalize and dispose?

13. What is the use of SCOPE_IDENTITY()? Difference between Ident_current() and SCOPE_IDENTITY()?

14. Write a query to fetch third maximum salary from emp table?

15. What is COALESCE()? Write a query to fetch data in a column values as a string separated by commas(x,y,z) ?

16. What is instead of trigger? How many instead of triggers can be defined on a table? If there are more than one trigger with same event (insert,update or delete exists) Which trigger will fire first?

17. How to use table output of one stored procedure in another stored procedure?

18. How to improve the performance in sql server?

19. How many types of indexes exists? What is the difference between clustered and non clustered index?

20. Up to which normalization, you have implemented in the tables used for the recent project?

21. What is demoralization?

22. What is the design part you have done in your module?

23. Is VB supports object oriented? *What is the difference between object based and object oriented?

24. What is the visual studio version currently using? And frame version?

25. Explain about dot net framework?

26. Explain about CLR?

27. What is managed code?

28. What is an assembly? *How many types of assemblies are there?

29. Explain the use of windows services?

30. What is polymorphism?