Mirra HealthCare Interview Questions, Process, and Tips

Q1. What is distributed architecture and disconnected architecture?
Ans. 
Distributed architecture is a system where components are spread across multiple computers. Disconnected architecture is a system where components can operate independently without a constant connection.
• Distributed architecture involves multiple computers working together to achieve a common goal.

• Disconnected architecture allows components to operate independently without a constant connection to a central system.

• Distr...read more
Answered by AI
Add your answer
Q2. What is stateless and state management?
Ans. 
Stateless refers to a system that does not store any data or information about previous interactions. State management is the process of managing and maintaining the state of a system.
• Stateless systems do not rely on previous interactions or data to function

• State management involves keeping track of the current state of a system

• State can be managed through various techniques such as cookies, sessions, and local storage

• ...read more
Answered by AI
Add your answer
Q3. What are sessions? What is Caching?
Ans. 
Sessions are a way to maintain state between HTTP requests. Caching is a technique to store frequently accessed data in memory.
• Sessions are used to store user-specific data across multiple requests

• Caching is used to improve performance by storing frequently accessed data in memory

• Sessions can be implemented using cookies or server-side storage

• Caching can be implemented using in-memory caches or distributed caches like ...read more
Answered by AI
Add your answer
Q4. What is disadvantage of using indexes?
Ans. 
Indexes can slow down write operations and take up additional storage space.
• Indexes can slow down write operations because every time data is added, updated, or deleted, the index must also be updated.

• Indexes can take up additional storage space because they are essentially a copy of the data in the table, just sorted differently.

• Indexes can also become fragmented over time, which can lead to decreased performance.

• Inde...read more
Answered by AI
Add your answer
Q5. What is referencial integrity?
Ans. 
Referential integrity ensures that relationships between tables in a database remain consistent.
• It is a set of rules that ensures that the relationships between tables in a database are maintained correctly.

• It prevents orphaned records in a database by enforcing constraints on foreign keys.

• For example, if a record in one table has a foreign key that references a record in another table, referential integrity ensures th...read more
Answered by AI
Add your answer
Q6. What is difference between left join and left outer join?
Ans. 
Left join and left outer join are the same thing.
• Both return all records from the left table and matching records from the right table.

• The only difference is in the case of no matching records in the right table.

• Left join returns null values for the right table columns while left outer join returns all columns with null values for non-matching records.
Answered by AI
Add your answer
Q7. What is observable and subscribe?
Ans. 
Observable and subscribe are two important concepts in reactive programming.
• Observable is a stream of data that emits values over time.

• Subscribe is a method that listens to the emitted values from an observable.

• Observable can be created from various sources like events, promises, arrays, etc.

• Subscribe can have three callbacks - next, error, and complete.

• Next callback is called when a new value is emitted, error callbac...read more
Answered by AI
Add your answer

Q1. Question based on resume
Add your answer
Q2. Scenario based question
Add your answer

Q1. Resume based question
Add your answer

Q1. Scenario based question
Add your answer
Q2. Resume based question
Add your answer

Q1. Resume based question
Add your answer

There was one GD round on PROS and CONS of a distributed system.

Q1. The discussions were mainly on the System Design and SQL Scenarios.
Add your answer