Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Aug 2023. There was 1 interview round.
Use SQL query to find the top 3 maximum salaries in a table.
Use the SELECT statement to retrieve the salaries from the table.
Use the ORDER BY clause to sort the salaries in descending order.
Use the LIMIT clause to limit the results to the top 3 salaries.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down data into smaller, more manageable tables.
It helps in reducing data redundancy by storing data in a structured way.
Normalization ensures data integrity by minimizing the chances of inconsistencies.
There are different normal forms such as 1NF, 2NF, 3NF, and BCNF to guide the
I applied via LinkedIn and was interviewed in Oct 2020. There were 3 interview rounds.
Alfa testing is done by the developers before releasing the software to the testers. Beta testing is done by the end-users after the software is released.
Alfa testing is done in a controlled environment, whereas beta testing is done in a real-world environment.
Alfa testing is done by the developers, whereas beta testing is done by the end-users.
Alfa testing is done before the software is released, whereas beta testing ...
System testing verifies the entire system as a whole, while integration testing verifies the interaction between different components.
System testing checks the system's compliance with requirements and specifications
Integration testing checks the interaction between different modules or components
System testing is done after integration testing
System testing is a black box testing technique
Integration testing is a whit...
To get the selected drop down list value, use the getSelectedValue() method.
Use the getSelectedValue() method to get the selected value from the drop down list.
Identify the drop down list element using its ID or name.
Call the getSelectedValue() method on the identified element.
Store the returned value in a variable for further use.
Lists are used in Selenium to store and manipulate web elements.
To store a group of web elements
To iterate through a list of web elements
To select multiple options from a dropdown
To verify the order of elements on a page
Answer on how to write xpath based on preceding xpath.
Use the 'preceding' axis in the xpath expression.
The 'preceding' axis selects all nodes that come before the current node in the document.
Combine the 'preceding' axis with other axes or predicates to create a more specific xpath expression.
Example: //div[@class='container']//preceding::input[@type='text']
To switch one window to another, use the window handles and switch to the desired window.
Get the current window handle using driver.getWindowHandle()
Get all window handles using driver.getWindowHandles()
Switch to the desired window using driver.switchTo().window(handle)
Example: String currentHandle = driver.getWindowHandle(); Set
I applied via Recruitment Consultant
Top trending discussions
I was interviewed in Jan 2025.
A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8
The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.
Subclasses of a sealed class must be either final or sealed themselves.
Errors may occur when trying to extend a sealed class with a non-permitted subclass.
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
Create a database table to store user notifications for out-of-stock items
Implement a service to check item availability and send notifications to subscribed users
Provide a user interface for users to subscribe to notifications for specific items
posted on 4 Feb 2025
I was interviewed in Jan 2025.
Yes, open for fixed term hire and working from client location at Gurgaon for 3 days a week.
Open for fixed term hire
Willing to work from client location at Gurgaon for 3 days a week
Implemented automated testing using Selenium WebDriver and JUnit in Agile environment
Implemented automated testing framework using Selenium WebDriver
Utilized JUnit for test case management
Worked in Agile environment to ensure continuous testing and integration
Pilot testing is done by a small group of users before the full release, while beta testing is done by a larger group of users. Automation testing can be used for regression testing, smoke testing, and performance testing.
Pilot testing involves a small group of users testing the functionality in a controlled environment.
Beta testing involves a larger group of users testing the functionality in a real-world environment.
...
Primary key uniquely identifies a record, while unique key allows only one instance of a value in a column. Query to find last id involves using ORDER BY and LIMIT.
Primary key enforces uniqueness and not null constraint on a column
Unique key enforces uniqueness but allows null values
To find row with last id, use ORDER BY id DESC LIMIT 1 in SQL query
Software Testing Life Cycle (STLC) involves planning, designing, executing, and reporting on tests. Defect Life Cycle includes identification, logging, fixing, and retesting defects.
STLC includes requirements analysis, test planning, test design, test execution, and test closure.
Defect Life Cycle involves defect identification, defect logging, defect fixing, defect retesting, and defect closure.
STLC ensures that the so...
303 status code in API means 'See Other'. PUT method is used to update data, while DELETE method is used to remove data. 3 point estimation technique in Agile is used to estimate tasks.
303 status code indicates that the resource can be found at a different URI and should be retrieved from there
PUT method is used to update an existing resource in the API
DELETE method is used to remove a resource from the API
3 point esti...
Links and labels that can be tagged to a bug in Jira
Links: related issues, documents, websites
Labels: priority, severity, type, status
Shell scripting is a way to automate tasks in Unix/Linux systems. Grep is used to search for specific patterns in text files. Href is not a standard Unix command.
Shell scripting automates tasks by writing scripts in a Unix/Linux environment
Grep command is used to search for specific patterns in text files
Example: grep 'search_pattern' file.txt
Href is not a standard Unix command, it may be a typo or a custom script
To resolve conflict with a team member, communication is key. Prioritize understanding, address the issue calmly, find common ground, and work towards a solution together.
Listen to the team member's perspective and concerns
Communicate openly and calmly about the issue
Find common ground and areas of agreement
Work together to find a solution that benefits both parties
Seek input from other team members or a mediator if ne
Open to relocating to Bangalore, working in night shifts, long hours, and 24X7 culture. Goal is to excel in automation testing.
Yes, open to relocating to Bangalore and working from client's office
Yes, open to working in night/rotational shifts
Yes, open to working in long extendable hours or 24X7 culture
Goal is to excel in automation testing
I was interviewed in Jan 2025.
To the job programming in a group discussion on a developed to the company
I am joined in a company because to my family problems and my responsibilities
To the solve in a family problems and i joined to the company
I am Bsc complete in a job to the Wipro company are joined
posted on 2 Feb 2025
I was interviewed in Aug 2024.
I was interviewed in Jan 2025.
posted on 1 Feb 2025
I was interviewed in Aug 2024.
Quantitative aptitude, logical reasoning, verbal ability, technical.
based on 1 interview
Interview experience
based on 22 reviews
Rating in categories
SQL Developer
22
salaries
| ₹2.3 L/yr - ₹5 L/yr |
Softwaretest Engineer
21
salaries
| ₹1.2 L/yr - ₹7.4 L/yr |
Software Tester
10
salaries
| ₹3 L/yr - ₹6 L/yr |
Software Developer
8
salaries
| ₹1.7 L/yr - ₹7.6 L/yr |
DOT NET Developer
8
salaries
| ₹3.1 L/yr - ₹7.6 L/yr |
Infosys
TCS
Wipro
HCLTech