i
Marsh McLennan
Filter interviews by
Top trending discussions
posted on 17 Jun 2024
The output of each join between Table 1 and Table 2 with values 1,1,1 and 1,1,0 respectively.
Inner join: Output will be 1,1,1 as it only includes matching values from both tables.
Left join: Output will be 1,1,1 from Table 1 as it includes all values from Table 1 and matching values from Table 2.
Right join: Output will be 1,1,0 from Table 2 as it includes all values from Table 2 and matching values from Table 1.
Full out...
To find duplicates without using count(*), use self-join and group by clause.
Use self-join to join the table with itself on the column that contains the duplicates.
Use group by clause to group the results by the column that contains duplicates.
Select the columns you want to display along with the count of duplicates.
I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in May 2021. There were 5 interview rounds.
posted on 24 Jul 2024
Test automation framework is a set of guidelines, tools, and processes used to automate testing of software applications.
Test automation framework helps in organizing test scripts, data, and reports.
It provides reusable components for test automation such as libraries, functions, and utilities.
Frameworks can be data-driven, keyword-driven, or hybrid depending on the project requirements.
Popular test automation framewor...
A function interface program is a program that defines the interface of a function without implementing it.
Function interface programs are used to declare the structure and parameters of a function without writing the actual code.
They are commonly used in object-oriented programming to define abstract classes or interfaces.
Example: In Java, an interface is a type similar to a class but defines a set of abstract methods
Notice period varies by company policy and can range from 15 days to 3 months.
Notice period duration is typically specified in the employment contract.
It can range from 15 days to 3 months depending on company policy.
Some companies may require longer notice periods for senior positions.
Employees are usually expected to work during the notice period or pay in lieu of notice.
Notice period allows time for both the employe
I applied via Job Portal and was interviewed before Feb 2023. There were 3 interview rounds.
Test data can be read from Excel using libraries like Apache POI or OpenPyXL.
Use libraries like Apache POI or OpenPyXL to read data from Excel files
Identify the sheet and cell from which data needs to be read
Handle different data types like strings, numbers, dates, etc.
Perform validations on the data read from Excel
Estimating in Agile projects involves breaking down tasks, assigning story points, and using historical data.
Break down tasks into smaller, manageable units
Assign story points to each task based on complexity and effort required
Use historical data and team velocity to estimate future tasks
Collaborate with team members to reach a consensus on estimates
Prioritize critical features based on impact and risk assessment
Identify critical features based on impact on core functionality
Prioritize features with high risk of failure or impact on user experience
Consider customer feedback and usage data to prioritize features
Collaborate with stakeholders to determine key features for testing
Use risk-based testing approach to focus on high-risk areas
posted on 16 Jun 2022
I applied via Approached by Company and was interviewed in Dec 2021. There was 1 interview round.
Risk based testing is a method of prioritizing testing efforts based on the likelihood and impact of potential failures.
Identify potential risks and their impact on the system
Prioritize testing efforts based on the identified risks
Allocate testing resources accordingly
Continuously monitor and reassess risks throughout the testing process
Examples: testing critical functionalities first, testing for security vulnerabilit
I applied via Company Website and was interviewed in Jan 2024. There was 1 interview round.
based on 6 reviews
Rating in categories
Senior Associate
419
salaries
| ₹2.3 L/yr - ₹6.6 L/yr |
Specialist
345
salaries
| ₹3.3 L/yr - ₹7.9 L/yr |
Associate
242
salaries
| ₹1.8 L/yr - ₹4.1 L/yr |
Senior Analyst
236
salaries
| ₹2.4 L/yr - ₹6 L/yr |
Assistant Manager
227
salaries
| ₹5.5 L/yr - ₹22 L/yr |
TCS
Infosys
Wipro
HCLTech