Basic OOPS, SQL Server and ADO.NET Interview Questions

General:
  1. Tell abt me
  2. current project
OOPS
  1. what is abstract class?
  2.  what is interface?
  3.  what s access modifier?
  4.  Types of access modifier?
  5.   what is inheritance?
ADO.NET
  1. what is view state?
  2.  How will you pass data from one page to another page?
  3.   what is hiddenfield?
  4.  what is session?
  5.   where the viewstate values are stored?
  6.   Diff b/w response.redirect & Server.redirect?
  7.  How you register a control in our page?
  8.  what is dataset?
  9.  what is data reader?
  10.   what is the diff b/w them?
  11.   what is data grid?
  12.  what is repeater?
  13.  what is the diff b/w them?
  14.  How will u relate the data with dataset and datareader? - Using data relational.
  15.  what is clustered index and non-clustered index?
  16.  what is partial class?

SQL SERVER
  1. what is function?
  2.  what is view?
  3.   what is stored procedure?
  4.   What is the diff b/w function & stored procedure?
  5.  what is trigger?
  6.  What is joins? types of joins?
  7.  what is denormalization?
  8.   what is self join?

C# .NET
  1. what is AJAX?
  2.   what is CSS?
  3.  what is Master page?
  4.  what is web.config?
  5.  what is global.asax?
  6.   what is update panel?
 NET Interoperability

(I) How can we use COM Components in .NET?


(I) We have developed the COM wrapper do we have to still register the COM?

(A)How can we use .NET components in COM?

(A) How can we make Windows API calls in .NET?

(B) When we use windows API in .NET is it managed or unmanaged code?

(I)What is COM?

(A) What is Reference counting in COM?

(A) Can you describe IUKNOWN interface in short?

(I) Can you explain what DCOM is?

(B) How do we create DCOM object in VB6?

(A) How to implement DTC in .NET?

(A) How many types of Transactions are there in COM + .NET?

(A) How do you do object pooling in .NET?

(A) What are types of compatibility in VB6?

(A)What is equivalent for regsvr32 exe in .NET?
 
 
I will update more Interview Questions!!
Happy Learning!!! and Happy Coding!!!
No Pain!...No Gain!!