10+ TIL Interview Questions and Answers

The last person surviving will be the 73rd person.

• The pattern of shooting skips every second person.

• After each round of shooting, the number of people remaining is halved.

• The last person standing will be the one who is skipped in every round of shooting.

The last ball will be red.

• If the first two balls are of different colors, they will be replaced with a red ball.

• If the first two balls are of the same color, they will be replaced with a blue ball.

• The number of balls in the container does not affect the outcome.

• The last ball will be red because there are more red balls than blue balls in the container.

The 100th person will be alive.

• The pattern shows that every even numbered person is killed and every odd numbered person receives the sword.

• The sword eventually comes back to the 1st person who started the cycle.

• Therefore, the 100th person will be killed by the 99th person and the sword will go back to the 1st person.

• Hence, the 1st person will be the only one left alive.

Reverse a given number while excluding trailing zeros.

• Iterate through the digits of the number from right to left.

• Skip any trailing zeros while reversing the number.

• Store the reversed number and return it as the output.

Return all prime numbers less than or equal to a given positive integer N.

• Create a function that takes an integer N as input

• Iterate from 2 to N and check if each number is prime

• Return a list of prime numbers less than or equal to N in ascending order

Find the heavier ball out of 8 using a weighing balance in minimum and maximum attempts.

• Divide the balls into 3 groups of 3, 3, and 2.

• Weigh the first two groups against each other.

• If they balance, the heavier ball is in the third group.

• If one group is heavier, weigh two balls from that group against each other.

• If they balance, the heavier ball is the remaining one.

• If one ball is heavier, that is the answer.

• In the worst case, it takes 3 attempts to find the heavier ball.

In 3 attempts, the heavier ball can be found using the weighing balance.

• Divide the balls into 3 groups of 3, 3, and 5 balls.

• Weigh the first two groups against each other.

• If they balance, the heavier ball is in the third group. Weigh two balls from the third group against each other to find the heavier one.

• If they don't balance, the heavier ball is in the heavier group. Take two balls from the heavier group and weigh them against each other to find the heavier one.

Bubble Sort algorithm is used to sort an array of non-negative integers in non-decreasing order.

• Bubble Sort compares adjacent elements and swaps them if they are in the wrong order.

• Repeat this process until the array is sorted.

• Time complexity of Bubble Sort is O(n^2) in worst case.

• Example: For input 6 2 8 4 10, output will be 2 4 6 8 10.

Use a binary search approach to find the heavier ball among 'n' balls using a weighing balance.

• Divide the 'n' balls into two equal groups and weigh them on the balance.

• If one group is heavier, repeat the process with that group.

• If both groups weigh the same, the heavier ball is among the remaining unweighed balls.

• Continue dividing and weighing until the heavier ball is found.

The number of soft drinks sold in J&K on a particular day depends on various factors such as population, demand, availability, and marketing strategies.

• The population of J&K can be a factor in determining the potential number of soft drink sales.

• The demand for soft drinks can vary based on factors such as weather, events, and cultural preferences.

• The availability of soft drinks in J&K, including distribution channels and retail outlets, can impact sales.

• Marketing strategies, ...read more

VLOOKUP is a function in Excel used to search for a value in the first column of a range and return a corresponding value from another column.

• VLOOKUP stands for vertical lookup.

• It is commonly used to find specific data in large datasets.

• The function takes four arguments: lookup value, table array, column index number, and range lookup.

• VLOOKUP is case-insensitive and requires an exact match or an approximate match.

• The function returns the value from the corresponding row in th...read more

The exact number of Facebook users worldwide is constantly changing, but as of October 2021, there are over 2.8 billion monthly active users.

• As of October 2021, Facebook reported having over 2.8 billion monthly active users.

• The number of Facebook users is constantly changing as new users join and others deactivate or delete their accounts.

• Facebook's user base is spread across different countries and demographics.

• The number of Facebook users can be influenced by factors such a...read more

Approximately 50,000 tractors are sold in Haryana every year.

• Consider the population of Haryana and the number of farmers in the state.

• Look at the agricultural output of Haryana and the demand for tractors in the region.

• Take into account the number of tractor dealerships in Haryana and their sales figures.

• Research the sales figures of major tractor manufacturers in Haryana.

• Assume a growth rate based on the previous year's sales figures.

• Consider any government policies or subs...read more

Estimating the market size of 4K and 8K display screens.

• Analyze sales data and market research reports

• Consider the adoption rate of 4K and 8K technology

• Evaluate the market demand from various industries (entertainment, gaming, advertising, etc.)

• Assess the pricing and availability of 4K and 8K displays

• Factor in the growth potential and competition in the market

Output and error checking of SQL queries involves verifying the correctness of query results and handling any potential errors.

• Verify the correctness of query results by comparing them with expected output

• Check for syntax errors and correct them before executing the query

• Handle runtime errors by using try-catch blocks or error handling mechanisms

• Validate input parameters to prevent SQL injection attacks

• Use appropriate error logging and reporting mechanisms to track and resolv...read more

Estimating the percentage of smokers in an institute.

• Collect data on the number of smokers and the total population in the institute.

• Calculate the ratio of smokers to the total population.

• Multiply the ratio by 100 to get the percentage of smokers.

• Consider conducting surveys or analyzing existing data to gather information.

• Take into account any potential biases or limitations in the data collection process.

UHG; Analytics offers a unique opportunity to combine my passion for data analysis with the healthcare industry.

• UHG is a leading healthcare organization with a strong focus on analytics.

• Working at UHG will allow me to contribute to improving healthcare outcomes through data-driven insights.

• The company's commitment to innovation and cutting-edge technology aligns with my career goals.

• UHG's vast data resources provide an excellent platform for conducting meaningful analytics pr...read more