Add office photos
Engaged Employer

EXL Service

3.8
based on 6.7k Reviews
Filter interviews by

300+ Interview Questions and Answers

Updated 26 Nov 2024
Popular Designations

Q101. How many type mode of Payments?

Ans.

There are several modes of payment including cash, check, credit/debit card, wire transfer, and online payment.

  • Cash

  • Check

  • Credit/debit card

  • Wire transfer

  • Online payment

Add your answer

Q102. What is Prepaid expenses and where we see in the financial statement?

Ans.

Prepaid expenses are expenses that have been paid for in advance but have not yet been incurred.

  • Prepaid expenses are assets on the balance sheet

  • They are expenses that have been paid for in advance but have not yet been incurred

  • They are gradually expensed over time as they are incurred

  • Examples include prepaid rent, insurance premiums, and prepaid subscriptions

Add your answer

Q103. Guesstimate - detergent used in hospital in a day

Ans.

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

Add your answer

Q104. Name a senario where law of diminishing marginal utlity does not holds

Ans.

The law of diminishing marginal utility does not hold in the case of addictive substances.

  • Addictive substances, such as drugs or alcohol, can lead to an increase in utility with each additional unit consumed.

  • The initial consumption of an addictive substance may provide a high level of utility, but subsequent consumption may not provide the same level of satisfaction.

  • For example, a person addicted to nicotine may experience increasing satisfaction with each cigarette smoked, d...read more

Add your answer
Discover null interview dos and don'ts from real experiences

Q105. What RCA and CAPA? Tools which are used for quality analysis?

Ans.

RCA stands for Root Cause Analysis and CAPA stands for Corrective and Preventive Action. Various tools are used for quality analysis such as Fishbone diagram, Pareto chart, Control chart, etc.

  • RCA is a process used to identify the underlying cause of a problem or an event.

  • CAPA is a process used to identify, correct, and prevent problems from recurring.

  • Fishbone diagram is a tool used to identify the possible causes of a problem.

  • Pareto chart is a tool used to identify the most s...read more

Add your answer

Q106. Tell me a project related to information extraction you have worked upon.

Ans.

Developed a project to extract key information from legal documents using natural language processing techniques.

  • Used NLP tools like spaCy and NLTK to preprocess and analyze text data

  • Implemented named entity recognition to identify key entities like names, dates, and locations

  • Developed custom rules and patterns to extract specific information like case numbers and verdicts

  • Used machine learning algorithms to improve extraction accuracy

  • Collaborated with legal experts to validat...read more

Add your answer
Are these interview questions helpful?

Q107. How do you use cloud computing in digital transformation?

Ans.

Cloud computing enables digital transformation by providing scalable and flexible infrastructure for data storage, processing, and analysis.

  • Cloud computing allows for easy access to data and applications from anywhere, at any time.

  • It enables businesses to scale up or down their computing resources as needed.

  • Cloud-based analytics tools can help organizations gain insights from large amounts of data.

  • Cloud-based collaboration tools can improve communication and productivity amon...read more

Add your answer

Q108. What is Bank reconciliation statement

Ans.

Bank reconciliation statement is a document that compares the bank statement with the company's records to identify any discrepancies.

  • It is used to ensure that the company's records match the bank's records

  • It helps in identifying errors, omissions, or fraudulent activities

  • It includes comparing deposits, withdrawals, and bank charges

  • Reconciling items may include outstanding checks, deposits in transit, and bank errors

  • The statement is prepared regularly to maintain accurate fin...read more

View 1 answer
Share interview questions and help millions of jobseekers 🌟

Q109. How can you remove duplicates?

Ans.

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.

Add your answer

Q110. How many verka lassi are sold daily in jalandhar?

Ans.

Sorry, I don't have the available data.

  • No data available for daily sales of Verka Lassi in Jalandhar.

Add your answer

Q111. What is cross join

Ans.

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

Add your answer

Q112. Guesstimates- Estimate number of kgs of paneer used in banglore per day

Ans.

Approximately 500 kgs of paneer are used in Bangalore per day.

  • Estimate the population of Bangalore

  • Assume average consumption of paneer per person per day

  • Consider the number of restaurants and households in Bangalore

  • Factor in the demand for paneer-based dishes in Bangalore

Add your answer

Q113. What difference you create if you join exl?

Ans.

I bring a unique blend of leadership, strategic thinking, and problem-solving skills to drive growth and innovation at exl.

  • Proven track record of successfully leading teams to achieve business objectives

  • Strong strategic thinking abilities to identify opportunities for growth and improvement

  • Expertise in problem-solving to overcome challenges and drive innovation

  • Experience in implementing effective processes and systems to optimize performance

  • Ability to collaborate with cross-f...read more

Add your answer

Q114. How do you digitize an Insurance Claim Process?

