Interview Experience at TSYS| SDET profile

-

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/ 560 = 2 hr.
  • What is the command to list the contents of a directory?
    • dir command
    • the ls command(either of this 2 commands)
  • Can we declare constructor as a private?
    • Yes, we can. This approach is used in Singleton Design pattern.
  • Select the command that will not wait for a new page to load before moving onto the next command?
    • A. clickAndWait
    • B. selectAndType
    • C. typeAndWait
    • D. selectAndWait
  • Select the command which is used to print a string value or a variable in the selenium IDE?
    • Answer - echo command
Round 2 - Technical Round

Interviewer will ask you to share your screen and open any IDE, then they will ask you to write 2/3 programs. Please prepare for the programs based questions. Once you write the program, they will ask you to explain it.
  • Write a program to print the count of Consonants and vowels.
    • We have covered it here.
  • Write a program to print the occurrence of a character in a string.
  • Write a program to check whether number entered is prime or not?
  • What do you understand by Constructor?
  • Can Constructor be inherited?
    • No, it cannot be inherited.
  • Can Constructor be declared Private?
    • Yes, constructors can be declared private.
  • Why do we use Super Keyword in Java?
    • Super keyword refers to the superclass(parent) objects. Superclass objects and superclass constructors can be called using Super keyword.
  • Write an SQL query to print the results for Employee table whose name starts with ' A'?
    • Select * from Employee where emp_name like ('A%');
  • Write a SQL query to print the name of the Employees whose second character of the name is ' A'?
    • Select * from Employee where emp_name like ('_A%');
  • How do you left join 2 tables?
  • How do you inner join 2 tables?
  • Difference between Where and Having clause in SQL?
    • Where is used to filter our the rows.
    • Having is used for aggregate functions such as MAX, MIN, SUM, AVG, Count. We can use Group by along with having. 
    • Syntax of Having -
      • Select MAX(Salary) from Employee Having emp_id>105;

Program to print the occurrence of a character in a String

Logic -

The idea is to create a count array of size 256. Traverse input string and for every character increment its count. 

// Java program for the above approach
class NoOfOccurenceOfCharacters {
static final int MAX_CHAR = 256;

static void getOccuringChar(String str)
{
// Create an array of size 256 
// i.e. ASCII_SIZE
int count[] = new int[MAX_CHAR];

int len = str.length();

// Initialize count array index
for (int i = 0; i < len; i++)
count[str.charAt(i)]++;

// Create an array of given String size
char ch[] = new char[str.length()];
for (int i = 0; i < len; i++) {
ch[i] = str.charAt(i);
int count = 0;
for (int j = 0; j <= i; j++) {

// If any matches found
if (str.charAt(i) == ch[j])
count++;
}

if (count == 1)
System.out.println(
"Number of Occurrence of "
+ str.charAt(i)
+ " is:" + count[str.charAt(i)]);
}
}

// Driver Code
public static void main(String[] args)
{
String str = "geeksforgeeks";
getOccuringChar(str);
}
}

Comments

Post a Comment

Popular posts from this blog

Azure Tutorials Series - Azure Networking

-
Image
In this article, we will learn about Azure networking concepts such as architecture, microservices, virtual networks, VPNs, subnet, VPN gateways and most importantly Network Security Group(NSG). All these terms are to be understood if you appearing for AZ900 Microsoft Azure Fundamentals exam. Azure Networking In previous articles we have learnt about Micro- services and how they work, these are alos loosely coupled architecture. Some of the features includes Independent components interact with each other with the help of queues Can be updated and deployed independently Highly scalable Supports Asynchronous messaging N-tier Architecture Supports loosely coupled architecture Application divided into multiple tiers such that higher tier can access lower tier but not vice versa Tiers are re-usable and can be updated or replaced easily without any hassle. Three-tier in general Web Tier(front end) Application tier(back end) Data tier(Storage) Virtual Network Isolated network shared by few g...
Read more

Testing in CI/CD

-
If you are part of testing fraternity you would have heard CI/CD numerous times by now. It's the talk of the software testing town. In this article, we will cover the basics of CI/CD, what actually it is and how it is implemented in software testing. What is continuous integration? In simple terms, development teams can integrate their code into a shared repository. This helps in maintaining code quality and identifying potential issues with the local version of the code at an early stage. What is continuous delivery? Everything that is being continuously merged by the development team, is continuously deployed to the live environment. Continuous delivery is often coined as ‘Continuous Deployment’ as well. Since most developers work in parallel, continuously integrating their code into one repository would mean that the master branch is continuously updated with new features. In order to ensure that there is no compromise in the code quality with so many changes...
Read more

Azure Tutorials Series - IaaS vs PaaS vs SaaS

-
Image
We already have covered Public vs Private vs Hybrid differentiation in the previous article. In this article we will be covering three categories of cloud computing with relevant examples and details. Most of you might already be using these services in your daily day-to-day tasks unaware of the face that your organisation has already started the transition into the cloud. For an example, Office 365 is a active SaaS(Software as a service) that most of us uses, VMs are examples of IaaS(Infrastructure as a service) and Azure SQL Database is PaaS(Platform as a service). Now how do we differentiate between the three categories as a user? Will cover the details below. Infrastructure as a Service(IaaS) Service provider provides you the hardware User gets some control over the hardware, can customise operating system, storage and VMs. Ensuring service is up and running is shared responsibility While cloud provider makes sure that the hardware is functioning correctly, user needs to make sure ...
Read more