OOPS, difference between abstract class and interface, difference between response.Redirect and server.Transfer, sql transaction, procedure, functions, connected and disconnected architecture

Question

Accepted Answer

Questions on OOPS concepts, SQL transactions, and web development

Abstract class vs interface: abstract class can have implementation while interface cannot
response.Redirect vs server.Transfer: Redirect sends a new request while Transfer does not
SQL transaction: a set of SQL statements executed as a single unit of work
SQL procedure: a set of SQL statements that can be called like a function
SQL function: a set of SQL statements that returns a value
Connected architecture: database connection is open throughout the application
Disconnected architecture: database connection is opened and closed as needed

OOPS, difference between abstract class and interface, difference between response.Redirect and server.Transfer, sql transaction, procedure, functions, connected and disconnected architecture

Popular interview questions of Senior Software Developer