Software Testing

In this article we will learn about Java program to perform excel operations. For QA, it is important to implement data provider using excel sheet in their automation framework and hence this article will come as a handy guide for the QA who are learning framework creation from scratch. we will try to cover all the excel methods and operations here. Java program to perform excel operations Firstly, you need to import POI jars in your workspace. then copy paste below code in your framework in a package called util. package util; import java.io.FileInputStream; public class ExcelRead { public static String filename = "" ; private XSSFSheet worksheet = null; private XSSFRow sheetRow = null; public String path; public FileInputStream fileInput = null; public FileOutputStream fileOutput = null; private XSSFWorkbook workbook = null; private XSSFCell cell = null; public ExcelRead(String path) {          // Constructor declared     this.path =path;     try {          fileInput = new

In this article we will go through some TestNG Annotations and their uses. TestNG Annotations and its uses @BeforeSuite @BeforeTest @BeforeClass @BeforeMethod @Test @AfterMethod @AfterClass @AfterTest @AfterSuite @Guice @Parameters Added in testng.xml file with parameters and value tag after suite/ test tag. Parameters defined at suite level will be applicable for all the tests by default Parameters defined at test level will override the parameters defined at suite level. Not suitable for large scale applications @DataProvider DataProvider is called in the test method with the name. Uses external datasource to import the data. If no DataProvider name is provided, it takes class name by default. TestNG keywords for Test Method priority Can be -ve Default priority is 0. If priority is not mentioned, the sequence of the execution will be based upon the alphabetical order of methods. Only supports @Test method enabled Can be either true or false If defined as false, test method is skipped

In this article we will cover some TestNG output questions which are usually asked in the interview written tests. The questions are bases upon the program execution flow which will help you grasp some grip over it. TestNG Output Questions Guess the output of below program public class AnnotationsSequence { @Test public void f() {     System.out.println("@Test 1 "); } @Test public void f1() {     System.out.println("@Test 2 "); } @BeforeMethod public void beforeMethod() {     System.out.println("@BeforeMethod"); } @AfterMethod public void afterMethod() {     System.out.println("@AfterMethod"); } @BeforeTest public void beforeTest() {     System.out.println("@BeforeTest"); } @AfterTest public void afterTest() {     System.out.println("@Aftertest"); } @BeforeSuite public void beforeSuite() {     System.out.println("BeforeSuite"); } @AfterSuite public void afterSuite() {     System.out.println("@AfterSuite");

In this article we will share the interview process of Garnersoft (CarDekho) Pvt Ltd. for automation testing profile. GarnerSoft(CarDekho) Interview Experience for Automation Testing There will be 4 rounds Written test(using Mettl) Interview questions - 30 Time - 30 mins Sections API Testing Manual testing Selenium code based questions/ Automation Actions Alerts pop-up Xpath based questions Reasoning

In this article, we will cover interview experience at Sapient for Automation Testing profile. We will be sharing questions and answers that is asked often by Sapient recruitment team. Interview Experience at Publicis  Sapient | Automation Testing Profile First Round - Written Second round - Technical Interview Third round - Managerial First round - Written. Mode of test - quizme Questions - 30 Time - 1 hour If you are appearing for the written test of  Publicis  Sapient company, you will be receiving an email from  Publicis Sapient HR from quizme. Before attempting the test, please make sure you know the basic of nested loops, carry a pen and paper along with you because lot of the questions are MCQ based where a program will be written and candidate is asked to predict the output. Practice Java and Selenium: Collections, file handling and loops, etc. Understand the basics of programming. Visit geeksforgeeks to practice mcq and output based questions Access specifiers, object creation

In this article, we will share TSYS Interview experience for SDET profile. Interview Experience at TSYS for SDET profile First Round - Written test Mode of test - Online Questions What is the output of below SQL statement SELECT LPAD("SQL Tutorial", 20,  " ABC"); Solution - ABCABCABSQL Tutorial Explanation - LPAD() function left pads a string with another string, to a certain length Syntax of LPAD - LPAD(string, length, lpad_string ) How do you see Structure of a table in a SQL? Using Describe statement A plane is flying 2400 Kms from Source A to destination B. Speed of the plane is 600 km/hr and speed of the wind tailing it is 40 Km/hr. How many hours after take off would it be faster to go to B than to return to A in case of an emergency? A . 1.65 hours B. 1.5 hours C. 1.75 hours D. 2 hours E. None of these Solution -  Speed from A to B - 640 Km/hr Reverse speed - 560 Km/hr Formula = x/500 >=  (2400-x) / 640 x >= 1120 km. Time taken to cover 1120 km = 1120/

In this article we will be sharing interview experience of 360Logica in Noida for Automation Testing profile. Interview Experience at 360Logica Noida Date - 20th Feb 2021 Company - 360Logica Location - Noida Interviewer - Ankit Round 1  What are your roles and responsibilities in current project? Structure of the test cases in SOAP UI? Explain about the properties in SOAP UI? How can you parameterise the endpoints in SOAP UI? Can be done using properties Difference between API and Webservices? What is URI? Can we use get instead of post? What is the format of URI? URI = scheme:[//authority]path[?query][#fragment] Difference between API and unit testing? API testing focuses on the output of the system under test, it is a kind of blackbox testing. Whereas, unit testing is a kind of whitebox testing where a developer can debug the code to understand the logic. What is StaleElementException? When an element has changed its position. Stale means old element or element doesn't exist anym