30+ GV Mantra Interview Questions and Answers

The number of advertisements running on the yellow line of Delhi metro is not available.

• The exact number of advertisements on the yellow line of Delhi metro is unknown.

• Without access to real-time data, it is impossible to determine the current number of advertisements.

• The number of advertisements can vary depending on the time and duration of the interview.

• It would require direct observation or access to Delhi metro's advertising records to provide an accurate answer.

Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.

• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.

• Having clause is used with GROUP BY statement to filter groups based on a condition.

• Where clause is applied before grouping, while having clause is applied after grouping.

• Example: SELECT * FROM table_name WHERE column_name = 'value';

• Example: SELECT column_name, COUNT(*) ...read more

It depends on various factors such as market demand, competition, pricing, marketing strategy, etc.

• Market research can provide an estimate of potential sales

• Competitive analysis can help in understanding the market share

• Pricing strategy can impact the sales volume

• Marketing efforts can influence the sales

• Sales forecast can be made based on historical data and trends

I enjoyed exploring new places, trying new cuisines, and spending time with friends and family.

• I loved traveling to different cities and countries

• I enjoyed trying out new restaurants and cuisines

• I spent time with my friends and family, either by going out or having them over

• I also enjoyed reading books and watching movies in my free time

Estimating the revenue of a museum in a day in a European city.

• Consider the average ticket price of the museum

• Estimate the number of visitors based on the museum's popularity and capacity

• Factor in additional revenue sources like gift shop sales or special exhibitions

• Take into account any discounts or promotions offered by the museum

• Research similar museums in the city to gather comparative data

The question is irrelevant and unanswerable.

• The first part is a mathematical calculation while the second part is a completely unrelated question.

• There is no way to estimate the number of Arsenal fans in India based on the given information.

• The question may have been asked to test the candidate's ability to handle unexpected or irrelevant questions.

The number of maternity clinics a new entrant should open in India depends on various factors such as population, demand, competition, and geographical distribution.

• Consider the population of women of childbearing age in different regions of India

• Analyze the existing maternity clinic facilities and their capacity in each region

• Assess the demand for maternity services in different areas based on birth rates and healthcare indicators

• Evaluate the competition from existing matern...read more

It is difficult to provide an accurate estimate without specific sales data, but we can make an educated guess based on market trends and previous sales figures.

• Consider the overall smartphone market share of Apple in India

• Look at historical sales data of iPhones in India

• Analyze the impact of new iPhone releases on sales numbers

• Take into account any promotional campaigns or discounts offered by Apple in India

Yes, the European telecom giant should enter India.

• India has a large and growing telecom market with a huge potential customer base.

• The Indian government has been implementing policies to attract foreign investment in the telecom sector.

• Entering India would provide the European telecom giant with an opportunity to expand its global presence and tap into a new market.

• The telecom industry in India has been experiencing significant growth, with increasing smartphone penetration ...read more

Startup Studios build and launch startups using their own resources and expertise.

• Startup Studios provide resources such as funding, office space, and mentorship to startups in exchange for equity.

• They typically have a team of experts in various fields such as marketing, product development, and finance to help startups succeed.

• Examples of successful startup studios include Betaworks, Science Inc., and Idealab.

• Startup Studios may also spin off successful startups as separate ...read more

The number of car tyres sold in a day can vary greatly depending on factors such as location, season, and economic conditions.

• Consider the population of the area - more populated areas may have higher car tyre sales

• Take into account the number of vehicles on the road

• Factor in the season - winter may see more tyre sales due to snow and ice

• Economic conditions can also impact sales - during a recession, sales may be lower

• Look at data from tyre manufacturers and retailers for mor...read more

Different types of ML models, how they work, differences among them, types of performance metrics, pros and cons.

• Types of ML models include linear regression, decision trees, support vector machines, neural networks, etc.

• ML models work by learning patterns from data to make predictions or decisions.

• Differences among models include complexity, interpretability, scalability, and performance.

• Performance metrics for ML models include accuracy, precision, recall, F1 score, ROC cur...read more

The number of fans sold in India annually varies depending on market demand and economic factors.

• Sales of fans in India are influenced by factors such as population growth, urbanization, and disposable income levels.

• Major fan manufacturers in India include companies like Orient Electric, Crompton Greaves, and Usha International.

• The demand for energy-efficient fans has been increasing in recent years due to rising awareness about sustainability.

• Government initiatives promoting...read more

Estimating the number of ACs sold in Shimla requires analyzing market trends, population demographics, and sales data from retailers.

• Research market trends and consumer preferences in Shimla

• Analyze population demographics to understand potential demand for ACs

• Collect sales data from retailers in Shimla to estimate the number of ACs sold

• Consider factors like climate, income levels, and competition in the AC market

• Use statistical methods like regression analysis to make an accu...read more

Crocin pills consumption for 2020 guesstimate

• Analyze past year's sales data

• Consider population growth and health trends

• Factor in any major health crises or events

• Consult with industry experts

• Consider marketing and advertising efforts

• Assess competition and market share

• Consider any changes in pricing or availability

The number of bicycles sold in Delhi is not available.

• Data on the number of bicycles sold in Delhi is not provided

• It would require access to sales data from bicycle retailers in Delhi

• Market research or government statistics may have this information

It is estimated that around 20% of cars in Delhi are red, so approximately 1 out of every 5 cars is red.

• Consider the total number of cars in Delhi

• Estimate the percentage of cars that are red

• Calculate the number of red cars based on the percentage

There are approximately 10 million cars in Delhi city.

• Delhi has a population of over 18 million people

• Car ownership is increasing rapidly in India

• Traffic congestion is a major issue in Delhi

• Government is promoting public transportation to reduce car usage

