Filter interviews by
I applied via Naukri.com and was interviewed in May 2023. There were 3 interview rounds.
Joins are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Subquery is a query nested within another query
Union combines the result sets of two or more SELECT statements, while Union All includes duplicates
Rank assigns unique numbers to each row, while dense rank does not leave gaps between ranks.
Rank assigns unique numbers to each row based on the order specified.
Dense rank also assigns unique numbers to each row, but does not leave gaps between ranks.
For example, if we have scores of 90, 85, 85, 80, rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3.
Write a query to find third max salary
Top trending discussions
POM stands for Project Object Model in Maven, which is an XML file that contains information about the project and configuration details.
POM is the fundamental unit of work in Maven, containing information such as project dependencies, build settings, and plugins.
It helps Maven to manage project dependencies, build process, and deployment.
POM file is named pom.xml and is located in the root directory of the project.
It ...
STLC is a subset of SDLC that focuses on testing while SDLC covers the entire software development process.
SDLC is a broader term that covers all the phases of software development including planning, designing, coding, testing, and maintenance.
STLC is a subset of SDLC that focuses only on the testing phase.
SDLC is a sequential process while STLC can be iterative.
SDLC is a framework while STLC is a process.
Examples of ...
I applied via Walk-in and was interviewed in Jan 2024. There was 1 interview round.
Different types of assert include assert equals, assert true, assert false, assert not null, and assert not same.
Assert equals: Compares two values for equality
Assert true: Checks if a condition is true
Assert false: Checks if a condition is false
Assert not null: Verifies that a value is not null
Assert not same: Verifies that two objects do not refer to the same object
There are various types of coats, including trench coats, pea coats, duffle coats, and overcoats.
Trench coat
Pea coat
Duffle coat
Overcoat
I applied via Approached by Company and was interviewed in Dec 2023. There was 1 interview round.
Frames in QA refer to the use of framesets and iframes in web applications.
Frames are used to divide a web page into multiple sections, each with its own HTML document.
To handle frames, QA engineers need to understand how to switch between frames using methods like switchTo().
They should also be familiar with locating elements within frames using appropriate locators.
Example: driver.switchTo().frame('frameName')
Example
I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.
Smoke testing is a quick test to check if the software build is stable, while sanity testing is a more thorough test to check specific functionalities.
Smoke testing is done to ensure the critical functionalities of the software are working fine after a build, while sanity testing is done to verify specific features or functionalities.
Smoke testing is usually performed before detailed testing, while sanity testing is pe...
Test Plan is a document that outlines the scope, approach, resources, and schedule of testing activities.
Defines the objectives and scope of testing
Outlines the test strategy and approach
Includes test deliverables, resources, and schedule
Identifies risks and mitigation strategies
Provides a roadmap for the testing process
Defect Life Cycle is the process of identifying, reporting, fixing, retesting, and closing defects in software development.
Defect identification: Defects are identified through testing or user feedback.
Defect reporting: Defects are reported in a defect tracking system with details like severity, priority, and steps to reproduce.
Defect fixing: Developers analyze and fix the reported defects.
Defect retesting: Testers ver...
Software Development Life Cycle (SDLC) is a process used by software development teams to design, develop, test, and deploy high-quality software.
SDLC consists of several phases such as planning, analysis, design, implementation, testing, and maintenance.
Each phase has its own set of activities and deliverables to ensure the software meets quality standards.
Examples of SDLC models include Waterfall, Agile, and DevOps.
S...
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There was 1 interview round.
The latest version of Selenium is Selenium 4.
Selenium 4 was released in December 2018.
It includes new features such as relative locators, improved W3C WebDriver support, and more.
Selenium 4 also has better support for modern web technologies like HTML5 and CSS3.
The latest version of Java is Java 17.
Java 17 was released on September 14, 2021.
It comes with new features like sealed classes, pattern matching for switch statements, and more.
It also includes performance improvements and security updates.
Define a hashmap with String as key and Integer as value, find second highest value key.
Create a HashMap
Iterate through the values to find the second highest value
Retrieve the key corresponding to the second highest value
Integration test cases for coffee machine ensure all components work together correctly.
Test the communication between the coffee machine and the water reservoir to ensure proper water flow.
Verify that the coffee machine can correctly grind coffee beans and dispense them into the filter.
Check that the heating element heats the water to the correct temperature for brewing.
Test the functionality of the control panel in s...
A button on the login page is not working, preventing users from logging in
The bug prevents users from accessing the system
However, users can still use alternative methods to log in, making it low priority
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
Senior Associate
340
salaries
| ₹2 L/yr - ₹7 L/yr |
Process Associate
237
salaries
| ₹1.7 L/yr - ₹7 L/yr |
Quality Analyst
231
salaries
| ₹3.7 L/yr - ₹9 L/yr |
AR Associate
207
salaries
| ₹2 L/yr - ₹5 L/yr |
Associate
167
salaries
| ₹2 L/yr - ₹5 L/yr |
Deloitte
Ernst & Young
PwC
KPMG India