20+ Interview Questions and Answers

SQL joins are used to combine data from two or more tables based on a related column.

• Joins help to avoid data duplication and improve query performance.

• Types of joins include inner join, left join, right join, and full outer join.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

• Example: SELECT * FROM table1 LEFT JOIN table2 ON table1.column = table2.column WHERE table2.column IS NULL;

Acknowledge the mistake, apologize, offer a solution, and take steps to prevent future errors.

• Acknowledge the mistake and apologize sincerely to the client

• Offer a solution or rectification for the mistake made

• Take steps to prevent similar errors in the future by double-checking emails before sending

• Communicate openly and transparently with the client to maintain trust and credibility

Manual testing is done by humans, while automation testing is done using tools and scripts.

• Manual testing involves testers executing test cases manually without any automation tools.

• Automation testing involves using tools and scripts to automate test case execution.

• Manual testing is time-consuming and prone to human errors, while automation testing is faster and more reliable.

• Manual testing is suitable for exploratory testing and ad-hoc testing, while automation testing is id...read more

A pricing procedure is a set of instructions that determines the price of a product or service based on various factors.

• It is used in SAP to calculate the price of a product or service

• It considers various factors such as discounts, taxes, surcharges, etc.

• It consists of condition types, access sequences, and calculation schema

• Example: A pricing procedure for a product may consider the quantity ordered, customer type, and any applicable discounts

SQL is a programming language used for managing and manipulating databases. Joins are used to combine rows from two or more tables based on a related column between them.

• SQL stands for Structured Query Language

• It is used to communicate with and manipulate databases

• Joins are used to combine data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id...read more

IPO stands for Initial Public Offering, which is the first time a company offers its shares to the public. Equity shares represent ownership in a company.

• IPO is a process through which a private company becomes a public company by offering its shares to the public for the first time.

• Equity shares are a type of security that represents ownership in a company and entitles the shareholder to a portion of the company's profits.

• Investors can buy IPO shares at the offering price be...read more

ESG stands for Environmental, Social, and Governance. It is a set of criteria used to evaluate a company's performance in these areas.

• ESG factors are used by investors to assess the sustainability and ethical impact of an investment in a company.

• Environmental criteria may include a company's carbon footprint, waste management practices, and energy efficiency.

• Social criteria may include diversity and inclusion policies, labor practices, and community engagement.

• Governance crit...read more

SCD stands for Slowly Changing Dimensions. There are three types of SCD: Type 1, Type 2, and Type 3.

• SCD is a technique used in data warehousing to track changes in dimension tables over time.

• Type 1 SCD overwrites old data with new data, losing historical information.

• Type 2 SCD creates a new record for each change, preserving historical information.

• Type 3 SCD adds a new column to the table to track changes, but only keeps the most recent value.

• SCD is important for maintaining ...read more

The amount charged if the fund crosses the hurdle rate is the performance fee.

• Performance fee is typically a percentage of the profits earned above the hurdle rate

• For example, if the hurdle rate is 8% and the fund earns 12%, the performance fee may be 20% of the 4% excess return

• Performance fees incentivize fund managers to outperform the hurdle rate

Contrition type refers to the type of remorse or regret a person feels for their actions.

• It can be categorized as genuine or superficial

• Genuine contrition involves a deep sense of remorse and a desire to make amends

• Superficial contrition is often expressed to avoid consequences or to manipulate others

• Examples of contrition type can be seen in criminal justice, where judges may consider a defendant's level of contrition when determining their sentence

SDLC stands for Software Development Life Cycle. It is a process used in software development to design, develop, and test software.

• SDLC is used in the software development industry to ensure the quality and efficiency of software products.

• It consists of several phases including planning, analysis, design, implementation, testing, and maintenance.

• Examples of SDLC models include Waterfall, Agile, and DevOps.

• SDLC helps in managing the development process, reducing risks, and de...read more

Sustainability refers to meeting the needs of the present without compromising the ability of future generations to meet their own needs.

• Sustainability involves using resources in a way that ensures they will still be available for future generations.

• It focuses on balancing economic, social, and environmental factors to create long-term value.

