Interview Question - How to run same test case multiple times

In this blog, We will see how to run same test case multiple times. We can run same test case multiple times with help of @Test attribute 'invocationCount'.

@Test(invocationCount=?):

This invocationCount determined how many times TestNG should run this particular test method.

Example:

@Test(invocationCount = 2)
public void repeatTest()
{
     System.out.println("Execute Test 2 times");
}

Output:

The repeatTest() method will run 2 times.

Execute Test 2 times
Execute Test 2 times

PASSED: repeatTest
PASSED: repeatTest

Now let's see how to use invocationCount in Selenium script with the example.

import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import org.testng.Assert;
import org.testng.annotations.Test;

public class RunSameTestMultipleTimes 
{
@Test(invocationCount = 2)
public void loadApplication()
{
WebDriver driver = new FirefoxDriver();
driver.get("http://www.google.com");
System.out.println("Page Title is " +driver.getTitle());
Assert.assertEquals("Google",driver.getTitle());
driver.close();
driver.quit();
}
}

Output:

You will notice that Firefox browser will prompt out and close 2 times.

Page Title is Google
Page Title is Google

PASSED: loadApplication
PASSED: loadApplication

Javascript in Selenium Web-driver

Hello All,

Welcome to Software Testing Made Life Easy blog. In this post, we will see how we can introduce Javascript in Selenium Webdriver.

What is Javascript?

Javascript is one of the programming languages of the Web and It is a lightweight programming language and most commonly used as a part of web pages.

All modern HTML pages are using JavaScript.

Use of Javascript in Selenium Webdriver:

We have used Java in our script and we have implemented almost all features but some features can’t be handled by Java. So we need scripting language which can control server side & client side scripting. That's why JavaScript comes into the picture.

Implement Javascript in Selenium Webdriver:

To implement Javascript in our selenium script, We don't need to write the separate code because we have a predefined interface available in package org.openqa.selenium.JavascriptExecutor.

Inside this, We have some predefined method called executeScript() - Whatever script you will pass as a 'String', those will be executed by JavascriptExecutor.

Example:

import org.openqa.selenium.JavascriptExecutor;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;

public class JavaScriptTestCase
{
public static void main(String[] args) throws InterruptedException
{
WebDriver driver=new FirefoxDriver();
System.out.println("Launching Browser");
driver.manage().window().maximize();
driver.get("https://software-testing-made-lifeeasy.blogspot.in");
((JavascriptExecutor)driver).executeScript("document.getElementById('s').value='Balaji'");
}
}

Interview Question - What are the difference between web app and mobile app?

Mobile App:

A Mobile App is an application developed essentially for a particular handset and it will be installed directly onto the device.

Web App:

Basically, Internet-enabled apps that are accessible via the mobile device’s Web browser.

Accessibility:

A mobile app is totally compatible with the device’s hardware and native features, such as the GPS, the accelerometer, the compass, the list of contacts, and so on.

On the other hand, Web app can access only a limited amount of the device’s native features.

Upgradability:

A web app is much more dynamic than a mobile app in terms of updating the content.

Efficiency:

Mobile apps are more expensive to develop. However, they are faster and more efficient. Users can access the app only via the app store.

Web apps may result in higher costs of maintenance across multiple platforms. Also, there is no specific authority to control the quality of these apps.

Reach:

A web app is accessible across platforms and can be easily shared among users, as well as search engines, it has considerably greater reach than a mobile app.

User Interface:

Both the mobile apps and the web apps look and work the same way with a very little difference (The choice and decision is up to you 😊) 

Feel free to share your valuable feedback.Thanks.

Challenges we faced in Selenium Automation Testing

I work on Selenium Automation Testing and one of the major challenging tasks which I faced was, After invoking the application URL on any browser, it was required to authenticate the window based pop-up as below. The first challenge was selenium doesn't handle windows based pop-ups.

The solution is AutoIt tool (Click here!)

I wrote code using AutoIt which can easily handle the window based pop-up to enter credentials.

About AutoIt tool:

AutoIt is a tool where we can capture window based objects and write a simple AutoIt script. Once we compile & Run the AutoIt script file, It will generate the .exe file and which can be invoked within our selenium automation scripts.

Now, all we need to do is call the .exe soon after invoking the application URL. Please refer the sample code below

driver.get("application URL");

Runtime.getRuntime().exec("path where the .exe file exists");

Now the actual problem was AutoIt code was not getting triggered after invoking the application URL - driver.get("application URL").

Please find the solution to the above problem:

Subsequent lines of code will not execute unless execution of driver.get("application URL") method is complete. We found out that driver.get("application URL") was not getting completed unless we complete the window based pop-up operation.

The only solution is to run both driver.get("application URL") method and AutoIT code in parallel. This can be achieved with help of Java multi-threading.

After invoking the application URL, We will be giving control to window based pop-up and due to parallel execution, AutoIt.exe code will trigger and enter the credentials in a window based pop-up and completes the operation. Due to this, driver.get("application URL") method will also gets completed.

Code:

driver.get("application URL");

AUTOIT startExe=new AUTOIT ();

Thread t1 =new Thread(startExe);

t1.start();

Finally, I solved the issue.

Feel free to share your valuable feedback.Thanks.

Basic SQL Interview Questions & Answers for Software Testers

1. What is the difference between Delete and Drop commands?

Delete Command:

• Delete removes the data from the table and the structure of the table will be retained.
• This is a DML command.
• Rollback is possible.

Drop Command:

• Drop permanently removes both the data as well as the structure of the table.
• This is a DDL command.
• Rollback is not possible.

2. What is the difference between Delete and Truncate commands?

Delete Command:

• Delete command deletes only the rows from the table based on the condition given in the where clause and also it deletes all the rows from the table if no condition is specified.
• It does not free the space containing the table.

Truncate Command:

• Truncate command is used to delete all the rows from the table and free the space containing the table.

3. What is a primary key?

A primary key is a combination of fields which uniquely specify a row. Primary key values cannot be NULL.

4. What is a foreign key?

The relationship needs to be created between two tables by referencing foreign key with the primary key of another table.

5. What is Joins in SQL?

Joins are used to combines the results of two tables. It combines the data based on the relationship between tables.

6. What are the different types of joins in SQL?

Following are the most commonly used joins in SQL:

1. Inner Join
2. Right Join
3. Left Join
4. Full Join
5. Left Outer Join
6. Right Outer Join

7. What is Inner Join in SQL?

Inner join returns matching rows between the two tables.

8. What is the difference between BETWEEN and IN condition operators?

The BETWEEN operator is used to display the rows based on a range of values. 

Examples:

Select * from blogs where pageviews BETWEEN 10 AND 20;

The IN condition operator is used to check for values contained in a specific set of values.

Examples:

Select * from blogs where country IN ('Germany', 'France', 'UK');

9. Is it possible for a table to have more than one foreign key? 

Yes, A table can have many foreign keys and only one primary key.

Top 10 Agile Interview Questions & Answers

1. What is agile methodology and its advantage?

Agile methodology is the continuous iteration of both development and testing activity throughout the software development lifecycle.

Advantage:
The customer gets a chance to look at the product very frequently and make the decision wisely.

2. Tell me the agile ceremonies?

• Sprint Planning Meeting.
• Daily Scrum Meeting.
• Sprint Review Meeting.
• Sprint Retrospective Meeting,

3. Tell me the agile artifacts?

• Product Backlog.
• Sprint Backlog.
• Product Increment.

4. What is Epic and User-story in agile?

Epic: Epic means big user story and it generally takes two or more sprints to develop and test the particular epic. They are usually broad in scope.

User-story: User-stories are derived from Epic and It has a high-level definition of a requirement.

5. What is burndown chart?

Burndown chart generally shows how quickly and effectively we completing our user stories in each iteration and also, it shows the total amount of work we deliver in each iteration.

6. Difference between Product Backlog and Sprint Backlog?

Product Backlog: Product Backlog is a list where all the details(Epics, User stories) are available to get the end product.

Sprint Backlog: Sprint Backlog generally derived from Product Backlog. During iteration, We will be selecting the stories from the product backlog.

7. What is Definition of Done (DOD)?

Definition of Done is a checklist that is required to develop the product and it's adding value to the product.

Checklists are:

1. Design Documents.
2. Coding.
3. Review Comments.
4. Unit Testing.
5. Release Notes.

8. What is Product Increment?

At end of the sprint, The newly developed product must be in usable condition and it should meet the 'Definition of Done' and 'Acceptance Criteria'.

9. What is Sprint Retrospective meeting?

During the 'Sprint Retrospective' meeting, The team will discuss what happended in the iteration and also identifies the list of actions that are needed for improvement going forward.

10. How do you deal when requirements are keeps on changing?

I work closely with Product Owner to understand the changes and then update the test plan & test cases (Initially better to write generic test plan & test cases). Please don't go for automation until requirements are finalized.

Test Management Tool - Zephyr

   Import Bulk Test Cases from Excel into JIRA

   1. Launch the Zephyr.jar file.

   2. Enter the Project JIRA URL.

   3. Enter the Username and Password.

   4. Click on Connect.

   5. You can see your current project in the Project drop-down list.

   6. Choose the Issue Type as “Test” in the Issue Type drop-down list.

   7. Click on Discriminator drop-down list and choose as “By Test-case name change”.

   8. Mention the starting row as “2”.

   9. In the JIRA Field table, you can see the required columns for your project.

   10. Create the test case’s in excel with the columns displayed in the JIRA Field Table.

    a.*-Mandatory one.

   11. In the Excel Column Table, we need to Map the excel fields to the proper JIRA fields. To do so, mention the column ids.Example: A, B, C etc..,

   12. Click on Pick Import File button and import the excel sheet.

   13. Click on Start Import button.