Centific Senior Software Developer Interview Questions and Answers for Experienced

MVC stands for Model-View-Controller, a software design pattern that separates the application into three main components.

• Model: Represents the data and business logic of the application.

• View: Represents the UI components of the application.

• Controller: Acts as an intermediary between Model and View, handling user input and updating the Model accordingly.

• MVC helps in organizing code, improving maintainability, and promo...read more

Index fragmentation in SQL occurs when the logical order of pages in an index does not match the physical order in the data file.

• Index fragmentation can lead to decreased query performance as the database engine has to scan more pages to retrieve data.

• Fragmentation can be caused by frequent insertions, deletions, or updates on the indexed columns.

• Rebuilding or reorganizing indexes can help reduce fragmentation and impr...read more

Hash map is a data structure that stores key-value pairs and uses a hash function to map keys to their corresponding values.

• Hash map uses a hash function to determine the index of the key-value pair in the underlying array.

• Collisions can occur when multiple keys hash to the same index, which can be resolved using techniques like chaining or open addressing.

• Hash maps have O(1) average time complexity for insertion, dele

Entity Framework is an ORM (Object-Relational Mapping) framework for .NET applications.

• ORM framework for .NET applications

• Maps database tables to classes in code

• Provides a way to query and manipulate data using LINQ

• Supports various database providers such as SQL Server, MySQL, etc.

CTE stands for Common Table Expression in SQL, used to create temporary result sets that can be referenced within a query.

• CTEs are defined using the WITH keyword

• They can be recursive or non-recursive

• CTEs improve readability and maintainability of complex queries

• Example: WITH cte AS (SELECT * FROM table_name) SELECT * FROM cte

SOLID principles are a set of five design principles for writing maintainable and scalable object-oriented code.

• Single Responsibility Principle (SRP) - a class should have only one reason to change

• Open/Closed Principle (OCP) - classes should be open for extension but closed for modification

• Liskov Substitution Principle (LSP) - objects of a superclass should be replaceable with objects of its subclasses without affectin...read more

Design patterns are reusable solutions to common problems in software design.

• Design patterns provide a template for solving recurring design problems in software development.

• They help in making code more maintainable, scalable, and efficient.

• Examples include Singleton, Factory, Observer, and Strategy patterns.