• Examples include renewable energy sources, recycling programs, and sustainable agriculture practices.

SQL joins include inner, outer, left, right, and cross joins. SQL queries include select, insert, update, and delete.

• Inner join returns only matching rows from both tables

• Outer join returns all rows from one table and matching rows from the other

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

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

• Cross join returns all possible combinations of rows from both tables

• Select...read more

A condition type is a category of pricing or calculation used in SAP systems.

• Used in pricing procedures to determine the price of a product or service

• Can be based on various factors such as quantity, weight, or customer group

• Examples include discounts, surcharges, taxes, and freight charges

Condition type is a pricing element in SAP used to determine the price of a product or service based on certain conditions.

• Used in pricing procedures

• Can be based on quantity, value, or other factors

• Examples include discounts, surcharges, and taxes

Wipro Limited is an Indian multinational corporation that provides information technology, consulting and business process services.

• Founded in 1945 by Mohamed Premji as Western India Palm Refined Oil Limited.

• Headquartered in Bangalore, India.

• One of the largest IT services companies in India.

• Offers services in areas such as IT consulting, business process outsourcing, and software development.

• Listed on the New York Stock Exchange and Bombay Stock Exchange.

KYC policy and procedure involves verifying the identity of customers to prevent fraud and money laundering.

• KYC policies require collecting customer information such as ID, address, and financial history.

• Procedures include verifying documents, conducting risk assessments, and monitoring transactions.

• Real-time scenario could involve flagging suspicious activity or updating customer records instantly.

• Examples: verifying a customer's identity through a government-issued ID, cond...read more

SQL query to find the maximum salary in a table.

• Use the MAX() function in SQL to find the maximum salary.

• Syntax: SELECT MAX(salary) FROM employees;

• Example: SELECT MAX(salary) FROM employees WHERE department = 'Finance';

Reading a chart involves analyzing the data presented in the chart to identify trends and patterns.

• Start by identifying the variables being measured on each axis

• Look for any patterns or trends in the data

• Pay attention to any outliers or anomalies

• Consider the scale and units of measurement used

• Compare and contrast different data sets if multiple are presented

• Use the chart to support your analysis and draw conclusions

Management fee is a fee charged by a financial institution for managing an investment portfolio.

• Management fee is typically a percentage of assets under management.

• It is charged by mutual funds, hedge funds, and other investment vehicles.

• The fee covers the costs of managing the portfolio, including research, analysis, and administrative expenses.

• Management fees can vary widely depending on the type of investment and the level of service provided.

• Investors should be aware of m...read more

GPS in mapping stands for Global Positioning System, a satellite-based navigation system that allows users to determine their exact location on Earth.

• GPS uses a network of satellites to provide accurate location information

• It is commonly used in mapping applications to track routes, locate points of interest, and provide directions

• GPS technology is integrated into smartphones, car navigation systems, and handheld GPS devices

• Examples of GPS mapping applications include Google ...read more

SDLC (Software Development Life Cycle) process is a framework used by software development teams to produce high-quality software.

• SDLC involves planning, designing, coding, testing, and deployment stages.

• Common SDLC models include Waterfall, Agile, and DevOps.

• Each stage in the SDLC process has its own set of activities and deliverables.

• SDLC helps ensure that software development projects are completed on time and within budget.

Google Maps is a web mapping service developed by Google, offering satellite imagery, street maps, 360° panoramic views of streets, real-time traffic conditions, and route planning for traveling by foot, car, bicycle, or public transportation.

• Provides satellite imagery and street maps

• Offers 360° panoramic views of streets

• Shows real-time traffic conditions

• Allows route planning for various modes of transportation

• Integration with Google Street View for detailed exploration

Finance is the management of money and investments.

• Finance involves managing money, investments, and other financial assets.

• It includes activities such as budgeting, saving, investing, and borrowing.

• Finance is essential for individuals, businesses, and governments to make informed financial decisions.

• Examples of finance include personal budgeting, corporate finance, and financial planning.

• Finance also encompasses areas such as banking, insurance, and investment management.