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

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.

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

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

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

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