BUSINESS DNA INDIA Interview Questions and Answers

Interface is a blueprint of a class that defines a set of methods without implementation. Used for achieving abstraction and multiple inheritance.

• Interfaces are used to define a contract that classes must implement, ensuring consistency and flexibility in code.

• Interfaces are commonly used in C# to achieve multiple inheritance, as a class can implement multiple interfaces but inherit from only one class.

• Pros of interfac...read more

SQL procedures are used to perform a set of actions, while functions return a value.

• Procedures can perform multiple actions, while functions return a single value

• Functions can be used in SQL statements like SELECT, WHERE, etc., while procedures cannot

• Functions can be called from within SQL statements, while procedures cannot

• Functions must return a value, while procedures do not necessarily have to

SQL injection is a type of cyber attack where malicious SQL code is inserted into input fields to manipulate database queries.

• SQL injection occurs when a user input is not properly sanitized and allows attackers to execute malicious SQL statements.

• Attackers can use SQL injection to access, modify, or delete data from a database.

• Preventing SQL injection involves using parameterized queries, input validation, and escapin...read more

Stored procedures are precompiled SQL queries stored in the database for reuse and improved performance.

• Stored procedures can improve performance by reducing network traffic and optimizing query execution.

• They can be used to encapsulate complex business logic in the database.

• Stored procedures can enhance security by controlling access to data through parameterized queries.

• They promote code reusability and maintainabili...read more

Memory management in .NET involves automatic memory allocation and garbage collection.

• Automatic memory allocation is done using the managed heap in .NET.

• Garbage collection is responsible for reclaiming memory that is no longer in use.

• Developers can also manually manage memory using techniques like IDisposable and using statements.