Z test is a statistical test used to determine if there is a significant difference between the means of two groups.

• Z test is used when the sample size is large and the population standard deviation is known.

• It compares the means of two groups by calculating the z-score and determining the probability of obtaining that result by chance.

• The z-score is calculated as the difference between the sample mean and the population mean divided by the standard error of the mean.

• For exam...read more

R squared measures the proportion of variance explained by the independent variables, while adjusted R squared adjusts for the number of predictors in the model.

• R squared is the proportion of variance in the dependent variable that is predictable from the independent variables.

• Adjusted R squared penalizes the addition of unnecessary predictors in the model, providing a more accurate measure of the model's goodness of fit.

• R squared can increase even with the addition of irrele...read more

Approximately 1 million Anu Malik music CDs were sold in 1995.

• Anu Malik was a popular music composer in the 90s

• CDs were the primary mode of music distribution in 1995

• Assuming Anu Malik's popularity, 1 million CDs sold seems reasonable

Foreign travelers contribute significantly to the Indian economy through spending on accommodation, transportation, shopping, dining, and attractions.

• Foreign travelers contribute to the Indian economy through spending on accommodation, transportation, shopping, dining, and attractions.

• Tourism sector accounts for a significant portion of India's GDP and job creation.

• Foreign exchange earnings from tourism play a crucial role in balancing India's trade deficit.

• Government policie...read more

The square of 35 is 1225.

• To find the square of a number, you multiply it by itself.

• 35 x 35 = 1225

• The square of a number is always positive.

Estimating the number of cricket bats in Delhi NCR involves considering factors like population, cricket popularity, and sports equipment stores.

• Consider the population of Delhi NCR and the popularity of cricket in the region.

• Look at the number of sports equipment stores in Delhi NCR that sell cricket bats.

• Factor in the frequency of cricket matches and players in the area.

• Estimate based on previous sales data or surveys conducted in the region.

The square root of 13 is approximately 3.60555.

• The square root of a number is the value that, when multiplied by itself, gives the original number.

• The square root of 13 can be estimated by finding the square roots of nearby perfect squares (e.g. 9 and 16) and interpolating.

• The exact value of the square root of 13 is an irrational number that goes on infinitely without repeating.

• The square root of 13 can be written as √13 or 13^(1/2).

The global coffee market size is estimated to be around $102.15 billion in 2020.

• The coffee industry includes coffee shops, cafes, and retail sales of coffee beans and grounds.

• The market size is influenced by factors such as consumer preferences, demographics, and economic conditions.

• The largest coffee consuming countries are the United States, Brazil, and Germany.

• The market is expected to grow at a CAGR of 4.2% from 2021 to 2028.

• The pandemic has affected the coffee market, wi...read more

Burning rope puzzle involves measuring time by burning ropes of different lengths.

• Start by lighting one end of a rope and timing how long it takes to burn completely.

• Use this information to determine how to measure a specific amount of time using multiple ropes.

• For example, if one rope takes 30 minutes to burn completely, you can use it to measure 15 minutes by burning only half of it.

Increase Starbucks sales in India case

• Conduct market research to understand local preferences and culture

• Develop a menu that caters to Indian tastes, such as adding more tea-based drinks

• Partner with local businesses and influencers to increase brand awareness

• Offer promotions and discounts to attract new customers

• Expand store locations to reach more customers in different regions

Estimating the number of ladders in a city based on population, number of households, and common usage scenarios.

• Consider the population of the city and the number of households as a starting point

• Factor in common usage scenarios where ladders are needed such as construction sites, maintenance work, and home improvement projects

• Look at the types of buildings in the city - residential, commercial, industrial - and estimate the need for ladders in each sector

The size of the mattresses market in Delhi can be estimated by considering the population, average household size, and consumer preferences.

• Consider the population of Delhi and the average household size to estimate the number of households in need of mattresses

• Research the average spending on mattresses per household in Delhi

• Take into account the various types of mattresses available in the market and their respective market shares

• Look at the growth trends in the furniture a...read more

Estimate the size of the market by making educated guesses based on available information

• Start by identifying the total population or target demographic

• Estimate the percentage of the population that would be interested in the product or service

• Consider factors such as market trends, competition, and potential growth opportunities

• Use industry reports, surveys, and data analysis to support your estimates

Earn money by working, investing, starting a business, or providing services.

• Work a job or freelance to earn a salary or hourly wage

• Invest in stocks, real estate, or other assets to generate passive income

• Start a business and sell products or services to make a profit

• Provide services such as tutoring, consulting, or freelancing for a fee

Orchestrator is a centralized platform for managing, monitoring, and controlling RPA processes.

• Centralized platform for managing RPA processes

• Allows scheduling and monitoring of bots

• Provides analytics and reporting capabilities

• Enables integration with other systems and applications

Uber data model design for efficient storage and retrieval of ride-related information.

• Create tables for users, drivers, rides, payments, and ratings

• Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.

• Establish relationships between tables using foreign keys

• Implement indexing for faster query performance

Angular lifecycle hooks are methods that allow you to tap into specific points in a component's lifecycle.

• ngOnChanges: called when an input property changes

• ngOnInit: called once the component is initialized

• ngDoCheck: called during every change detection run

• ngAfterContentInit: called after content (ng-content) has been projected into the component

• ngAfterContentChecked: called after every check of the projected content

• ngAfterViewInit: called after the component's view has been ...read more

OCR engine stands for Optical Character Recognition engine, which is a technology used to convert different types of documents, such as scanned paper documents, PDF files, or images captured by a digital camera, into editable and searchable data.

• OCR engine uses algorithms to recognize text within images or scanned documents.

• It can extract text from various sources like printed documents, handwriting, or even text within images.

• Popular OCR engines include Tesseract, Abbyy Fine...read more