Othain Group Lead Analyst Interview Questions and Answers

Q1. Basic question about project , ques. On excel, power bi, scenarios
Add your answer

Q1. Scenario based and projects
Add your answer

Duration two hours, Analytics, Aptitude and General

Q1. What is manual testing and types of testing
Ans. 
Manual testing is a process of testing software manually without using any automated tools.
• Types of manual testing include functional testing, regression testing, integration testing, user acceptance testing, and exploratory testing.

• Functional testing checks if the software meets the specified requirements.

• Regression testing ensures that changes made to the software do not affect its existing functionality.

• Integration ...read more
Answered by AI
View 1 more answer
Q2. What are SQL joins and types
Ans. 
SQL joins are used to combine data from two or more tables based on a related column.
• Types of SQL joins include inner join, left join, right join, and full outer join.

• Inner join returns only the matching rows from both tables.

• Left join returns all rows from the left table and matching rows from the right table.

• Right join returns all rows from the right table and matching rows from the left table.

• Full outer join returns...read more
Answered by AI
Add your answer

Q1. Was asking regarding Java basics and Database Basic
Add your answer

Q1. Management related and communication
Add your answer

Aptitude test on CS subjects like C programming, DBMS, CN, and OS.

There were 2 input-output based questions of easy to moderate level

Every candidate was given an individual topic and was asked to speak on it

Q1. Some typical HR questions
Add your answer

Aptitude round consists Logical reasoning, General Aptitude, Grammar related questions etc. All are moderate level questions.

Q1. Explain OOPs w.r.t Java
Ans. 
OOPs is a programming paradigm that uses objects to represent real-world entities. Java is an OOPs language.
• OOPs stands for Object-Oriented Programming System

• Java is a class-based OOPs language

• Encapsulation, Inheritance, Polymorphism, and Abstraction are the four pillars of OOPs

• Objects have state and behavior

• Java supports interfaces, which allow for multiple inheritance

• Example: A car can be represented as an object wit...read more
Answered by AI
Add your answer
Q2. Explain about the projects that you have worked on
Add your answer
Q3. Explain how Java solves machine dependency of code execution
Ans. 
Java solves machine dependency by using bytecode and virtual machine.
• Java code is compiled into bytecode which is platform-independent

• The bytecode is executed by the Java Virtual Machine (JVM) which is platform-specific

• JVM translates bytecode into machine code for the specific platform

• This allows Java code to run on any platform with a JVM installed

• Example: A Java program compiled on Windows can run on Linux or Mac as
Answered by AI
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Tell me about yourself.
Add your answer