CogniTensor Technology Software Developer Interview Questions and Answers for Experienced

Managed code is code that is executed by the Common Language Runtime (CLR) while unmanaged code is code that is executed directly by the operating system.

• Managed code is written in high-level languages like C#, VB.NET, and is compiled to Intermediate Language (IL) which is executed by the CLR.

• Unmanaged code is written in languages like C, C++, and is compiled directly to machine code which is executed by the operating ...read more

Access modifiers in programming define the scope of a class, method, or variable.

• Public - accessible from any other class

• Private - accessible only within the same class

• Protected - accessible within the same package and subclasses

• Default (no modifier) - accessible only within the same package

Array is a fixed-size data structure while ArrayList is a dynamic-size data structure in Java.

• Array is a fixed-size collection of elements of the same data type.

• ArrayList is a resizable collection that can grow or shrink in size dynamically.

• Arrays can store primitive data types and objects, while ArrayList can only store objects.

• Arrays use square brackets [] for declaration, while ArrayList is a class in Java's collect...read more

String is immutable, while StringBuilder is mutable and more efficient for concatenating strings.

• String is immutable, meaning once created, it cannot be changed. StringBuilder is mutable and allows for modifications.

• String concatenation in a loop using String can be inefficient due to creating new objects each time. StringBuilder is more efficient for this purpose.

• String has a fixed length, while StringBuilder can dyna...read more

Strings are immutable in order to ensure data integrity and security.

• Immutable strings prevent accidental changes to data

• Enhances security by preventing data tampering

• Allows for efficient memory management

Connection pooling is a technique used to manage a pool of database connections to improve performance and efficiency.

• Connection pooling helps reduce the overhead of opening and closing database connections for each request

• It allows multiple clients to reuse a pre-created set of connections to the database

• Connection pooling can help improve the scalability and performance of applications that require frequent database

Action controller is for web applications, API action controller is for APIs

• Action controller is used for handling web requests in a traditional web application

• API action controller is used for handling API requests in a RESTful API

• API action controller typically returns JSON responses, while action controller may return HTML responses

• API action controller often has different authentication and authorization mechanisms

Design patterns in SQL are reusable solutions to common problems encountered in database design and development.

• Singleton Pattern: Ensures a class has only one instance and provides a global point of access to it.

• Factory Pattern: Creates objects without specifying the exact class of object that will be created.

• Repository Pattern: Separates the logic that retrieves data from a data source from the business logic that ac...read more

CommandBuilder is a class used to dynamically create SQL commands, while Command is a pre-defined SQL command.

• CommandBuilder is used to construct SQL commands at runtime based on user input or conditions.

• Command is a pre-defined SQL command that is executed as is.

• CommandBuilder is more flexible and allows for dynamic SQL generation.

• Command is static and does not change during runtime.

• Example: CommandBuilder can be used...read more