Sparken IT Solutions DOT NET Developer Interview Questions and Answers

Q1. What are the types and number of constraints in your specific context?
Ans. 
There are various types of constraints in DOT NET development, including primary key, foreign key, unique, check, and default constraints.
• Primary key constraints ensure each record in a table is unique.

• Foreign key constraints enforce referential integrity between tables.

• Unique constraints ensure that all values in a column are distinct.

• Check constraints validate the data before it is inserted or updated.

• Default constra...read more
Answered by AI
Add your answer
Q2. What is the difference between an independent class and an abstract class?
Ans. 
Independent class can be instantiated while abstract class cannot be instantiated directly.
• Independent class can be directly instantiated using the 'new' keyword.

• Abstract class cannot be instantiated directly, it can only be used as a base class for other classes.

• Independent class does not require any derived class to implement its members.

• Abstract class can have abstract methods that must be implemented by derived cla
Answered by AI
Add your answer

Q1. Technical coding with the technical team
Add your answer

Q1. What are your reasons for changing your job?
Ans. 
Seeking new challenges, growth opportunities, and a better work-life balance.
• Looking for new challenges and opportunities to learn and grow.

• Seeking a better work-life balance.

• Interested in working with new technologies or in a different industry.

• Wanting to advance my career and take on more responsibilities.

• Company restructuring or changes in management.
Answered by AI
Add your answer

Q1. What is the repository design pattern?
Ans. 
Repository design pattern is a design pattern that separates the data access logic from the business logic in an application.
• It helps in achieving separation of concerns by isolating the data access code in a separate layer.

• It provides a centralized way to access data from various sources such as databases, web services, etc.

• It makes the codebase more maintainable and testable by abstracting the data access logic.

• Examp...read more
Answered by AI
Add your answer
Q2. What is the difference between IEnumerable and IQueryable?
Ans. 
IEnumerable is used for in-memory collection operations, while IQueryable is used for database query operations.
• IEnumerable is used for querying data from in-memory collections like arrays, lists, etc.

• IQueryable is used for querying data from a database using LINQ to SQL or Entity Framework.

• IEnumerable executes the query in-memory, while IQueryable executes the query on the database server.

• IEnumerable is suitable for L...read more
Answered by AI
Add your answer

Q1. How to call abstract constructor
Add your answer
Q2. Difference between generic list and list which is faster
Add your answer

Write prime number code

Q1. Difference between web.config and Machine.config
Ans. 
web.config is specific to a web application and overrides settings in Machine.config
• web.config is specific to a web application, while Machine.config is at the machine level

• web.config can override settings in Machine.config for a specific application

• Machine.config is located in the .NET framework folder, while web.config is in the application folder
Answered by AI
Add your answer
Q2. Explain about state management
Ans. 
State management in .NET refers to the process of storing and retrieving data during the lifecycle of an application.
• State management can be achieved using various techniques such as session state, view state, cookies, and query strings.

• Session state allows storing user-specific data across multiple pages during a user session.

• View state stores the state of the page and its controls between postbacks.

• Cookies can be use...read more
Answered by AI
Add your answer

Q1. Code excution of .net application?
Ans. 
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
Answered by AI
Add your answer
Q2. Stored procedure vs function?
Ans. 
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 with...read more
Answered by AI
Add your answer
Q3. What is CLR, Why its used?
Ans. 
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 can be...read more
Answered by AI
Add your answer
Q4. What is GC, where you have used in the app?
Ans. 
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.
Answered by AI
Add your answer

Q1. General questions on ASP.NET, Projects
Add your answer
Q2. Questions from my resume and current project
Add your answer

Q1. SOLID principles
Add your answer
Q2. Global and local temp tables
Add your answer
Q3. SQL QUERIES AND PALINDROME CODE
Add your answer

Q1. Interviewer was rude
Add your answer
Q2. Oops c# basics sql azure
Add your answer

Q1. What is work of team lead? how do you handle workload of yours and the junior assigned to you? how do u handle conflicts?
Ans. 
Team lead is responsible for managing the workload of the team, including assigning tasks, providing guidance, and resolving conflicts.
• Assign tasks to team members based on their skills and workload capacity

• Provide guidance and support to junior team members to help them complete their tasks successfully

• Monitor progress of tasks and ensure deadlines are met

• Resolve conflicts within the team by listening to all parties i...read more
Answered by AI
Add your answer
Q2. Other deep technical questions
Add your answer