Add office photos
Employer?
Claim Account for FREE

ANAROCK Property Consultants

3.7
based on 459 Reviews
Video summary
Filter interviews by

20+ Elgebra Interview Questions and Answers

Updated 7 Jan 2025

Q1. What do you mean by MTD ? How to create it

Ans.

MTD stands for Month-to-Date. It refers to the period from the beginning of the current month up to the present date.

  • MTD is a common term used in financial and business reporting to track performance within a specific month.

  • To create MTD, you would sum up the data from the beginning of the month up to the current date.

  • For example, if you are calculating MTD sales for January 2022 on January 15th, you would sum up all sales data from January 1st to January 15th.

  • MTD is often us...read more

Add your answer

Q2. What is Data Modelling? Types of Data Models

Ans.

Data modeling is the process of creating a visual representation of data structures and relationships.

  • Data modeling involves defining the structure of data, its storage, and how it will be accessed and manipulated.

  • Types of data models include conceptual, logical, and physical models.

  • Conceptual models focus on high-level business concepts and relationships.

  • Logical models define the structure of the data without considering how it will be implemented in a database system.

  • Physic...read more

Add your answer

Q3. Write query to find department wise highest salary in an organisation.

Ans.

Query to find department wise highest salary in an organisation

  • Use GROUP BY clause to group data by department

  • Use MAX() function to find highest salary in each department

  • Join the tables if necessary to get department information

Add your answer

Q4. What are joins? Types of joins.

Ans.

Joins are used to combine rows from two or more tables based on a related column between them.

  • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

  • INNER JOIN returns rows when there is at least one match in both tables.

  • LEFT JOIN returns all rows from the left table and the matched rows from the right table.

  • RIGHT JOIN returns all rows from the right table and the matched rows from the left table.

  • FULL JOIN returns rows when there is a match in one of the tabl...read more

Add your answer
Discover Elgebra interview dos and don'ts from real experiences

Q5. Diffrence between Calculated column and Measure?

Ans.

Calculated columns are static values calculated at the row level, while measures are dynamic values calculated at the aggregated level.

  • Calculated columns are computed for each row in a table, while measures are computed for the entire dataset or a subset of data.

  • Calculated columns are stored in the data model, while measures are calculated on the fly based on user interactions.

  • Examples of calculated columns include age calculated from birthdate, while examples of measures inc...read more

Add your answer

Q6. What are the most important aspects of sales

Ans.

The most important aspects of sales include building relationships, understanding customer needs, effective communication, and closing deals.

  • Building relationships with customers to gain trust and loyalty

  • Understanding customer needs and providing solutions that meet those needs

  • Effective communication to convey the value of products or services

  • Closing deals by overcoming objections and negotiating terms

View 1 answer
Are these interview questions helpful?

Q7. RLS in power bi

Ans.

RLS in Power BI stands for Row-Level Security, a feature that restricts data access based on user roles.

  • RLS allows you to control access to data at the row level based on user roles

  • You can define filters in Power BI to restrict data based on user roles

  • RLS is commonly used to ensure that users only see data relevant to their role or department

Add your answer

Q8. Have yu handled the activity requirement for societies.

Ans.

Yes, I have experience in handling activity requirements for societies.

  • I have organized various events and activities for societies in the past.

  • I am familiar with the process of obtaining necessary permits and permissions.

  • I have a network of vendors and suppliers to ensure smooth execution of events.

  • I am able to work within budget constraints and deliver high-quality events.

  • For example, I organized a cultural festival for a residential society which included performances, foo...read more

Add your answer
Share interview questions and help millions of jobseekers 🌟

Q9. Market Estimation of Real Estate Commercial and Residential Real Estate difference

Ans.

Market estimation of real estate and differences between commercial and residential real estate.

  • Market estimation involves analyzing the current and future demand and supply of real estate in a particular area.

  • Commercial real estate is used for business purposes, while residential real estate is used for living purposes.

  • Commercial real estate tends to have higher rental rates and longer lease terms than residential real estate.

  • Residential real estate is typically more affecte...read more

