30+ EXL Service Interview Questions and Answers for Freshers

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.

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

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

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

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

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

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

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.

The height of a light pole on the road should be determined based on factors such as road width, lighting requirements, and safety regulations.

• Consider the width of the road and the distance between light poles to ensure adequate lighting coverage.

• Take into account the height of nearby buildings or structures that may obstruct the light.

• Adhere to safety regulations and guidelines regarding the minimum and maximum height of light poles.

• Consider the type of lighting fixtures be...read more

Factors to consider when installing an elevator in the Sabarmati building

• Building regulations and permits

• Structural integrity of the building

• Available space and layout

• Electrical and mechanical requirements

• Safety features and emergency protocols

• Maintenance and servicing

Three ants on an equilateral triangle can move along any two sides. What is the probability of no collision?

• Each ant has two possible directions to move

• The probability of collision is 1/3

• The probability of no collision is 8/27

Calculate probability of an insect on a Rubik's cube returning to center block after 2 moves and falling on side face on 3rd move.

• The insect has 4 options for each move

• To return to center block, it must move in opposite direction of its first move

• Probability of returning to center block after 2 moves is 0.125

• Probability of falling on side face on 3rd move is 0.5

The bird travels the same distance as the sum of the distances covered by both trains.

• The bird starts with one train and reverses its direction when it reaches the other train.

• This process continues until the two trains collide.

• The distance traveled by the bird is equal to the sum of the distances covered by both trains.

Smallest number with remainders when divided by 2 to 9.

• Find the LCM of 2 to 9.

• Add 1 to the LCM until it satisfies the given remainders.

• The final number is the smallest number that satisfies all the remainders.

Factors to consider before giving a loan to a customer as a bank owner

• Credit score and history

• Income and employment status

• Debt-to-income ratio

• Collateral or assets

• Purpose of the loan

• Repayment ability

• Credit utilization ratio

• Legal and regulatory requirements

25 horses, 5 lanes, no stopwatch. Find fastest 3 horses. Minimum races required?

• Divide horses into 5 groups of 5 each

• Race each group, identify fastest horse from each group

• Race the 5 fastest horses, identify the fastest horse

• Repeat the process with the remaining 20 horses

• Total races required = 7

Pick a fruit from the jar with both apples and oranges. Then deduce the contents of each jar based on the fruit you picked.

• Pick a fruit from the jar labeled 'apples and oranges'

• If you picked an apple, then the jar labeled 'apples' actually contains oranges and the jar labeled 'oranges' actually contains apples

• If you picked an orange, then the jar labeled 'oranges' actually contains apples and the jar labeled 'apples' actually contains oranges

Visa, Mastercard, and AmEx are payment networks that process transactions made with credit cards.

• Visa, Mastercard, and AmEx are payment networks that facilitate transactions between merchants, banks, and cardholders.

• They provide the infrastructure for credit card transactions to occur, including authorization, clearing, and settlement.

• Visa and Mastercard are accepted at most merchants worldwide, while AmEx is more exclusive and typically accepted at higher-end establishments....read more

Analytics is used in various fields around me

• Marketing and advertising

• Finance and banking

• Healthcare and medicine

• Sports and fitness

• Transportation and logistics

The distance between Delhi and Beijing can be estimated using various methods.

• One can use the Haversine formula to calculate the distance based on the latitude and longitude of the two cities.

• Another method is to use online distance calculators that take into account the flight distance and driving distance.

• The distance can also be estimated by looking at the approximate time it takes to travel between the two cities by air or road.

• Factors such as the mode of transportation, ...read more

Estimating the number of Rs. 1000 notes in India before demonetization.

• The total currency in circulation before demonetization was around Rs. 17.77 lakh crore.

• Rs. 1000 notes constituted around 39% of the total currency in circulation.

• Therefore, the estimated number of Rs. 1000 notes in India before demonetization was around 6.92 billion.

• However, this is just an estimate and the actual number may vary.

Calculated fields in Microsoft Excel are formulas created by users to perform calculations on data in a table.

• Calculated fields are created using formulas

• They can perform calculations on data in a table

• Examples include summing up columns or calculating averages

• Calculated fields are dynamic and update automatically when the data changes

The estimated number of people who participated in the Delhi Marathon is...

• The number of registered participants can be used as a starting point

