30+ Interview Questions and Answers

333 digits can number 166 pages of a book.

• Each page number takes up 2 digits.

• The first page is numbered 01.

• The last page that can be numbered is 166.

• The remaining 2 digits are used for the cover page or other information.

Weighing balance puzzle to find the lighter coin among 9 coins.

• Divide the coins into 3 groups of 3 coins each

• Weigh any two groups against each other

• If one group is lighter, weigh two coins from that group against each other

• If they are equal, the third coin is the lighter one

• If they are not equal, the lighter coin is the one that weighs less

• If both groups weigh the same, the lighter coin is in the third group

• Weigh two coins from the third group against each other to find the l...read more

ERP is a software that integrates various business processes and functions into a single system.

• ERP stands for Enterprise Resource Planning.

• It helps organizations streamline their operations and improve efficiency.

• Advantages of ERP include centralized data management, improved collaboration, and better decision-making.

• It automates processes like inventory management, financials, human resources, and customer relationship management.

• ERP provides real-time visibility into busin...read more

Guesstimate the total number of Wagon-R cars sold in India.

• Consider the total population of India and the percentage of car owners

• Look at the market share of Maruti Suzuki in India

• Consider the popularity of Wagon-R among small car buyers

• Check the sales figures of Wagon-R in the last few years

• Assume a growth rate based on the current market trends

Approximately 8000 balls can be placed with 49% wastage.

• Calculate the volume of the cube (10*10*10) and the volume of one ball (4/3*3.14*(0.5/2)^3)

• Divide the volume of the cube by the volume of one ball to get the maximum number of balls that can fit

• Calculate the volume of the placed balls and subtract it from the volume of the cube to get the wastage

• Wastage percentage can be calculated by dividing the wastage volume by the volume of the cube and multiplying by 100

To approach a customer for selling a costly new phone, I would focus on highlighting the unique features, benefits, and value it offers.

• Understand the customer's needs and preferences

• Highlight the unique features and benefits of the phone

• Emphasize the value and long-term benefits of investing in a high-quality phone

• Offer flexible payment options or financing plans

• Provide comparisons with other phones to showcase the superiority of the new phone

• Offer a trial period or money-ba...read more

Finding the triangle with max area given sides.

• Use Heron's formula to calculate the area of each triangle.

• Compare the areas and select the triangle with the maximum area.

• For sides 300, 400, 500, area = 60000 sq. units.

• For sides 300, 400, 700, area = 72000 sq. units.

Algorithm to optimize EXL interview process

• Identify key performance indicators (KPIs) for the interview process

• Use data analytics to track and analyze the KPIs

• Implement automation and AI to streamline the process

• Incorporate feedback from candidates and interviewers to continuously improve the process

Inner joins, outer joins, and left join are types of SQL joins used to combine data from multiple tables.

• Inner join returns only the matching records from both tables.

• Outer join returns all records from both tables, including non-matching records.

• Left join returns all records from the left table and the matching records from the right table.

• Example: INNER JOIN customers ON orders.customer_id = customers.customer_id

• Example: LEFT JOIN customers ON orders.customer_id = customers...read more

Probability of a girl child when one of the two children is boy

• Use Bayes' theorem to calculate the conditional probability

• Assume equal probability of having a boy or girl child

• Answer is 1/2 or 50%

Analytics is crucial for informed decision-making and driving business growth. EXL's expertise and innovative solutions make them the ideal choice.

• Analytics provides valuable insights into customer behavior, market trends, and business performance.

• Data-driven decision-making is essential for staying competitive in today's fast-paced business environment.

• EXL's advanced analytics capabilities and industry expertise enable them to deliver innovative solutions that drive business...read more

To draw a dual axis chart of bar and line chart, use Excel or any other data visualization tool.

• Create a bar chart with the data you want to display

• Add a second data series and choose line chart as the chart type

• Right-click on the second data series and select 'Format Data Series'

• Under 'Series Options', choose 'Secondary Axis'

• Adjust the formatting as needed to make the chart clear and easy to read

Iterating to check if a number is prime in C language requires justification.

• Iterating through all numbers up to the square root of the number is necessary to check if it is prime.

• The time complexity of this algorithm is O(sqrt(n)), which is efficient for small to medium-sized numbers.

• For larger numbers, more efficient algorithms like the Miller-Rabin primality test can be used.

• The number of iterations required depends on the size of the number being checked.

• The iteration pro...read more

DML, DDL, and TCL are terms used in SQL for manipulating and managing data.

• DML (Data Manipulation Language) is used for inserting, updating, and deleting data in a database.

• DDL (Data Definition Language) is used for creating, altering, and dropping database objects such as tables, indexes, and views.