Ans.

Digitizing an insurance claim process involves automating the process of filing, processing, and settling claims using digital tools.

  • Implement an online portal for claim submission and tracking

  • Use digital tools like AI and machine learning to automate claim processing

  • Integrate with third-party data sources to verify claims and prevent fraud

  • Provide real-time updates to customers on the status of their claims

  • Offer digital payment options for claim settlements

  • Ensure data securit...read more

Add your answer

Q115. 2. There are 2 cubes. You have to put digits on both the cubes so that one can form all the numbers from 1 to 31

Add your answer

Q116. Number of 0s in 1 to 1000

Ans.

The number of 0s in 1 to 1000 is 192.

  • There are 1000 numbers from 1 to 1000.

  • Every 10 numbers have one 0 in the units place.

  • Every 100 numbers have ten 0s in the tens place.

  • Every 1000 numbers have one hundred 0s in the hundreds place.

  • Therefore, there are 1 + 10 + 100 + 81 = 192 0s in total.

View 1 answer

Q117. 1. How was it participating in EXL Excellence Quotient 2011?

Add your answer

Q118. How do you automate a report using Excel?

Ans.

Automating a report in Excel involves using macros or VBA code to perform repetitive tasks and generate the report automatically.

  • Use Excel's built-in macro recorder to record your actions and generate VBA code.

  • Write VBA code to manipulate data, format cells, and generate charts or tables.

  • Schedule the report to run at specific times using Excel's built-in scheduling tools or external tools like Windows Task Scheduler.

  • Consider using Excel add-ins or third-party tools for more a...read more

Add your answer

Q119. What are supervised and unsupervised learning models?

Ans.

Supervised learning models are trained on labeled data with known outputs, while unsupervised learning models are trained on unlabeled data without known outputs.

  • Supervised learning models require labeled data for training, where the algorithm learns to map input data to the correct output.

  • Examples of supervised learning include linear regression, logistic regression, support vector machines, and neural networks.

  • Unsupervised learning models do not have labeled output data dur...read more

View 1 answer

Q120. There are three switches and one bulb which is in another room. You need to find which switch turns on the bulb. You can only go once

Ans.

Turn on one switch, wait for a while, then turn it off and turn on another switch. The switch left on is the one connected to the bulb.

  • Turn on switch 1 and leave it on for a few minutes

  • Turn off switch 1 and turn on switch 2

  • Go to the room with the bulb, the switch left on is the one connected to the bulb

Add your answer

Q121. What all softwares you have worked upon?

Ans.

I have worked on various softwares including Microsoft Office Suite, Salesforce, SAP, and Oracle.

  • Microsoft Office Suite (Word, Excel, PowerPoint, Outlook)

  • Salesforce (CRM software)

  • SAP (Enterprise Resource Planning software)

  • Oracle (Database management system)

Add your answer

Q122. What is Accounts Payable cycle?

Ans.

Accounts Payable cycle is the process of managing and paying a company's outstanding bills and invoices.

  • It involves receiving and verifying invoices from vendors

  • Recording the invoices in the accounting system

  • Approving the invoices for payment

  • Issuing payment to the vendors

  • Reconciling vendor statements with accounts payable records

  • Managing cash flow to ensure timely payments

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

Add your answer

Q123. How you will proceed to client problem ?

Ans.

I will follow a structured approach to understand the problem and identify the root cause before proposing a solution.

  • Listen actively to the client's problem and ask relevant questions to gather more information.

  • Analyze the information gathered to identify the root cause of the problem.

  • Propose a solution that addresses the root cause and meets the client's needs.

  • Collaborate with the client to implement the solution and monitor its effectiveness.

  • Provide ongoing support to ensu...read more

Add your answer

Q124. Python code for factorial

Ans.

Python code to calculate factorial of a number.

  • Use a loop to iterate from 1 to the given number.

  • Multiply each number with the previous result.

  • Return the final result.

View 1 answer

Q125. What is P2P cycle / AP?

Ans.

P2P cycle or AP refers to the end-to-end process of purchasing goods or services, receiving and verifying invoices, and making payments to vendors.

  • P2P stands for Procure-to-Pay, which encompasses all activities from requisitioning to payment.

  • Accounts Payable (AP) is the department responsible for managing and processing vendor invoices.

  • The P2P cycle starts with the identification of a need for goods or services and ends with the payment to the vendor.

  • Key steps in the P2P cycl...read more

View 1 answer

Q126. Difference between having and where cause

Ans.

HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows

  • HAVING is used with GROUP BY clause to filter the groups based on aggregate functions

  • WHERE is used to filter rows based on conditions

  • HAVING is applied after the GROUP BY clause, WHERE is applied before

  • HAVING can only be used with SELECT statement that contains a GROUP BY clause

  • Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

  • Example: SELECT * FROM em...read more

