TSYS- Interview Questions

interview
manager, person, people

TSYS Interview Questions

Collection of TSYS Interview Questions. The section contains a real-time interview experience shared by the interviewees.

Technical Round 1

1. Exception Handling – try, catch, finally
2. finally vs finalize?
3. How to get the links count inside 1 web page?
4. How do you handle Alerts?
5. What is the parent class of Alert
6. How to take Screenshots?
7. What is interface and Abstract class?
8. Why interfaces are used?
9. Program – Method overloading and Method Overriding?
10. What is the usage of final keyword?
11. What is the use of final class? Example of any final class in Java.
12. final int variableName; Will it give any error during compile time?
13. Why static block is used?
——————————
API Testing
1. How to validate the response code is 200, using RestAssured library?
2. PUT vs POST?
3. PUT vs PATCH
4. Different status codes.
——————————
Database Testing
1. Joins
2. Write a query to get list of employees whose Salary is more than 10000.
3. Write a query to get the employee who has max salary.
4. Delete and Employee whose name is John

5. DROP vs DELETE vs TRUNCATE

DROP is a DDL Command. Objects deleted using DROP are permanently lost
and it cannot be rolled back.
Unlike TRUNCATE which only deletes the data of the tables,
the DROP command deletes the data of the table as well as removes the entire schema/structure of the table from the database.

6. DDL vs DML? Can you list any of them?

DML stands for Data Manipulation Language.
DDL statements are used to create database, schema, constraints, users, tables etc.
DML statement is used to insert, update or delete the records.

——————————
Java Programs


1. Class A{
final int number1;
public static void main(String[] args){
System.out.println(number1);
}
}

Initialize final field ‘number1’ at declaration

2. int_Array -> 2nd largest in the array
int[] int_Array={10,32,3,5,47};

3. Write a Program to find whether String is Palindrome or not

String str = “MaDam”;
String rev = “”;
int length = str.length();
for (int i = length – 1; i >= 0; i–)
rev = rev + str.charAt(i);
if (str.equals(rev))
System.out.println(str + ” is a palindrome”);
else
System.out.println(str + ” is not a palindrome”);

Technical Round 2

1. How do you execute only the failed Test cases?
2. Any other way than IRetryAnalyzer, is there a way to achieve the above?
3. Upload a file using AutoIT?
4. What Auto IT and how exactly you are using that in your script?
5. SQL -> GROUP BY, JOINS,
6. static keyword usage (Method, block, variable)

7. Why can’t we override the static method?

Overloading is the mechanism of binding the method call with the method body dynamically
based on the parameters passed to the method call.
Static methods are bonded at compile time using static binding. Therefore, we cannot override static methods in Java

8. OOPS concept in yor Selenium project
——————————
Java Programs

1. int[] int_Array={1,9,8,19,4,1……………1000 items};
Which 3 consecutive no. are there in the Array has maximum sum?
1,2,3 _ 2,3,4 _ 3,4,5 _ ….

2. Input: “I AM in TSYS”
Write a generic way so that I get output as “I AM in TSYS”.

String str = “I AM in TSYS”;
System.out.println(str.replaceAll(“\\s+”, ” “).trim());

3. class Super {
public int index = 1;
}
class App extends Super {
public App(int index) {
index = index;
}
public static void main(String args[]) {
App myApp = new App(10);
System.out.println(myApp.index);
}
}

Output : 1
——————————–
index=index (both are same)
————————————————–

super.index = index;
Then, Output=10;

4. try {
print “1”
// some code throw IOException
}
catch(Exception e)
{
print “2”
}
catch(IOException IO)
{
print “3”
}
finally {
print “4”
}

IOException can not be resolved to a type
—————————-
Output : 1 3 4
try {
System.out.println(“1”);
// some code throw IOException
throw new IOException();
} catch (IOException IO) {
System.out.println(“3”);
} catch (Exception e) {
System.out.println(“2”);
} finally {
System.out.println(“4”);
}

About TSYS

Check more questions on Java, Selenium, Database, API, and Manual testing.