• TCL (Transaction Control Language) is used for managing transactions in a database, including committing or rolling back changes.

• Examples of DML statements include INSERT, UPDATE,...read more

The maximum number of runs an opener batsman can score in a T20 match if he stays till the end is 240.

• Assuming the opener faces all 120 balls, he can score a maximum of 240 runs.

• This is calculated by hitting a six on every ball.

• However, this is practically impossible and has never been achieved in a T20 match.

Cut cake into 8 pieces with 3 slices

• Make two horizontal cuts to get 4 equal pieces

• Stack the 4 pieces and make two vertical cuts

• You now have 8 equal pieces of cake

GROUP BY is a SQL clause used to group rows based on a column and perform aggregate functions on them.

• Used to group rows based on a column

• Aggregate functions can be performed on the grouped rows

• Used with SELECT statement

• Commonly used with COUNT, SUM, AVG functions

• Helps in data analysis and reporting

Proc means and proc summary are SAS procedures used for summarizing data, but with slight differences.

• Proc means provides more detailed statistics like standard deviation, minimum and maximum values, while proc summary only provides basic statistics like mean and sum.

• Proc means can handle missing values, while proc summary cannot.

• Proc summary can create multiple output datasets, while proc means only creates one.

• Both procedures can be used for numeric and character variables....read more

Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.

• Big data involves the collection, storage, and analysis of massive amounts of data

• It requires advanced technologies and tools to process and make sense of the data

• Examples of big data include social media data, sensor data, and financial market data

Inner join returns only matching rows from both tables while left join returns all rows from left table and matching rows from right table.

• Inner join is used to retrieve data that exists in both tables based on a common column.

• Left join is used to retrieve all data from the left table and matching data from the right table.

• Inner join excludes non-matching rows from both tables while left join includes all rows from the left table.

• Inner join is faster than left join as it invo...read more

The number of ice cream sales in Delhi region is not available.

• There is no available data on the number of ice cream sales in Delhi region.

• It is difficult to estimate the exact number of ice cream sales in Delhi region without proper data.

• Factors like season, location, and competition can affect the number of ice cream sales in Delhi region.

The question is unclear and lacks context. More information is needed to provide an accurate answer.

• What is the context of the question? Is it related to a specific store or location?

• What is the timeframe for the question? Is it asking for current inventory or historical data?

• Are there any assumptions that can be made based on the information given?

• Without additional information, it is impossible to provide an accurate answer.

Approximately 500 gallons of detergent are used in a hospital in a day.

• Consider the size of the hospital and number of patients

• Think about the various departments that require cleaning

• Take into account the frequency of cleaning tasks

• Estimate based on typical usage rates in healthcare facilities

To remove duplicates from an array of strings, use a hash set or sort the array and iterate to remove duplicates.

• Create a hash set and iterate through the array, adding each element to the set. If the element already exists in the set, remove it from the array.

• Sort the array using a sorting algorithm like quicksort or mergesort. Then iterate through the sorted array and remove any duplicates by comparing adjacent elements.

Cross join is a type of join operation in relational databases that combines each row from one table with every row from another table.

• Cross join produces a Cartesian product of the two tables involved.

• It does not require any matching condition or join predicate.

• The resulting number of rows in the output is the product of the number of rows in the two tables being joined.

• Cross join is also known as a Cartesian join or a cross product.

• It is commonly used when you want to combi...read more

To make 8 using 3,1,3,6, we can use the equation (3+1)*(3+6)

• Add 3 and 1 to get 4

• Add 3 and 6 to get 9

• Multiply 4 and 9 to get 36

• Divide 36 by 4 to get 8

proc report is a SAS procedure used for creating tabular reports.

• proc report is used to summarize and present data in a tabular format.

• It allows users to define the structure and appearance of the report.

• Users can specify variables, statistics, and formatting options.

• It supports grouping, sorting, and summarizing data.

• Output can be generated in various formats like HTML, PDF, and RTF.

• Example: proc report data=sales; column region product sales; run;

PDV in SAS stands for Program Data Vector, which is a temporary storage area for data during program execution.

• PDV is used to hold data values during program execution

• It is created automatically by SAS and is used to store data temporarily

• PDV is used to hold data values before they are written to a SAS dataset

• It is also used to hold data values during data manipulation and analysis

Logistic regression is a statistical model used to predict the probability of a binary outcome based on one or more predictor variables.

• Logistic regression is used when the dependent variable is binary (e.g. 0 or 1, yes or no).

• It estimates the probability that a given outcome is true using a logistic function.

• The output of logistic regression is a probability score between 0 and 1.

• It is commonly used in various fields such as finance, marketing, and healthcare for predicting ...read more