Add your answer

Q127. How many 0's in 100!?

Ans.

The number of zeros in 100! can be determined by counting the number of factors of 10.

  • Count the number of factors of 10 in the prime factorization of 100!

  • Each factor of 10 is made up of 2 and 5, so count the number of 2's and 5's separately

  • There are more factors of 2 than 5, so count the number of factors of 5

  • There are 24 factors of 5 in 100!, so there are 24 zeros at the end

Add your answer

Q128. How do you conduct Process Transformation?

Ans.

Process transformation involves analyzing and improving existing processes to increase efficiency and effectiveness.

  • Identify the process to be transformed

  • Analyze the current process and identify areas for improvement

  • Design a new process that addresses the identified issues

  • Implement the new process and monitor its effectiveness

  • Continuously evaluate and improve the process

  • Use tools such as process mapping, Lean Six Sigma, and automation to aid in the transformation

  • Involve stake...read more

Add your answer

Q129. Make 8 using 3,1,3,6

Ans.

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

Add your answer

Q130. 3) SCD Type 2 dimension used in your old project

Ans.

SCD Type 2 is used to maintain historical data in a dimension table.

  • SCD Type 2 is used to track changes in dimension attributes over time.

  • It creates a new record for each change and maintains a history of all changes.

  • It includes additional columns like start date, end date, and version number.

  • Example: Employee table with changes in job title, salary, and department over time.

  • It helps in analyzing trends and making informed decisions based on historical data.

Add your answer

Q131. What is proc report?

Ans.

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;

Add your answer

Q132. Journal entry of Accounts payable

Ans.

Journal entry of Accounts Payable

  • Debit Accounts Payable account for the amount owed

  • Credit Cash or Bank account for the amount paid

  • If a discount is taken, credit the Discount Received account

  • If a purchase return is made, credit the Purchase Returns and Allowances account

Add your answer

Q133. What are the main accounting concepts

Ans.

The main accounting concepts are the principles and guidelines that govern the preparation and presentation of financial statements.

  • Going Concern Concept

  • Consistency Concept

  • Accrual Concept

  • Prudence Concept

  • Materiality Concept

  • Entity Concept

  • Money Measurement Concept

  • Cost Concept

  • Dual Aspect Concept

Add your answer

Q134. General accounting principles and practices

Ans.

General accounting principles and practices refer to the basic rules and guidelines that govern the field of accounting.

  • These principles include the accrual basis of accounting, the matching principle, and the consistency principle.

  • They also involve the use of financial statements, such as the balance sheet, income statement, and cash flow statement.

  • Other practices include the use of double-entry bookkeeping, the recording of transactions, and the preparation of financial rep...read more

Add your answer

Q135. Elaborate PDV in SAS

Ans.

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

Add your answer

Q136. How do you handle the estimations and client budget

Ans.

I handle estimations by thoroughly analyzing project requirements and creating detailed budgets in alignment with client expectations.

  • Conduct a comprehensive analysis of project requirements to determine resources needed

  • Create a detailed budget outlining costs for materials, labor, and any other expenses

  • Regularly communicate with the client to ensure budget alignment and address any changes or concerns

  • Utilize project management tools to track expenses and monitor budget statu...read more

Add your answer

Q137. What are surgery global modifiers?

Ans.

Surgery global modifiers are codes used to indicate the overall status of a surgical procedure.

  • They are used to indicate whether a surgical procedure was a minor or major surgery, whether it was performed by an assistant surgeon, and whether it involved a bilateral procedure.

  • Examples of surgery global modifiers include -54 (surgical care only), -55 (postoperative management only), -56 (preoperative management only), -62 (two surgeons), and -80 (assistant surgeon).

Add your answer

Q138. Difference between bagging and boosting

Ans.

Bagging and boosting are ensemble learning techniques used to improve model performance.

  • Bagging involves training multiple models on different subsets of the training data and combining their predictions through averaging or voting.

  • Boosting involves iteratively training models on the same data, with each subsequent model focusing on the errors of the previous model.

  • Bagging reduces overfitting and variance, while boosting reduces bias and underfitting.

  • Examples of bagging algor...read more

Add your answer

Q139. Number of cycles sold in India annualy

Ans.

The annual number of cycles sold in India varies depending on market trends and consumer demand.

  • The Indian bicycle market is highly competitive with a wide range of brands and models available.

  • Factors such as rising health consciousness, increasing traffic congestion, and environmental concerns have led to a growing demand for bicycles in India.

  • According to a report by Research and Markets, the Indian bicycle market is expected to grow at a CAGR of 7.5% during 2020-2025.

  • Howev...read more

Add your answer

Q140. Verify valdate invoice , All transaction code explain step by step

Ans.