• Factors such as weather conditions, location, and popularity of the event can affect the turnout

• Previous years' participation numbers can also be used as a reference

• Media coverage and social media activity can provide insights into the event's popularity

• An official statement from the organizers can provide an accurate count

VLOOKUP is a function in Excel used to search for a specific value in a table and return a corresponding value.

• VLOOKUP stands for Vertical Lookup

• It is used to find a specific value in a table and return a corresponding value from the same row

• It requires a lookup value, table array, column index number, and range lookup

• Example: VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

• It is commonly used in financial analysis, data management, and reporting

A credit card allows you to borrow money from a bank or financial institution to make purchases.

• Credit card issuer gives you a line of credit based on your creditworthiness

• You can use the card to make purchases up to your credit limit

• You have to pay back the borrowed amount with interest

• If you don't pay the full amount, interest is charged on the remaining balance

• Late payments or exceeding credit limit can result in fees and damage to credit score

I will talk about the impact of technology on modern education for 5 minutes.

• Introduction to technology in education

• Benefits of technology in learning (e.g. access to information, interactive learning)

• Challenges of technology in education (e.g. digital divide, distractions)

• Future trends in educational technology

• Examples of successful integration of technology in education (e.g. online learning platforms, virtual reality in classrooms)

Functions in SQL and Excel are used to perform calculations, manipulate data, and automate tasks.

• Functions in SQL are used to perform calculations, manipulate data, and automate tasks within a database.

• Common SQL functions include SUM, AVG, COUNT, MAX, MIN, and CONCAT.

• Functions in Excel are used to perform calculations, manipulate data, and automate tasks within spreadsheets.

• Common Excel functions include SUM, AVERAGE, IF, VLOOKUP, and CONCATENATE.

The general entry for bank interest is to debit the bank account and credit the interest income account.

• Debit bank account

• Credit interest income account

• Interest income is recorded as revenue

• Bank account is reduced by the amount of interest paid

• Example: Debit Bank Account $100, Credit Interest Income Account $100

It depends on the purpose and individual's financial situation.

• Loan is better for long-term investments like buying a house or car.

• Credit is better for short-term expenses like paying bills or emergencies.

• Interest rates and repayment terms should be carefully considered.

• Individual's credit score and financial stability also play a role in decision making.

Deferred income is a liability that arises when a company receives payment for goods or services that it has not yet delivered or rendered.

• Deferred income is also known as unearned revenue.

• It is recorded as a liability on the balance sheet until the goods or services are delivered or rendered.

• Once the goods or services are delivered or rendered, the deferred income is recognized as revenue on the income statement.

• Examples of deferred income include prepaid rent, prepaid insur...read more

Accounts payable is the amount of money a company owes to its vendors or suppliers for goods or services received.

• Accounts payable is a liability account in the company's balance sheet

• It includes invoices, bills, and other expenses that are yet to be paid

• It is important to manage accounts payable to avoid late payments and maintain good relationships with vendors

• Examples of accounts payable include rent, utilities, and inventory purchases

There are approximately 50,000 bike owners in the city.

• Estimate based on the number of bike shops and bike lanes in the city

• Consider the population density and the popularity of biking as a mode of transportation

• Survey a sample of the population to get a more accurate estimate

OOPs concepts in C# include inheritance, encapsulation, polymorphism, and abstraction.

• Inheritance allows a class to inherit properties and behavior from another class.

• Encapsulation involves bundling data and methods that operate on the data into a single unit.

• Polymorphism allows objects to be treated as instances of their parent class.

• Abstraction involves hiding the complex implementation details and showing only the necessary features to the user.

Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.

• Vlookup stands for 'Vertical Lookup'.

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column.

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the value in t...read more

Primary key uniquely identifies a record in a table, while foreign key establishes a relationship between two tables.

• Primary key is unique and cannot have null values

• Foreign key references the primary key of another table

• Primary key can be only one per table, while foreign key can be multiple

• Example: Primary key in 'Students' table could be 'student_id', while foreign key in 'Courses' table could be 'student_id' referencing 'Students' table

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

• Model: Represents the data and business logic of the application

• View: Represents the user interface

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

• Promotes code reusability, modularity, and separation of concerns

• Commonly used in web development frameworks like Ruby on Rails, ASP.NET MVC, and La...read more