fifthnote - An Ensemble Health Partners Company Software Engineer Interview Questions and Answers

Apptitude test is so easy it consists of English, technical mcqs

Q1. SQL rank function
Add your answer
Q2. Difference between count, count(*)
Ans. 
count(*) counts all rows in a table, while count(column_name) counts non-null values in a specific column.
• count(*) counts all rows in a table

• count(column_name) counts non-null values in a specific column

• count(*) is generally used to get the total number of rows in a table

• count(column_name) is used to count non-null values in a specific column
Answered by AI
Add your answer

Q1. OOPS concepts, function overload, override,interface,string, string builder
Add your answer

Q1. Company profile,salary discussion
Add your answer

Q1. OOps, C#, MVC, WEBAPI, Azure
Add your answer
Q2. Multiple inheritance concept in OOPs?
Ans. 
Multiple inheritance allows a class to inherit attributes and methods from more than one parent class.
• In multiple inheritance, a class can inherit from two or more parent classes.

• It can lead to the Diamond Problem where a class inherits from two classes that have a common ancestor.

• Languages like C++ support multiple inheritance.

• Example: class ChildClass : public ParentClass1, public ParentClass2 {}
Answered by AI
Add your answer
Q3. What is interface?
Ans. 
An interface in software development defines a contract for classes to implement, specifying methods and properties that must be included.
• Interfaces in programming languages like Java, C#, and TypeScript allow for multiple inheritance by defining a set of methods that a class must implement.

• Interfaces are used to enforce a common structure across different classes, promoting code reusability and maintainability.

• Example...read more
Answered by AI
Add your answer

Create Crud operation using angular with API.

Two coding questions, one is easy and the other is difficult. Who solved 2nd question was shortlisted for an interview.

Q1. Introduce yourself—questions from OS, DBMS, DSA, Project, and one coding problem.
Add your answer

Q1. Basic concept of c#,.net framework
Add your answer
Q2. What is CFA and DFA in entity framework core
Ans. 
CFA and DFA are Change-Tracking and Database-First Approaches in Entity Framework Core.
• CFA (Change-Tracking Approach) is used to track changes made to entities in memory and then save them to the database.

• DFA (Database-First Approach) is used to generate entity classes and DbContext from an existing database schema.

• CFA is useful when working with disconnected entities, while DFA is useful when working with an existing ...read more
Answered by AI
Add your answer

Q1. Basic questions
Add your answer