Software Developer and Consultant Interview Questions and Answers

Explanation of interface, abstraction, encapsulation, joins, keep and peek.

• Interface is a blueprint of a class that defines the methods and properties that the class should implement.

• Abstraction is a concept of hiding the implementation details and showing only the necessary information to the user.

• Encapsulation is a mechanism of wrapping the data and code together in a single unit and restricting access to the data from outside the unit.

• Joins are used to combine rows from tw...read more

SP is used to execute a set of SQL statements, while a function returns a single value.

• SP can have input/output parameters, while functions only have input parameters.

• Functions can be used in SELECT statements, while SP cannot.

• Functions can be called from within SP, but SP cannot be called from within a function.

• SP can modify data in tables, while functions cannot.

• Examples of SP: sp_help, sp_rename, sp_addlogin.

• Examples of functions: COUNT, AVG, MAX, MIN.

Routings are paths that data or signals take through a system. Types include static, dynamic, and adaptive.

• Static routing uses a pre-determined path for data to travel

• Dynamic routing adjusts the path based on network conditions

• Adaptive routing combines static and dynamic routing to optimize performance

• Examples of routing protocols include OSPF, BGP, and RIP