Validating and verifying invoices by explaining all transaction codes step by step.

  • First, review the invoice for accuracy and completeness.

  • Next, match the invoice to the purchase order and receiving report.

  • Then, enter the invoice details into the accounting system using the appropriate transaction code.

  • Finally, reconcile the invoice with the vendor statement to ensure all payments are accounted for.

  • Example: Transaction code 101 may represent a standard invoice entry, while co...read more

Add your answer

Q141. Explain the type of relationships and their use case.

Ans.

Power BI supports three types of relationships: one-to-one, one-to-many, and many-to-many.

  • One-to-one: used when two tables have a unique relationship, such as a person and their social security number.

  • One-to-many: used when one record in the first table can have multiple matching records in the second table, such as a customer and their orders.

  • Many-to-many: used when multiple records in the first table can have multiple matching records in the second table, such as students a...read more

Add your answer

Q142. What is trial Balance

Ans.

Trial balance is a list of all the general ledger accounts and their balances at a specific point in time.

  • Prepared at the end of an accounting period

  • Used to ensure that debits and credits are equal

  • Helps in identifying errors and omissions in the accounting records

  • If the debits and credits do not match, it indicates an error in the accounting records

  • Example: If the total debit balance is $50,000, the total credit balance should also be $50,000

View 2 more answers

Q143. What do you mean by PO?

Ans.

PO stands for Purchase Order.

  • PO is a document used to request goods or services from a supplier.

  • It includes details such as item description, quantity, price, and delivery date.

  • POs are used to track and manage orders, and to ensure that the correct items are received.

  • POs are commonly used in business and procurement processes.

  • Example: A company may issue a PO to a supplier for 100 units of a particular product at a specified price and delivery date.

Add your answer

Q144. How many types of po and example of No po

Ans.

There are two types of purchase orders: Standard PO and Blanket PO. An example of a No PO scenario is when a company makes a small, one-time purchase without a formal purchase order.

  • Standard PO: Used for one-time purchases of goods or services

  • Blanket PO: Used for recurring purchases over a period of time

  • Example of No PO: A company urgently needs to buy office supplies and the employee directly pays for them without going through the formal purchase order process

Add your answer

Q145. What are joins in explain types with examples

Ans.

Joins are used to combine rows from two or more tables based on a related column between them.

  • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

  • INNER JOIN returns rows when there is at least one match in both tables

  • LEFT JOIN returns all rows from the left table and the matched rows from the right table

  • RIGHT JOIN returns all rows from the right table and the matched rows from the left table

  • FULL JOIN returns rows when there is a match in one of the tables

Add your answer

Q146. What is the diff between All and Allexcept

Ans.

All returns all values in a table, while Allexcept returns all values except those specified in the argument.

  • All returns all values in a column or table.

  • Allexcept returns all values in a column or table except those specified in the argument.

  • Example: All(Table[Column]) returns all values in the specified column.

  • Example: Allexcept(Table, Table[Column]) returns all values in the table except those in the specified column.

Add your answer

Q147. What are differences between Append and merge

Ans.

Append adds new data to the end of a dataset, while merge combines two datasets based on a common key.

  • Append adds rows to the end of a dataset, while merge combines rows from two datasets based on a common key column.

  • Append is useful for adding new observations to an existing dataset, while merge is used to combine datasets with related information.

  • Append does not require a common key, while merge requires a common key to match rows from both datasets.

  • Example: Appending a new...read more

Add your answer

Q148. Estimate the number of kgs of paneer used in Bangalore everyday

Ans.

It is difficult to estimate the exact number of kgs of paneer used in Bangalore everyday without specific data.

  • Estimate based on population size and consumption habits

  • Consider the number of restaurants, hotels, and households in Bangalore

  • Look at the average consumption of paneer per person in Bangalore

Add your answer

Q149. Guesstimate case – Estimate the daily revenue of Delhi Metro Service

Add your answer

Q150. What is the journal entries for acvounts recievable

Ans.

Journal entries for accounts receivable record the increase and decrease in the amount owed by customers.

  • When a sale is made on credit, the journal entry debits accounts receivable and credits sales revenue.

  • When a customer makes a payment, the journal entry debits cash and credits accounts receivable.

  • If a customer returns goods, the journal entry debits sales returns and allowances and credits accounts receivable.

  • If an account is deemed uncollectible, the journal entry debits...read more

Add your answer

Q151. What is OS What is pst and ost What is outlook What is group policy What is AD What is users Whai is OU

Ans.

OS stands for Operating System, which is the software that manages computer hardware and software resources.

  • OS is the foundation of a computer system, providing a user-friendly interface and managing tasks and resources.

  • Examples of popular operating systems include Windows, macOS, and Linux.

Add your answer

Q152. How to make payment to Clint

Ans.

Payment to Clint can be made through various methods such as wire transfer, check, or online payment portals.

  • Determine the payment method preferred by Clint

  • Obtain necessary payment information such as account number and routing number

  • Ensure that there are sufficient funds to cover the payment

  • Record the payment in the appropriate accounting system

Add your answer

Q153. Data warehousing approach and dimensions and facts

Ans.

Data warehousing involves organizing and storing data for easy access and analysis. Dimensions and facts are key components.

  • Data warehousing involves extracting, transforming, and loading data into a central repository for analysis

  • Dimensions are the characteristics or attributes of the data, such as time, location, or product

  • Facts are the measurable data points, such as sales revenue or customer count

  • Data is organized into a star or snowflake schema, with dimensions surroundi...read more

Add your answer

Q154. How to deal with lack of work life balance?

Ans.

To deal with lack of work life balance, it is important to prioritize, set boundaries, delegate tasks, and practice self-care.

  • Prioritize tasks and focus on the most important ones

  • Set boundaries by clearly defining working hours and personal time

  • Delegate tasks to team members or colleagues to distribute workload

  • Practice self-care by taking breaks, exercising, and engaging in hobbies or activities outside of work

  • Communicate with supervisors or managers about workload and discus...read more

Add your answer

Q155. What are the three examples of entries you are booking

Ans.

I am currently booking entries for sales revenue, expenses, and payroll.

  • Sales revenue entry includes recording sales transactions and updating accounts receivable.

  • Expenses entry involves recording all expenses incurred by the company, such as rent, utilities, and supplies.

  • Payroll entry includes recording employee salaries, benefits, and taxes.

Add your answer

Q156. Puzzle: Number of minimum matches required to get a winner among N participants

Ans.

The minimum number of matches required to get a winner among N participants is log2(N).

  • The formula to calculate the minimum number of matches is log2(N).

  • For example, if there are 8 participants, the minimum number of matches required is log2(8) = 3.

  • If there are 16 participants, the minimum number of matches required is log2(16) = 4.

  • This formula assumes a single-elimination tournament where each match eliminates one participant.

  • If the tournament has multiple rounds or a differ...read more

Add your answer

Q157. Guesstimate: Number of international cricket matches in a calendar year

Ans.

Approximately 1,000 international cricket matches are played in a calendar year.

  • The number of international cricket matches varies each year depending on the schedule of different cricket boards.

  • In 2019, there were 1,082 international cricket matches played across all formats.

  • Factors such as the ICC World Cup and T20 World Cup can significantly impact the number of matches played in a year.

Add your answer

Q158. Explain SVM algorithm, Mention some of the kernels.

Ans.

SVM is a supervised machine learning algorithm used for classification and regression analysis. It finds the best hyperplane to separate data points.

  • SVM is based on the idea of finding a hyperplane that best divides a dataset into two classes.

  • It can be used for both classification and regression analysis.

  • Some of the popular kernels used in SVM are linear, polynomial, radial basis function (RBF), and sigmoid.

  • Linear kernel is used when the data is linearly separable, while RBF ...read more

Add your answer

Q159. What is the guarantee of Stability

Ans.

Stability in data processing can be guaranteed through proper system design, redundancy, and regular maintenance.

  • Stability can be guaranteed by implementing redundant systems to ensure continuous operation in case of failures.

  • Regular maintenance and updates to the data processing systems can help prevent issues that may lead to instability.

  • Proper system design, including efficient data storage and processing methods, can also contribute to stability.

  • Monitoring and analyzing s...read more

Add your answer

Q160. Estimate the number of bike owners in your city

Ans.

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

Add your answer

Q161. 5) different between truncate, delete and drop

Ans.

Difference between truncate, delete and drop

  • Truncate removes all data from a table but keeps the structure

  • Delete removes specific rows from a table

  • Drop removes the entire table and its structure

  • Truncate and drop cannot be rolled back, but delete can be

  • Truncate is faster than delete as it does not log individual row deletions

Add your answer

Q162. What do you know about transaction monitoring

Ans.

Transaction monitoring involves tracking and analyzing financial transactions to detect suspicious activities.

  • Transaction monitoring is a process used by financial institutions to identify and prevent money laundering, fraud, and other illegal activities.

  • It involves monitoring customer transactions in real-time or retrospectively to identify any unusual patterns or behaviors.

  • Automated transaction monitoring systems use algorithms and rules to flag potentially suspicious trans...read more

Add your answer

Q163. Difference between budgeting and for asting

Ans.

Budgeting involves setting financial goals and creating a plan to achieve them, while forecasting involves predicting future financial outcomes based on past data and trends.

  • Budgeting is a proactive process that involves setting financial goals and creating a plan to achieve them.

  • Forecasting is a reactive process that involves predicting future financial outcomes based on past data and trends.

  • Budgeting helps in controlling expenses and allocating resources effectively.

  • Forecas...read more

