Informatica QA Engineer interview questions

Basic data structure Java Selenium Testing questions according to your prior experience

In round 1, the objective questions are of medium difficulty on the peculiar concepts of OS and DBMS like (ER diagrams, Relational database, transaction management, concurrency control, serializability, conflict resolution, B+ trees etc., in DBMS), (Process flow, Storage allocation, paging, TLB hits, page replacement, Process scheduling and disk scheduling algorithms, deadlocks etc., in OS) and also general question son sorting techniques, bfs&dfs trees, etc., In round 2, four coding questions are given which can be solved either in C or C++ or Java or Csharp. They are of easy-medium difficulty. Designing the logic is much important than usage of data structures and optimizing algorithms, but however optimization gives you extra marks. In technical interview round, there is a 1:1 interview with company personnel. He initially asked me to introduce about myself for a minute and then, went on to ask technical questions. Questions asked me are: *Write a program to print 10 numbers of fibonacci series. *You are given two sand hourglasses. One measures 4 minutes and other measures 7 minutes. What is the least no. of steps required to measure exactly 9 minutes? *Write a SQL query that prints the department names starting with any letter between A and M in the department table.(after answering it) Can we use "LIKE" along with "BETWEEN" in a query ? *State any few UNIX commands. *What is the use of "ps" command in unix ? *What is the purpose of try, catch and finally in java?(after answering) Will finally executes if the try fails ? *What are differences between classes and interfaces ?(after answering) Can a interface extends other interfaces ? *Can we use a static final method in java ? State some differences between static and non-static methods ? *What is difference between a process and thread ?(after answering) Is there any way to execute multiple processes at a time, like threads ? *what is multi-threading ? I didn't make it till Managerial & HR rounds, where my friends said that they focussed on presentation skills, decision-making ability etc..,