Add your answer

Q10. What is MVC and architecture of CI

Ans.

MVC is a software design pattern that separates an application into three main components: Model, View, and Controller. CI follows the MVC architecture.

  • Model represents the data and business logic of the application.

  • View is responsible for displaying the data to the user.

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

  • CodeIgniter (CI) is a PHP framework that follows the MVC architecture.

  • CI's controllers handle ...read more

View 1 answer

Q11. Which all A cat builders are present in banglore

Ans.

Some A cat builders present in Bangalore are ABC Builders, XYZ Constructions, and LMN Developers.

  • ABC Builders

  • XYZ Constructions

  • LMN Developers

Add your answer

Q12. Tell the map line of thane city

Ans.

Thane city is located in the state of Maharashtra, India.

  • Thane is a city in the state of Maharashtra, India

  • It is located in the Thane district

  • Thane is part of the Mumbai Metropolitan Region (MMR)

  • It is known for its historical landmarks and cultural heritage

Add your answer

Q13. What do you know about the market trends in Mumbai

Add your answer

Q14. Any prior Real estate knowledge?

Ans.

Yes, I have prior real estate knowledge.

  • I have worked as a real estate agent for 5 years.

  • I have experience in property management and leasing.

  • I have also invested in real estate properties for personal gain.

Add your answer

Q15. Advanced MySQL query with example

Ans.

An advanced MySQL query involves using complex joins, subqueries, and functions to retrieve specific data.

  • Use JOIN to combine data from multiple tables

  • Utilize subqueries to retrieve data based on results from another query

  • Leverage functions like COUNT, SUM, AVG for calculations

  • Example: SELECT * FROM table1 JOIN table2 ON table1.id = table2.id WHERE table1.column = (SELECT column FROM table3 WHERE condition)

Add your answer

Q16. Why sales after Civil Engineering?

Add your answer

Q17. Depth of real estate

Ans.

Depth of real estate refers to the level of detail and complexity involved in real estate transactions and management.

  • Depth of real estate can refer to the intricacies of property laws and regulations that must be navigated in transactions.

  • It can also refer to the level of analysis and research required to make informed decisions about real estate investments.

  • Understanding market trends, property values, and financial implications are all part of the depth of real estate.

  • For ...read more

Add your answer

Q18. Sales experience

Ans.

I have over 5 years of sales experience in various industries, consistently exceeding targets and building strong client relationships.

  • Managed a portfolio of clients and consistently met or exceeded sales targets

  • Developed and implemented sales strategies to increase revenue

  • Built strong relationships with clients to ensure repeat business

  • Utilized CRM systems to track sales progress and client interactions

Add your answer

Q19. Why real estate?

Ans.

Real estate offers opportunities for growth, financial stability, and the chance to help people find their dream homes.

  • Real estate provides the potential for financial growth through property appreciation and rental income

  • It allows for the opportunity to help individuals and families find their ideal homes or investment properties

  • The industry offers a diverse range of career paths, from sales and marketing to property management and development

View 1 answer

Q20. Name five developers

Ans.

Some well-known developers in the industry

  • John Carmack - known for his work on games like Doom and Quake

  • Tim Sweeney - founder of Epic Games, creator of Unreal Engine

  • Shigeru Miyamoto - creator of iconic games like Mario and Zelda

  • Hideo Kojima - known for the Metal Gear Solid series

  • Gabe Newell - co-founder of Valve Corporation, creator of Steam

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Elgebra

based on 53 interviews
Interview experience
3.8
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

3.8
 • 3k Interview Questions
4.0
 • 867 Interview Questions
3.9
 • 396 Interview Questions
4.0
 • 248 Interview Questions
3.6
 • 184 Interview Questions
3.9
 • 138 Interview Questions
View all
Top ANAROCK Property Consultants Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter