Siemens Gamesa Renewable Power Private Limited Interview Questions and Answers

Updating database using SQL query

• Use UPDATE statement to modify existing records in a table

• Specify the table name, column names, and values to be updated

• Use WHERE clause to filter which records to update

Use SQL query to find the 2nd highest salary in a table

• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to get the second row

Use SQL query to create a database

• Use CREATE DATABASE statement to create a new database

• Specify the name of the database after CREATE DATABASE

• Make sure to have necessary permissions to create a database

Use RENAME DATABASE statement to change name of database in SQL.

• Use RENAME DATABASE statement followed by current database name and new database name.

• Make sure to have necessary permissions to rename the database.

• Example: RENAME DATABASE old_database TO new_database;

I have used various types of locators in my project, including ID, name, class name, xpath, and CSS selectors.

• ID locator: Used to locate elements by their unique ID attribute.

• Name locator: Used to locate elements by their name attribute.

• Class name locator: Used to locate elements by their class name attribute.

• XPath locator: Used to locate elements using XPath expressions.

• CSS selector locator: Used to locate elements us...read more

Absolute xpath starts from the root node, while relative xpath starts from any node.

• Absolute xpath starts with a single forward slash (/) and is more brittle as any changes in the structure of the DOM can break the xpath.

• Relative xpath starts with a double forward slash (//) and is more flexible as it can start from any node in the DOM.

• Absolute xpath is faster than relative xpath as it directly navigates to the element...read more

Traversing XPath is used to navigate through the elements in a structured way.

• Use '//' to select all elements in the document, regardless of their location

• Use '/' to select direct child elements

• Use '[@attribute='value']' to select elements based on their attribute value

• Use 'following-sibling::' to select siblings that come after the current element

• Use 'preceding-sibling::' to select siblings that come before the curren...read more

Keywords on feature file are used to define the behavior of the scenarios in BDD testing.

• Keywords like Given, When, Then, And, But are used to structure the scenarios

• Keywords help in writing clear and concise test cases

• Examples: Given I am on the login page, When I enter valid credentials, Then I should be logged in

The step definition should match the steps in the feature file for automation testing.

• Read the step from the feature file

• Create a corresponding step definition in the automation testing framework

• Ensure the step definition accurately performs the desired action

Types of hooks in BDD include Before, After, BeforeStep, AfterStep, BeforeFeature, AfterFeature, BeforeScenario, AfterScenario.

• Before - runs before each scenario

• After - runs after each scenario

• BeforeStep - runs before each step in a scenario

• AfterStep - runs after each step in a scenario

• BeforeFeature - runs before each feature

• AfterFeature - runs after each feature

• BeforeScenario - runs before each scenario

• AfterScenario -...read more

Method overloading is when multiple methods in the same class have the same name but different parameters. Method overriding is when a subclass provides a specific implementation of a method that is already provided by its superclass.

• Method overloading involves creating multiple methods in the same class with the same name but different parameters.

• Method overriding occurs when a subclass provides a specific implementat...read more

Swapping two integers without using a third variable in a programming language.

• Use bitwise XOR operation to swap two integers without using a third variable.

• Example: int a = 5, b = 10; a = a ^ b; b = a ^ b; a = a ^ b; // Now a = 10, b = 5

The program will count and print the occurrence of each character in a given string.

• Create an array to store the count of each character (initialize with 0)

• Iterate through the string and increment the count of each character in the array

• Print the count of each character along with the character itself

If not meeting requirement in testcase, follow documentation format like updating test case steps, expected results, and defect details.

• Update the test case steps to accurately reflect the actual steps taken during testing

• Update the expected results to reflect the actual results observed during testing

• Document the defect details including steps to reproduce, screenshots, and any additional information

• Assign a severity ...read more

I have used technologies like Selenium, JUnit, TestNG, Cucumber, and Jenkins in my testcases.

• Selenium

• JUnit

• TestNG

• Cucumber

• Jenkins

Boundary value analysis is a software testing technique used to identify errors at boundaries of input ranges.

• Focuses on testing at the boundaries of input ranges

• Helps identify errors that occur at the boundaries

• Tests values at the lower and upper limits of valid ranges

• Reduces the number of test cases needed for thorough testing

To create a job for CI/CD in Jenkins, you can use the Jenkins interface to configure a new job with the necessary build and deployment steps.

• Navigate to Jenkins dashboard and click on 'New Item' to create a new job

• Select the type of job you want to create (Freestyle project, Pipeline, etc.)

• Configure the job settings such as source code repository, build triggers, build steps, and post-build actions

• Set up the job to be ...read more

To fetch data from a table row dynamically, use a unique identifier to locate the row and extract the data.

• Identify a unique identifier for the row, such as an ID or class name

• Use a query selector or XPath to locate the row based on the identifier

• Extract the data from the row using appropriate methods or functions