Add office photos
Employer?
Claim Account for FREE

Oracle Financial Services Software

3.6
based on 1.2k Reviews
Filter interviews by

10+ Aurobindo Pharma Interview Questions and Answers

Updated 9 Sep 2024
Popular Designations
Q1. Puzzle

Suppose there are N balls. out of which only 1 ball is lighter in weight. You are given a simple balance. Then How many minimum no. of attempts do one take to find out that lighter ball. and how many maxi...read more

Ans.

Minimum number of attempts to find the lighter ball is ceil(log2(N)) and maximum number of attempts is 3.

  • Minimum attempts: ceil(log2(N))

  • Maximum attempts: 3

  • Condition for maximum attempts: N must be greater than or equal to 9

Add your answer
Q2. Third greatest element

Given an array/list 'ARR' of ‘N’ distinct integers, you are supposed to find the third largest element in the given array 'ARR'.

Input Format :
The first line contains a single integer ‘T’...read more
Ans.

The task is to find the third largest element in an array of distinct integers.

  • Read the number of test cases 'T'

  • For each test case, read the number of elements 'N' and the array 'ARR'

  • Sort the array in descending order

  • Return the element at index 2 as the third largest element

View 3 more answers
Q3. Insertion in AVL Tree

Ninja has to implement an ‘AVL_TREE’ from scratch.

He is given ‘N’ values, representing the values of nodes to be inserted. Ninja has to insert these values into the ‘AVL_TREE’ and return i...read more

Ans.

The question asks to implement an AVL_TREE from scratch and insert given values into it.

  • AVL_TREE is a self-balancing binary search tree

  • The height difference between left and right subtrees of all nodes should not be more than one

  • Implement the AVL_TREE data structure and insertion algorithm

  • Return the root of the AVL_TREE after inserting all the nodes

View 1 answer
Q4. SQL Question

Which is the correct SQL query to select the top 5 numbers from the given data?

Ans.

The correct SQL query to select the top 5 numbers from the given data is 'SELECT TOP 5 number FROM table_name ORDER BY number DESC'.

  • Use the 'SELECT' statement to specify the columns you want to retrieve.

  • Use the 'TOP' keyword followed by the number of rows you want to select.

  • Specify the column name in the 'ORDER BY' clause to sort the data in descending order.

Add your answer
Discover Aurobindo Pharma interview dos and don'ts from real experiences
Q5. SQL Question

Asked me to write a query to select some data from large collection of it.

Ans.

Write a query to select data from a large collection.

  • Use the SELECT statement to specify the columns you want to retrieve.

  • Use the FROM clause to specify the table or tables from which to retrieve the data.

  • Use the WHERE clause to specify any conditions that the retrieved data must meet.

  • Use the ORDER BY clause to sort the retrieved data in a specific order.

  • Use the LIMIT clause to limit the number of rows returned, if necessary.

Add your answer

Q6. Reason for selecting certain technologies in the project

Ans.

We selected technologies based on project requirements, team expertise, scalability, and cost-effectiveness.

  • Considered project requirements and objectives

  • Leveraged team expertise in certain technologies

  • Chose scalable technologies for future growth

  • Evaluated cost-effectiveness of different options

Add your answer
Are these interview questions helpful?

Q7. What do you know about Java?

Ans.

Java is a popular programming language used for developing various applications.

  • Java is an object-oriented language

  • It is platform-independent

  • Java code is compiled into bytecode

  • Java has a vast library of pre-built classes and functions

  • Java is used for developing web applications, mobile apps, desktop applications, and more

Add your answer

Q8. Describe Operating System.

Ans.

An operating system is a software that manages computer hardware and software resources.

  • It acts as an interface between the user and the computer hardware.

  • It manages memory, processes, and input/output devices.

  • Examples include Windows, macOS, and Linux.

  • It provides a platform for other software to run on.

  • It ensures security and manages user accounts.

Add your answer
Share interview questions and help millions of jobseekers 🌟

Q9. what is Inheritance in java

Ans.

Inheritance in Java allows a class to inherit properties and behavior from another class.

  • Inheritance enables code reusability and promotes a hierarchical relationship between classes.

  • Subclasses inherit attributes and methods from a superclass.

  • Java supports single and multiple inheritance through classes and interfaces.

  • Example: class Car extends Vehicle {}

Add your answer

Q10. how does hashmap works

Ans.

HashMap is a data structure that stores key-value pairs and allows for fast retrieval of values based on keys.

  • HashMap uses a hash function to map keys to indices in an array.

  • It allows for constant-time retrieval, insertion, and deletion of key-value pairs.

  • Collisions can occur when multiple keys map to the same index, which is resolved using techniques like chaining or open addressing.

Add your answer

Q11. diff between comparator and comparable

Ans.

Comparator is used to define custom sorting order for objects, while Comparable is an interface used to implement natural ordering of objects.

  • Comparator is used to define custom sorting order for objects, while Comparable is used to implement natural ordering of objects

  • Comparator interface has a compare() method, while Comparable interface has a compareTo() method

  • Comparator can be used to sort objects based on multiple criteria, while Comparable can only be used for single cr...read more

Add your answer

Q12. 4 Pillars of OOPS DBMS

Ans.

The 4 pillars of OOPS are Inheritance, Encapsulation, Abstraction, and Polymorphism.

  • Inheritance allows a class to inherit properties and behavior from another class.

  • Encapsulation refers to the bundling of data with the methods that operate on that data.

  • Abstraction focuses on hiding the implementation details and showing only the necessary features of an object.

  • Polymorphism allows objects to be treated as instances of their parent class.

Add your answer
Contribute & help others!
Write a review
Share interview
Contribute salary
Add office photos

Interview Process at Aurobindo Pharma

based on 22 interviews in the last 1 year
3 Interview rounds
Coding Test Round
Technical Round
HR Round
View more
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Associate Consultant Interview Questions from Similar Companies

3.7
 • 165 Interview Questions
3.8
 • 142 Interview Questions
3.7
 • 59 Interview Questions
3.9
 • 28 Interview Questions
3.5
 • 20 Interview Questions
2.4
 • 12 Interview Questions
View all
Share an Interview
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
70 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions
Get AmbitionBox app

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter