American Legalnet Interview Questions and Answers

Global exceptions in .Net can be handled using try-catch blocks and application-level exception handlers.

• Use try-catch blocks to handle exceptions at the method level

• Use application-level exception handlers to handle exceptions globally

• Use the Application_Error event in Global.asax to handle unhandled exceptions

• Log exceptions to a file or database for debugging purposes

• Display user-friendly error messages to the user

Static class cannot be instantiated and has only static members, while singleton class allows only one instance to be created and provides a global point of access to it.

• Static class cannot be inherited, while singleton class can be

• Static class members are accessed using class name, while singleton class instance is accessed using getInstance() method

• Static class is used for utility classes, while singleton class is us...read more

Repository Pattern is a design pattern that separates data access logic from business logic.

• It provides a way to access data from a data source without exposing the underlying database or data store.

• It helps in achieving separation of concerns and makes the code more modular and testable.

• It can be implemented using interfaces and classes to define a set of methods for data access.

• Examples include Entity Framework in .N...read more

Deadlocks can be solved by identifying and breaking the circular wait condition.

• Identify the processes involved in the deadlock

• Identify the resources each process is holding and waiting for

• Break the circular wait condition by releasing one or more resources

• Use deadlock detection tools to identify and resolve deadlocks

• Optimize the database design and queries to minimize the occurrence of deadlocks

Identify performance issues in a stored procedure with multiple select statements by analyzing execution plans and query performance.

• Check the execution plan for the slow query using tools like SQL Server Management Studio.

• Use SQL Server Profiler or Extended Events to monitor query performance and identify bottlenecks.

• Analyze indexes on the tables involved in the slow query; missing or fragmented indexes can slow down ...read more

Magic tables are temporary tables created by SQL Server to hold inserted, deleted or updated data during a trigger execution.

• Magic tables are used in SQL Server triggers to access the data that caused the trigger to fire.

• They are created automatically by SQL Server and contain the inserted, deleted or updated data.

• They are named 'inserted' and 'deleted' and can be referenced in the trigger code.

• Magic tables are useful ...read more

Temp tables are temporary tables created in memory or disk for storing data temporarily.

• Temp tables are used to store intermediate results during complex queries.

• They are created and destroyed automatically by the system.

• They can be used to improve query performance by reducing the number of disk I/O operations.

• They can also be used to simplify complex queries by breaking them down into smaller, more manageable parts.

• E...read more

Unit of work in .Net is a design pattern that helps manage transactions and database connections.

• Unit of work is used to group database operations into a single transaction.

• It helps to ensure data consistency and integrity.

• It also helps to reduce the number of database connections.

• Examples of frameworks that implement unit of work are Entity Framework and NHibernate.

CORS stands for Cross-Origin Resource Sharing and is a security feature implemented in web browsers.

• CORS allows web servers to specify which origins are allowed to access their resources

• It is used to prevent malicious websites from accessing sensitive data

• CORS is enforced by web browsers and not by servers

• It uses HTTP headers to communicate between the server and the browser

JIT compiles code at runtime while AOT compiles code during build time.

• JIT stands for Just-In-Time compilation and compiles code at runtime.

• AOT stands for Ahead-Of-Time compilation and compiles code during build time.

• JIT is used in development mode while AOT is used in production mode.

• JIT compiles templates and components on the fly while AOT compiles them before runtime.

• AOT generates smaller and faster code compared t...read more

Content negotiation is the process of selecting the best representation of a resource based on the client's request.

• It allows clients to specify the format they prefer for the response data.

• WebAPI uses the Accept header to determine the preferred format.

• It can be used to support multiple formats like JSON, XML, or plain text.

• It helps in building flexible and interoperable APIs.

Encapsulation is hiding the implementation details while Abstraction is hiding the complexity of the system.

• Encapsulation is achieved through access modifiers like private, protected, and public.

• Abstraction is achieved through abstract classes and interfaces.

• Encapsulation is used to protect the data from outside interference.

• Abstraction is used to provide a simplified view of the system.

• Encapsulation is a way to achiev...read more

An Identity Provider (IdP) is a service that authenticates users and provides identity information to other applications.

• IdP is responsible for verifying user identities and providing access tokens.

• It allows users to log in to multiple applications using a single set of credentials.

• Examples of IdPs include Google, Facebook, and Microsoft Azure Active Directory.

• IdP uses protocols such as SAML, OAuth, and OpenID Connect ...read more