Add your answer

Q164. How is GIL and how python handle multi threading

Ans.

GIL stands for Global Interpreter Lock in Python, which limits execution of multiple threads at once.

  • GIL is a mutex that protects access to Python objects, preventing multiple threads from executing Python bytecodes at once.

  • Due to GIL, Python threads are not suitable for CPU-bound tasks but are still useful for I/O-bound tasks.

  • To handle multi-threading in Python, one can use multiprocessing module or asynchronous programming with asyncio.

  • Example: Using multiprocessing module ...read more

Add your answer

Q165. Practical implementation of few features on Tableau Desktop

Ans.

Practical implementation of features on Tableau Desktop

  • Creating interactive dashboards

  • Using calculated fields for data manipulation

  • Utilizing parameters for dynamic filtering

  • Incorporating advanced analytics like forecasting

  • Implementing data blending for combining multiple data sources

Add your answer

Q166. What is Sql?, and performance tuneing

Ans.

SQL is a domain-specific language used for managing and manipulating relational databases.

  • SQL stands for Structured Query Language

  • It is used to communicate with databases to perform tasks such as querying data, updating data, and creating databases

  • Performance tuning in SQL involves optimizing queries, indexes, and database design to improve speed and efficiency

  • Examples of performance tuning techniques include using indexes, avoiding unnecessary joins, and optimizing query exe...read more

Add your answer

Q167. Implement backpropagation algorithm in python

Ans.

Backpropagation algorithm is used to train neural networks by calculating gradients of the loss function with respect to the weights.

  • Initialize weights randomly

  • Forward pass to calculate predicted output

  • Calculate loss using a loss function like mean squared error

  • Backward pass to calculate gradients using chain rule

  • Update weights using gradients and a learning rate

Add your answer

Q168. Howto resolve internet connection issue

Add your answer

Q169. Are you comfortable with hybrid model

Ans.

Yes, I am comfortable with the hybrid model as it allows for flexibility and collaboration.

  • Hybrid model combines remote work with in-person work

  • Allows for flexibility in work schedule and location

  • Encourages collaboration among team members

  • Example: Some days working from home and some days in the office

Add your answer

Q170. Explain the difference between Precision and Recall.

Ans.

Precision is the ratio of true positives to all predicted positives, while recall is the ratio of true positives to all actual positives.

  • Precision measures how accurate the positive predictions are, while recall measures how complete the positive predictions are.

  • Precision is important when the cost of false positives is high, while recall is important when the cost of false negatives is high.

  • A high precision means that when the model predicts a positive, it is likely to be co...read more

Add your answer

Q171. What is the use of a router in the network

Ans.

A router is a networking device that forwards data packets between computer networks.

  • Routes data packets between different networks

  • Acts as a gateway for devices to connect to the internet

  • Provides security by blocking unauthorized access

  • Allows for network segmentation and traffic control

  • Examples: Cisco, Netgear, TP-Link routers

Add your answer

Q172. Bid Management/proposal management experience.

Ans.

Yes, I have bid/proposal management experience.

  • I have managed the bid process from start to finish, including RFP analysis, proposal writing, and submission.

  • I have experience in creating and managing proposal schedules, ensuring timely delivery of proposals.

  • I have worked with cross-functional teams to gather information and develop proposals that meet client needs.

  • I have experience in tracking and reporting on proposal metrics, such as win/loss rates and proposal costs.

  • I have...read more

Add your answer

Q173. What is order confirmation

Ans.

Order confirmation is a document that verifies the details of a purchase order and confirms that it has been received and accepted by the supplier.

  • Order confirmation is sent by the supplier to the buyer after receiving a purchase order.

  • It includes details such as order number, item description, quantity, price, delivery date, and payment terms.

  • It serves as a proof of agreement between the buyer and supplier and helps to avoid any misunderstandings or disputes.

  • Order confirmati...read more

Add your answer

Q174. How to get the last row of any SAS dataset

Ans.

Use the OBS option in a SET statement to read the last observation of a SAS dataset.

  • Use the OBS option in a SET statement followed by the keyword 'END' to read the last observation of a SAS dataset.

  • For example, to read the last observation of a dataset named 'mydata', use the following code: data lastobs; set mydata(obs=last end=last); run;

Add your answer

Q175. What are the P&L metrics of credit card?

Ans.

P&L metrics of credit card include revenue, expenses, and profit generated from credit card operations.

  • Revenue: Total income generated from credit card fees, interest charges, and other sources.

  • Expenses: Costs associated with credit card operations, such as marketing, customer service, and technology.

  • Profit: The difference between revenue and expenses, indicating the financial performance of the credit card business.

  • Examples: Net interest income, interchange fees, annual fees...read more

Add your answer

Q176. What is budgeting and forecasting.

Ans.

