Filter interviews by
Using SQL SUM function on joined tables to calculate total values.
Use JOIN clause to combine tables based on a related column
Use SUM() function to calculate total values
Group by a specific column if needed
Joins in SQL 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 between them
Common 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...
SQL SUM function aggregates numeric data, providing total values from specified columns in a dataset.
The SUM function is used to calculate the total of a numeric column.
Example: SELECT SUM(salary) FROM employees; returns the total salary of all employees.
SUM can be combined with GROUP BY to get totals for different categories.
Example: SELECT department, SUM(salary) FROM employees GROUP BY department; gives total s...
Selenium POM framework is a design pattern that helps in creating maintainable and reusable test automation scripts.
Page Object Model (POM) separates web pages into individual classes, making code more organized and readable.
POM framework reduces code duplication by storing locators and methods for each page in separate classes.
Test scripts interact with web elements through methods defined in page classes, promot...
Yes, I have created a POM framework from scratch.
Yes, I have experience creating a Page Object Model (POM) framework from scratch.
I have organized web elements and actions into separate classes for better maintainability.
Implemented methods to interact with web elements using Selenium WebDriver.
Utilized inheritance and encapsulation principles to create a robust framework.
Used TestNG for test execution and reporti...
There are multiple web element selectors used in QA testing, such as ID, class name, name, tag name, link text, partial link text, xpath, and css selector.
ID selector - Selects an element based on its ID attribute
Class name selector - Selects elements based on their class attribute
Name selector - Selects elements based on their name attribute
Tag name selector - Selects elements based on their tag name
Link text sel...
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
Selenium POM framework is a design pattern that helps in creating maintainable and reusable test automation scripts.
Page Object Model (POM) separates web pages into individual classes, making code more organized and readable.
POM framework reduces code duplication by storing locators and methods for each page in separate classes.
Test scripts interact with web elements through methods defined in page classes, promoting r...
Yes, I have created a POM framework from scratch.
Yes, I have experience creating a Page Object Model (POM) framework from scratch.
I have organized web elements and actions into separate classes for better maintainability.
Implemented methods to interact with web elements using Selenium WebDriver.
Utilized inheritance and encapsulation principles to create a robust framework.
Used TestNG for test execution and reporting.
Ex...
There are multiple web element selectors used in QA testing, such as ID, class name, name, tag name, link text, partial link text, xpath, and css selector.
ID selector - Selects an element based on its ID attribute
Class name selector - Selects elements based on their class attribute
Name selector - Selects elements based on their name attribute
Tag name selector - Selects elements based on their tag name
Link text selector...
Joins in SQL 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 between them
Common 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 righ...
SQL SUM function aggregates numeric data, providing total values from specified columns in a dataset.
The SUM function is used to calculate the total of a numeric column.
Example: SELECT SUM(salary) FROM employees; returns the total salary of all employees.
SUM can be combined with GROUP BY to get totals for different categories.
Example: SELECT department, SUM(salary) FROM employees GROUP BY department; gives total salary...
Using SQL SUM function on joined tables to calculate total values.
Use JOIN clause to combine tables based on a related column
Use SUM() function to calculate total values
Group by a specific column if needed
Top trending discussions
I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.
I applied via Company Website and was interviewed in Jan 2021. There were 3 interview rounds.
In five years, I envision myself as a senior analyst, leading projects and mentoring junior team members while driving impactful data-driven decisions.
I aim to develop expertise in advanced analytics tools, such as Python and R, to enhance data modeling capabilities.
I plan to take on leadership roles in projects, guiding teams to deliver actionable insights that align with business goals.
I aspire to mentor junior analy...
I applied via Walk-in and was interviewed before Jun 2021. There were 2 interview rounds.
HR told about the company on the first day, how it works, told the rules, showed the management and a lot
I applied via Campus Placement and was interviewed before Sep 2021. There were 4 interview rounds.
Prepare normal for aptitude - maths, quant, analytic
My GD topic was Is internet good for students or not
I didn't attempt this as I was noob back in third year Engg
I applied via Approached by Company and was interviewed before Jul 2021. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
If and Switch Case statements are used for conditional branching in programming.
If statements are used for simple conditional branching.
Switch Case statements are used for multiple conditional branching.
If statements are more flexible than Switch Case statements.
Switch Case statements are more efficient than If statements for large number of conditions.
If statements can be nested, but Switch Case statements cannot.
Exam...
Yes, algorithms and pseudocodes are still important in IT Services.
Algorithms are used in various fields of IT such as machine learning, data analysis, and cryptography.
Pseudocodes are used to plan and design algorithms before coding them.
Understanding algorithms and pseudocodes is essential for software engineers to write efficient and optimized code.
Examples of algorithms include sorting algorithms, search algorithms...
Yes, I am comfortable using both CLIs and IDEs for my daily tasks.
I have experience using various CLIs such as Git Bash, Windows Command Prompt, and Terminal on macOS.
I am proficient in using IDEs such as Visual Studio Code, Eclipse, and IntelliJ IDEA.
I understand the benefits and drawbacks of both CLIs and IDEs and can choose the appropriate tool for the task at hand.
based on 3 interview experiences
Difficulty level
Duration
based on 14 reviews
Rating in categories
ETL Developer
39
salaries
| ₹10 L/yr - ₹16.6 L/yr |
QA Engineer
7
salaries
| ₹5.5 L/yr - ₹9 L/yr |
Full Stack Developer
5
salaries
| ₹7 L/yr - ₹10 L/yr |
Software Developer
4
salaries
| ₹7 L/yr - ₹10 L/yr |
Senior Database Administrator
4
salaries
| ₹16 L/yr - ₹26.2 L/yr |
TCS
Accenture
Wipro
Cognizant