Accenture DOT NET Developer Interview Questions and Answers

Stored procedures are precompiled SQL queries that can perform multiple operations, while functions are reusable code blocks that return a single value.

• Stored procedures can execute multiple SQL statements and can perform complex operations.

• Functions are reusable code blocks that return a single value and can be used in SQL queries.

• Stored procedures can be called independently, while functions are typically called...read more

GC stands for Garbage Collection, a process in .NET to automatically manage memory by reclaiming unused objects.

• GC is a feature in .NET that automatically manages memory by reclaiming unused objects.

• It helps in preventing memory leaks and improving application performance.

• GC can be used in .NET applications to free up memory occupied by objects that are no longer needed.

The .NET application code is compiled into Intermediate Language (IL) which is then executed by the Common Language Runtime (CLR).

• Code is compiled into Intermediate Language (IL) by the compiler

• IL is then converted into machine code by the Just-In-Time (JIT) compiler

• The CLR manages memory, security, and other system resources during code execution

A self join in SQL allows a table to be joined with itself to compare rows within the same table.

• Self joins are useful for hierarchical data, like employee-manager relationships.

• Example: To find employees and their managers, you can join the Employees table on itself.

• SQL syntax: SELECT a.EmployeeID, a.Name, b.Name AS ManagerName FROM Employees a JOIN Employees b ON a.ManagerID = b.EmployeeID;

• Self joins can be used...read more

CLR stands for Common Language Runtime, it is used to manage the execution of .NET programs.

• CLR is a part of the .NET framework responsible for managing the execution of .NET programs.

• It provides services such as memory management, exception handling, and security.

• CLR converts the Intermediate Language (IL) code into machine code during runtime.

• It allows for language interoperability, meaning different languages c...read more

Object-oriented programming (OOP) is a programming paradigm that uses objects to represent and manipulate data.

• OOP focuses on creating reusable code by organizing data and behavior into objects.

• It emphasizes concepts like encapsulation, inheritance, and polymorphism.

• Objects have attributes (data) and methods (functions) that can interact with each other.

• Example: In C#, classes are used to define objects and their ...read more