Budgeting and forecasting involve planning and estimating financial outcomes for a specific period of time.

  • Budgeting is the process of creating a detailed plan for how to allocate resources and expenses within a specific timeframe.

  • Forecasting involves predicting future financial outcomes based on historical data, market trends, and other relevant factors.

  • Budgeting helps in setting financial goals and monitoring performance, while forecasting assists in making informed decisio...read more

Add your answer

Q177. What is differed revenue

Ans.

Differed revenue is revenue received in advance but not yet earned.

  • Differed revenue is also known as unearned revenue.

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

  • Examples include magazine subscriptions, prepaid rent, and gift cards.

  • Once the revenue is earned, it is recognized on the income statement.

  • Differed revenue is common in industries such as software, consulting, and real estate.

Add your answer

Q178. how to do RPA feasibility

Ans.

RPA feasibility can be determined by analyzing the process, identifying potential automation opportunities, and evaluating the technology and resources required.

  • Analyze the process to identify repetitive, rule-based tasks that can be automated

  • Evaluate the technology and resources required for automation

  • Assess the potential benefits and ROI of implementing RPA

  • Consider the scalability and complexity of the process

  • Perform a pilot test to validate the feasibility of RPA implement...read more

Add your answer

Q179. What is Hypothesis testing

Ans.

Hypothesis testing is a statistical method used to determine whether a hypothesis about a population is likely to be true or not.

  • It involves formulating a null hypothesis and an alternative hypothesis

  • Collecting data and analyzing it using statistical methods

  • Making a decision to either reject or fail to reject the null hypothesis

  • Examples include testing the effectiveness of a new drug, or whether a coin is fair or biased

Add your answer

Q180. What is the journal entry for accounts payable

Ans.

The journal entry for accounts payable is a credit to accounts payable and a debit to the corresponding expense or asset account.

  • Accounts payable is a liability account that represents the amount owed to suppliers or vendors for goods or services received.

  • When recording the journal entry for accounts payable, the accounts payable account is credited to increase the liability.

  • The corresponding expense or asset account is debited to reflect the increase in expenses or assets.

  • Fo...read more

Add your answer

Q181. What is power bi report server?

Add your answer

Q182. Pizzas sold at Domino's

Ans.

Domino's sells a variety of pizzas with different toppings and crusts.

  • Domino's offers classic pizzas like pepperoni and margherita, as well as specialty pizzas like the Philly Cheese Steak and the Wisconsin 6 Cheese.

  • Customers can choose from a variety of crusts, including hand-tossed, thin crust, and Brooklyn style.

  • Domino's also offers gluten-free crust and vegan options.

  • Pizzas can be customized with additional toppings like mushrooms, onions, and peppers.

  • Domino's also offers...read more

Add your answer

Q183. SQL question for finding highest paid salary

Ans.

Use SQL query to find the highest paid salary.

  • Use the MAX() function to find the highest salary value.

  • Select the salary column from the relevant table.

  • Add any necessary joins or filters to ensure accuracy.

Add your answer

Q184. Explain logistic regression.

Ans.

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

Add your answer

Q185. What is a Case management in Pega

Ans.

Case management in Pega is a feature that allows users to track and manage cases or work items through a predefined process.

  • Case management in Pega involves defining the stages, steps, and actions required to complete a case.

  • Users can view the status of a case, assign tasks to individuals, and track progress through the case management system.

  • Pega provides tools for automating and streamlining case management processes, improving efficiency and visibility.

  • Example: A customer ...read more

Add your answer

Q186. How to select variable in model

Ans.

Variables in a model can be selected based on their significance, relevance, and impact on the outcome.

  • Consider the purpose of the model and the specific research question being addressed.

  • Identify variables that are likely to have a significant impact on the outcome.

  • Use statistical techniques like regression analysis to determine the importance of each variable.

  • Consider the practicality and feasibility of collecting data for each variable.

  • Consult with domain experts to ensure...read more

Add your answer

Q187. What is Reconciliation?

Ans.

Reconciliation is the process of comparing two sets of records to ensure they are in agreement.

  • It involves identifying and resolving discrepancies between the two sets of records.

  • Examples include bank statement reconciliation, accounts receivable reconciliation, and inventory reconciliation.

  • Reconciliation helps ensure accuracy and completeness of financial records.

  • It is an important internal control measure to prevent fraud and errors.

  • Reconciliation should be performed regula...read more

Add your answer

Q188. What is p2p cycle?

Ans.

P2P cycle refers to the Procure-to-Pay cycle, which is the process of purchasing goods or services and paying for them.

  • The cycle starts with identifying the need for a product or service.

  • Then, a purchase order is created and sent to the supplier.

  • The supplier delivers the product or service and sends an invoice.

  • The invoice is verified and approved for payment.

  • Finally, payment is made to the supplier.

  • The cycle ends with recording the transaction in the accounting system.

