MRI Software Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
I am a Python Developer with 5 years of experience in web development and data analysis.
• 5 years of experience in Python development

• Skilled in web development and data analysis

• Proficient in using frameworks like Django and Flask
Answered by AI
Add your answer
Q2. What is ORM and which orm you used
Ans. 
ORM stands for Object-Relational Mapping, a technique to map objects from an application to tables in a relational database.
• ORM helps developers interact with databases using objects instead of SQL queries

• Popular ORMs include SQLAlchemy for Python, Django ORM for Django framework

• ORMs provide features like data validation, relationship management, and query optimization
Answered by AI
Add your answer

Q1. The interview was on sql first they took hacker rank test on dsa and in second round they called for f2f interview
Add your answer
Q2. They told to write two sql query
Ans. 
Two SQL queries can be written to retrieve and manipulate data from a database effectively.
• Query 1: SELECT * FROM employees WHERE department = 'Sales'; - Retrieves all employees in the Sales department.

• Query 2: UPDATE products SET price = price * 1.1 WHERE category = 'Electronics'; - Increases the price of all electronic products by 10%.
Answered by AI
Add your answer

Q1. Basic question on SQL
Add your answer
Q2. Aggregate function in SQL
Ans. 
Aggregate functions in SQL are used to perform calculations on a set of values and return a single value.
• Aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

• They are often used with the GROUP BY clause to group the results based on certain criteria.

• Examples: SELECT SUM(sales) FROM orders; SELECT AVG(age) FROM employees GROUP BY department;

• Aggregate functions ignore NULL values unless specified.
Answered by AI
Add your answer

Tell me about yourself

Q1. What is static method
Ans. 
A static method is a method that belongs to the class itself, rather than to instances of the class.
• Static methods can be called without creating an instance of the class.

• They are commonly used for utility functions that do not require access to instance variables.

• Static methods are declared using the 'static' keyword in the method signature.

• Example: Math.max() is a static method in the Math class that returns the maxi...read more
Answered by AI
Add your answer

Q1. It was 1 hr technical round for iOS Developer role. Questions related to project I am working, iOS Development questions like (process of publishing app, push notifications and its uses, Delegates how to u...read more
Add your answer

Q1. It was 30 min managerial round with one of the technical manager of MRI. Asked technical questions based on my projects. And then tricky questions like why you want to join, why we should hire you, where d...read more
Add your answer

Q1. Anything ! From conditions, Options, Basic questions like Tenant pro rata share and proportionate share
Add your answer
Q2. CAM charges ?
Ans. 
CAM charges, or Common Area Maintenance charges, cover shared expenses in commercial properties, ensuring maintenance and operational efficiency.
• CAM charges typically include expenses for landscaping, snow removal, and janitorial services.

• Utilities like water, electricity, and gas for common areas are often included in CAM charges.

• Insurance costs for the property, including liability and property insurance, are part of...read more
Answered by AI
Add your answer
Q3. Type of leases
Ans. 
Leases can be classified into various types, each serving different purposes and having unique characteristics.
• Operating Lease: A lease where the lessee uses an asset without owning it, typically for a shorter term. Example: Equipment leasing.

• Finance Lease: A long-term lease where the lessee has the option to purchase the asset at the end of the lease term. Example: Vehicle leasing.

• Capital Lease: Similar to a finance l...read more
Answered by AI
Add your answer