Add your answer

Q189. SQL join types and difference

Ans.

SQL join types include inner join, left join, right join, and full outer join.

  • Inner join returns rows when there is at least one match in both tables.

  • Left join returns all rows from the left table and the matched rows from the right table.

  • Right join returns all rows from the right table and the matched rows from the left table.

  • Full outer join returns all rows when there is a match in either table.

Add your answer

Q190. What is prepaid expenses

Ans.

Prepaid expenses are expenses paid in advance but not yet incurred or used.

  • Prepaid expenses are recorded as assets on the balance sheet.

  • They are gradually expensed over time as they are used or incurred.

  • Examples include prepaid rent, insurance premiums, and subscriptions.

  • Prepaid expenses are common in industries such as real estate and insurance.

Add your answer

Q191. What do you know about BPMN?

Ans.

BPMN stands for Business Process Model and Notation. It is a graphical representation of business processes.

  • BPMN is used to model and design business processes

  • It uses standardized symbols and notation to represent different elements of a process

  • BPMN diagrams can be used to communicate process flows to stakeholders

  • Examples of BPMN symbols include events, activities, gateways, and flows

Add your answer

Q192. Guesstimate: Number of Tubelights in your campus

Ans.

There are approximately 500 tubelights in the campus.

  • Assuming an average of 10 tubelights per classroom and 50 classrooms in the campus.

  • Additional tubelights in hallways, offices, and common areas.

  • Some tubelights may be out of order or not in use.

  • Estimate may vary depending on the size and layout of the campus.

Add your answer

Q193. What is deffer income

Ans.

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

Add your answer

Q194. Different layers of Deep Learning Architecture

Ans.

Deep Learning Architecture has three layers: Input Layer, Hidden Layer, and Output Layer.

  • Input Layer receives input data and passes it to the Hidden Layer.

  • Hidden Layer processes the input data and passes it to the Output Layer.

  • Output Layer produces the final output based on the input data.

  • Each layer can have multiple nodes or neurons.

  • Examples of Deep Learning Architectures include Convolutional Neural Networks (CNNs), Recurrent Neural Networks (RNNs), and Deep Belief Networks...read more

Add your answer

Q195. Why was Gap in your carrier

Ans.

Took a break to pursue further education and gain new skills.

  • Took a break to pursue higher education

  • Used the time to gain new skills and certifications

  • Took a sabbatical to travel and explore different cultures

Add your answer

Q196. Provision for income tax entry

Ans.

Provision for income tax entry is an accounting entry made to account for future tax liabilities.

  • Provision for income tax is made to account for future tax liabilities.

  • It is based on estimated tax rates and taxable income.

  • It is recorded as a liability on the balance sheet.

  • It is adjusted periodically based on actual tax liabilities.

  • Example: If a company estimates that it will owe $10,000 in taxes for the year, it will make a provision entry to record the liability.

  • Example: If ...read more

View 1 answer

Q197. What is P 2 P

Ans.

P2P stands for Procure-to-Pay, a process that involves purchasing goods or services and paying for them.

  • P2P is a cycle that starts with identifying the need for a product or service and ends with payment.

  • It includes steps like requisition, purchase order creation, invoice processing, and payment.

  • P2P helps organizations streamline their procurement process and reduce costs.

  • Examples of P2P software include SAP Ariba, Coupa, and Oracle Procurement Cloud.

Add your answer

Q198. Recent developments in analytics

Ans.

Recent developments in analytics

  • Advancements in machine learning algorithms

  • Increased use of artificial intelligence in data analysis

  • Emergence of big data analytics

  • Integration of analytics with Internet of Things (IoT)

  • Growing importance of predictive analytics

  • Rise of real-time analytics

Add your answer

Q199. Difference in concepts

Ans.

Difference between concepts

  • Concepts are abstract ideas while differences are distinctions between two or more things

  • Concepts are generalizations while differences are specific details

  • Examples: Concept of love vs. differences in love languages

Add your answer

Q200. Code in Appian basis on use cases

Ans.

Coding in Appian involves creating applications based on specific use cases.

  • Identify the use case requirements and design the application flow accordingly

  • Use Appian's low-code platform to build the necessary components and logic

  • Test the application thoroughly to ensure it meets the use case criteria

  • Iterate on the design based on feedback and updates to the use case

Add your answer
1
2
3
4
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at null

based on 260 interviews in the last 1 year
Interview experience
4.0
Good
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Interview Questions from Similar Companies

3.9
 • 518 Interview Questions
3.8
 • 356 Interview Questions
3.7
 • 262 Interview Questions
3.8
 • 139 Interview Questions
3.9
 • 132 Interview Questions
View all
Top EXL Service Interview Questions And Answers
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter